[Home] [Help]
679: -- see if display name is associated with navigate plug with a value of -1
680: begin
681: select display_name
682: into l_name
683: from icx_page_plugs a,
684: icx_pages b
685: where b.user_id = icx_sec.g_user_id
686: and b.page_id = a.page_id
687: and a.page_id = l_page_id
702:
703: begin
704: select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
705: into l_name
706: from icx_page_plugs ipp,
707: fnd_menu_entries_vl fme,
708: fnd_form_functions fff
709: where ipp.page_id = l_page_id
710: and ipp.menu_id = fme.menu_id
722:
723: begin
724: select DISPLAY_NAME
725: into l_name
726: from ICX_PAGE_PLUGS a,
727: ICX_PAGES b
728: where b.USER_ID = icx_sec.g_user_id
729: and b.PAGE_ID = a.PAGE_ID
730: and a.RESPONSIBILITY_ID = -1
748:
749: begin
750: select distinct NVL(ipp.DISPLAY_NAME, fme.prompt)
751: into l_name
752: from icx_page_plugs ipp,
753: fnd_menu_entries_vl fme,
754: fnd_form_functions fff
755: where ipp.menu_id = fme.menu_id
756: and ipp.entry_sequence = fme.entry_sequence
771: else
772: BEGIN
773: SELECT display_name
774: INTO l_name
775: FROM icx_page_plugs
776: WHERE plug_id= D;
777: EXCEPTION
778: WHEN OTHERS THEN
779: