DBA Data[Home] [Help]

APPS.ICX_REQ_TEMPLATES dependencies on DUAL

Line 1233: -- from dual;

1229: l_line_id := v_sequence_num(i);
1230:
1231: --changed by alex for attachment
1232: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id
1233: -- from dual;
1234: --new code:
1235: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id
1236: from dual;
1237: /* get contact id for deliver_to_requestor */

Line 1236: from dual;

1232: -- select icx_shopping_cart_lines_s.nextval into l_cart_line_id
1233: -- from dual;
1234: --new code:
1235: select PO_REQUISITION_LINES_S.nextval into l_cart_line_id
1236: from dual;
1237: /* get contact id for deliver_to_requestor */
1238: v_requestor_id := icx_sec.getID(icx_sec.PV_INT_CONTACT_ID);
1239:
1240: ICX_REQ_NAVIGATION.shopper_info(v_requestor_id,