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.ICX_REQ_ORDER dependencies on ICX_SHOPPING_CART_LINES

Line 485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);

481: begin
482:
483: l_language_code := icx_sec.getID(icx_sec.pv_language_code);
484: l_multirow_color := icx_util.get_color('TABLE_DATA_MULTIROW');
485: -- icx_util.getprompts(601, 'ICX_SHOPPING_CART_LINES_R', c_title, c_prompts);
486: icx_util.getprompts(601, 'ICX_LOV', c_title, c_prompts);
487:
488: for r in 0..ak_query_pkg.g_results_table.LAST loop
489:

Line 705: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV1(''178'',''ICX_SUGGESTED_VENDOR_NAME'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''','''

701: end if;
702:
703: if ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' then
704:
705: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV1(''178'',''ICX_SUGGESTED_VENDOR_NAME'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''','''
706: || to_char(l_pos) || ''',''' || to_char(l_pos + 1) || ''',''' || to_char(l_pos + 2) || ''',''' || to_char(l_pos + 3) || ''')',htf.img('/OA_MEDIA/'
707: ||l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''
708: || icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
709:

Line 712: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV2(''178'',''ICX_DELIVER_TO_LOCATION_L'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' ||

708: || icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
709:
710: elsif ak_query_pkg.g_items_table(i).attribute_code = 'ICX_DELIVER_TO_LOCATION_L' then -- must be location LOV
711:
712: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV2(''178'',''ICX_DELIVER_TO_LOCATION_L'',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' ||
713: to_char(l_org_id_pos) || ''',''' || to_char(l_loc_id_pos) || ''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||l_language_code||
714: '/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''|| icx_util.replace_onMouseOver_quotes(c_title) ||''';return true"'), crowspan => 2);
715:
716: -- user has LOV

Line 727: ''',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||

723: ak_query_pkg.g_items_table(i).attribute_code <> 'ICX_DEST_ORG_ID_L' then
724:
725:
726: htp.tableData(cvalue => htf.anchor('javascript:PRE_LOV0(''178'',''' || ak_query_pkg.g_items_table(i).attribute_code ||
727: ''',''601'',''ICX_SHOPPING_CART_LINES_R'',''LOVFIELDS'',''my_order1'','''','''',''' || to_char(l_pos) || ''')',htf.img('/OA_MEDIA/'||
728: l_language_code||'/FNDILOV.gif','LEFT',c_title,'','BORDER=0 WIDTH=22 HEIGHT=22'),'','onMouseOver="window.status='''||
729: icx_util.replace_onMouseOver_quotes(c_title) || ''';return true"'), crowspan => 2);
730:
731: end if;

Line 1793: from icx_shopping_cart_lines

1789: l_dist_num number;
1790:
1791: cursor get_line_number(v_cart_id number,v_cart_line_id number) is
1792: select cart_line_number
1793: from icx_shopping_cart_lines
1794: where cart_id = v_cart_id
1795: and cart_line_id = v_cart_line_id;
1796:
1797: cursor get_dist_number(v_cart_id number,v_cart_line_id number,v_org_id number) is

Line 1823: update icx_shopping_cart_lines

1819: from icx_shopping_carts
1820: where cart_id = l_cart_id
1821: for update;
1822:
1823: update icx_shopping_cart_lines
1824: set cart_line_number = cart_line_number + 1
1825: where cart_id = l_cart_id
1826: and cart_line_number > l_cart_line_number;
1827:

Line 1830: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;

1826: and cart_line_number > l_cart_line_number;
1827:
1828: l_cart_line_number := l_cart_line_number + 1;
1829: --changed by alex for attachment
1830: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id from dual;
1831: --new code:
1832: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
1833:
1834:

Line 1835: insert into icx_shopping_cart_lines

1831: --new code:
1832: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id from dual;
1833:
1834:
1835: insert into icx_shopping_cart_lines
1836: (CART_LINE_ID, CART_LINE_NUMBER,LAST_UPDATE_DATE, LAST_UPDATED_BY,
1837: CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN,
1838: CART_ID, ITEM_ID, ITEM_REVISION,
1839: UNIT_OF_MEASURE, QUANTITY, UNIT_PRICE,

Line 1873: from icx_shopping_cart_lines

1869: NEED_BY_DATE, AUTOSOURCE_DOC_HEADER_ID, AUTOSOURCE_DOC_LINE_NUM,
1870: PROJECT_ID,TASK_ID , EXPENDITURE_ITEM_DATE,
1871: SUGGESTED_VENDOR_CONTACT, SUGGESTED_VENDOR_PHONE, SUGGESTED_VENDOR_ITEM_NUM,
1872: EXPENDITURE_ORGANIZATION_ID,ORG_ID,EXPRESS_NAME,ITEM_NUMBER,CUSTOM_DEFAULTED
1873: from icx_shopping_cart_lines
1874: where cart_line_id = cartLineId
1875: and cart_id = l_cart_id;
1876: -- and nvl(l_org_id,-9999) = nvl(org_id,-9999);
1877:

Line 1992: from icx_shopping_cart_lines

1988: l_dummy number;
1989:
1990: cursor get_line_number(v_cart_id number,v_cart_line_id number) is
1991: select cart_line_number
1992: from icx_shopping_cart_lines
1993: where cart_id = v_cart_id
1994: and cart_line_id = v_cart_line_id;
1995:
1996:

Line 2017: delete from icx_shopping_cart_lines

2013: from icx_shopping_carts
2014: where cart_id = l_cart_id
2015: for update;
2016:
2017: delete from icx_shopping_cart_lines
2018: where cart_line_id = cartLineId
2019: and cart_id = l_cart_id;
2020: -- and nvl(org_id,-9999) = nvl(l_org_id,-9999);
2021:

Line 2026: update icx_shopping_cart_lines

2022: delete from icx_cart_line_distributions
2023: where cart_line_id = cartLineId
2024: and cart_id = l_cart_id;
2025:
2026: update icx_shopping_cart_lines
2027: set cart_line_number = cart_line_number - 1
2028: where cart_id = l_cart_id
2029: and cart_line_number > l_cart_line_number;
2030:

Line 2274: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';

2270: updateCarts;
2271:
2272: if v_emergency = 'YES' then
2273: v_header_region := 'ICX_SHOPPING_CART_HEADER_EMG_R';
2274: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';
2275: else
2276: v_header_region := 'ICX_SHOPPING_CART_HEADER_R';
2277: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';
2278: end if;

Line 2277: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';

2273: v_header_region := 'ICX_SHOPPING_CART_HEADER_EMG_R';
2274: v_lines_region := 'ICX_SHOPPING_CART_LINES_EMG_R';
2275: else
2276: v_header_region := 'ICX_SHOPPING_CART_HEADER_R';
2277: v_lines_region := 'ICX_SHOPPING_CART_LINES_R';
2278: end if;
2279:
2280: -- Cart Lines Related Object Navigator
2281: ak_query_pkg.exec_query(P_PARENT_REGION_APPL_ID => 601,