eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ORACLECONFIGURE dependencies on ICX_PAGE_PLUGS

Line 69: select icx_page_plugs_s.nextval

65: where session_id = icx_sec.g_session_id;
66:
67: if (p_page_type = 'MAIN') then
68:
69: select icx_page_plugs_s.nextval
70: into l_plug_id
71: from sys.dual;
72:
73: BEGIN

Line 94: insert into icx_page_plugs

90: RAISE e_nls_not_installed;
91:
92: END;
93: l_display_name:=NULL; -- mputman added 1405228
94: insert into icx_page_plugs
95: (plug_id,
96: page_id,
97: display_sequence,
98: responsibility_id,

Line 300: from icx_page_plugs

296: l_web_html_call varchar2(2000);
297:
298: cursor pluglist is
299: select *
300: from icx_page_plugs
301: where page_id = p_page_id;
302:
303: begin
304:

Line 355: delete from icx_page_plugs

351: end if; --thisplug.menu_id <> -1
352:
353: end loop;
354:
355: delete from icx_page_plugs
356: where page_id = p_page_id;
357:
358: delete from icx_pages
359: where page_id = p_page_id;

Line 740: from icx_page_plugs ipp,

736: fff.function_id,
737: fff.web_html_call,
738: ipp.display_sequence,
739: fme.menu_id
740: from icx_page_plugs ipp,
741: fnd_menu_entries_vl fme,
742: fnd_form_functions fff
743: where ipp.region_id = p_region.region_id
744: and ipp.page_id = p_page_id

Line 756: ICX_PAGE_PLUGS b

752: a.web_html_call,
753: b.display_sequence,
754: b.menu_id
755: from FND_FORM_FUNCTIONS_VL a,
756: ICX_PAGE_PLUGS b
757: where b.PAGE_ID = p_page_id
758: and b.MENU_ID = -1
759: and b.ENTRY_SEQUENCE = a.FUNCTION_ID
760: and a.type in ('WWL','WWLG', 'WWR', 'WWRG')

Line 1304: from icx_page_plugs ipp,

1300:
1301: begin
1302: select nvl(ipp.DISPLAY_NAME, fme.PROMPT)
1303: into l_plug_name
1304: from icx_page_plugs ipp,
1305: fnd_menu_entries_vl fme,
1306: fnd_form_functions fff
1307: where ipp.plug_id = p_plug_id
1308: and ipp.menu_id = fme.menu_id

Line 1321: ICX_PAGE_PLUGS b

1317: begin
1318: select nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME)
1319: into l_plug_name
1320: from FND_FORM_FUNCTIONS_VL a,
1321: ICX_PAGE_PLUGS b
1322: where b.plug_id = p_plug_id
1323: and b.MENU_ID = -1
1324: and b.ENTRY_SEQUENCE = a.FUNCTION_ID;
1325: exception

Line 1424: update icx_page_plugs

1420: p_plug_name in varchar2) is
1421:
1422: begin
1423:
1424: update icx_page_plugs
1425: set display_name = p_plug_name
1426: where plug_id = p_plug_id;
1427:
1428: if instr(owa_util.get_cgi_env('HTTP_USER_AGENT'),'MSIE') = 0

Line 1497: from icx_page_plugs ipp,

1493: ipp.plug_id,
1494: nvl(ipp.DISPLAY_NAME, fme.PROMPT) plug_name,
1495: fff.web_html_call,
1496: ipp.display_sequence
1497: from icx_page_plugs ipp,
1498: fnd_menu_entries_vl fme,
1499: fnd_form_functions fff
1500: where ipp.region_id = p_region_id
1501: and ipp.page_id = p_page_id

Line 1512: ICX_PAGE_PLUGS b

1508: nvl(b.DISPLAY_NAME,a.USER_FUNCTION_NAME) plug_name,
1509: a.web_html_call,
1510: b.display_sequence
1511: from FND_FORM_FUNCTIONS_VL a,
1512: ICX_PAGE_PLUGS b
1513: where b.PAGE_ID = p_page_id
1514: and b.MENU_ID = -1
1515: and b.ENTRY_SEQUENCE = a.FUNCTION_ID
1516: and a.type in ('WWL','WWLG', 'WWR', 'WWRG')

Line 1684: for x in (select * from icx_page_plugs where region_id = p_region_id) loop

1680: begin
1681:
1682: l_index := 1;
1683: -- construct the list of plugs current in the db for this region
1684: for x in (select * from icx_page_plugs where region_id = p_region_id) loop
1685: l_oldrightids(l_index) := '*' || x.plug_id;
1686: l_index := l_index + 1;
1687: end loop;
1688:

Line 1715: delete from icx_page_plugs

1711: end if;
1712: end loop;
1713:
1714: if (not l_preserve_plug) then --plug is no longer in the selections, delete it
1715: delete from icx_page_plugs
1716: where plug_id = substr(l_oldrightids(i), 2, length(l_oldrightids(i)) );
1717:
1718: delete from icx_custom_menu_entries
1719: where plug_id = substr(l_oldrightids(i), 2, length(l_oldrightids(i)) );

Line 1824: select icx_page_plugs_s.nextval into l_plug_id from dual;

1820: where c.menu_id = p_menu_id
1821: and c.entry_sequence = p_entry_sequence;
1822: */
1823: l_display_name:=NULL;--mputman added 1405228
1824: select icx_page_plugs_s.nextval into l_plug_id from dual;
1825:
1826: insert into ICX_PAGE_PLUGS
1827: (PLUG_ID,
1828: PAGE_ID,

Line 1826: insert into ICX_PAGE_PLUGS

1822: */
1823: l_display_name:=NULL;--mputman added 1405228
1824: select icx_page_plugs_s.nextval into l_plug_id from dual;
1825:
1826: insert into ICX_PAGE_PLUGS
1827: (PLUG_ID,
1828: PAGE_ID,
1829: DISPLAY_SEQUENCE,
1830: RESPONSIBILITY_APPLICATION_ID,

Line 1874: update icx_page_plugs set display_sequence = p_display_sequence

1870: as
1871: begin
1872: begin
1873:
1874: update icx_page_plugs set display_sequence = p_display_sequence
1875: where plug_id = p_instanceid;
1876: commit;
1877: exception
1878: when others then

Line 1910: delete from icx_page_plugs where plug_id = p_instanceid;

1906: || '(:session_id, :plug_id, null, ''Y''); end;'
1907: using in icx_sec.g_session_id, in p_instanceid;
1908: end if;
1909:
1910: delete from icx_page_plugs where plug_id = p_instanceid;
1911: commit;
1912:
1913: exception
1914: when others then