OraFAQ Forum: Forms » when - tree

Home » Developer & Programmer » Forms » when - tree - node -select

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

when - tree - node -select [message #277759]

Wed, 31 October 2007 07:03

roni_a180
Messages: 45
Registered: October 2007

Member

i write following code,when the node select the selected form is open.

but my problem is when i select the node then the particular form is open , but then i change the node first time open the previous selected node form then open present selected node form

pls anybody help me????????

DECLARE
   NODE_VALUE    VARCHAR2(20);
   v_showalert   NUMBER;
   htree         ITEM;
   v_id          NUMBER;
   v_call        VARCHAR2(500);
BEGIN
   v_id           := '';
   NODE_VALUE     := '';
   v_call         := '';
   htree          := FIND_ITEM('BLOCK17.T_POP');
   NODE_VALUE     :=
      FTREE.GET_TREE_NODE_PROPERTY('BLOCK17.T_POP'
                                 , :SYSTEM.TRIGGER_NODE
                                 , FTREE.NODE_LABEL
                                  );
   v_showalert    := showalert(NODE_VALUE, 1);
   v_call         := '';

   SELECT DISTINCT MENUACTIONID
   INTO            v_id
   FROM            MENUGROUPITEM
   WHERE           LTRIM(RTRIM(MENUCAPTION)) = LTRIM(RTRIM(NODE_VALUE));

   SELECT ACTIONCLASS
   INTO   v_call
   FROM   MENUACTION
   WHERE  ID = v_id;

   CALL_FORM(v_call);
EXCEPTION
   WHEN OTHERS
   THEN
      NULL;
END;

[mod-edit]applied code tags.

[Updated on: Wed, 31 October 2007 08:02] by Moderator

Report message to a moderator