APPS.ICX_REQ_NAVIGATION dependencies on DUAL

Line 1019: -- select icx_shopping_Carts_s.nextval from sys.dual;

1015: and shopper_id = v_shopper_id;
1016:
1017: --change by alex for attachment
1018: -- cursor getCartId is
1019: -- select icx_shopping_Carts_s.nextval from sys.dual;
1020: --new code:
1021: cursor getCartId is
1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;
1023:

Line 1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;

1018: -- cursor getCartId is
1019: -- select icx_shopping_Carts_s.nextval from sys.dual;
1020: --new code:
1021: cursor getCartId is
1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;
1023:
1024:
1025: cursor getDate(increment number) is
1026: SELECT sysdate+increment from sys.dual;

Line 1026: SELECT sysdate+increment from sys.dual;

1022: select PO_REQUISITION_HEADERS_S.nextval from sys.dual;
1023:
1024:
1025: cursor getDate(increment number) is
1026: SELECT sysdate+increment from sys.dual;
1027:
1028: v_cart_id number;
1029: v_language varchar2(30);
1030:

Line 1471: -- from sys.dual;

1467:
1468: --changed by alex for attachment
1469: -- select icx_shopping_carts_s.nextval
1470: -- into v_cart_id
1471: -- from sys.dual;
1472: --new code:
1473: select PO_REQUISITION_HEADERS_S.nextval
1474: into v_cart_id
1475: from sys.dual;

Line 1475: from sys.dual;

1471: -- from sys.dual;
1472: --new code:
1473: select PO_REQUISITION_HEADERS_S.nextval
1474: into v_cart_id
1475: from sys.dual;
1476:
1477:
1478: insert into icx_shopping_carts (
1479: cart_id,

Line 1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;

1610:
1611: l_cart_line_number := l_cart_line_number + 1;
1612:
1613: --changed by alex for attachment
1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;
1615: -- new code:
1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;
1617:
1618:

Line 1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;

1612:
1613: --changed by alex for attachment
1614: -- select icx_shopping_cart_lines_s.nextval into v_cart_line_id from dual;
1615: -- new code:
1616: select PO_REQUISITION_LINES_S.nextval into v_cart_line_id from dual;
1617:
1618:
1619: insert into icx_shopping_cart_lines (
1620: cart_line_id,

Line 1749: select icx_cart_line_distributions_s.nextval into v_line_dist_id from dual;

1745: and cart_line_id = v_cart_line_id;
1746:
1747: end if;
1748:
1749: select icx_cart_line_distributions_s.nextval into v_line_dist_id from dual;
1750: l_dist_num := l_dist_num + 1;
1751:
1752: insert into icx_cart_line_distributions
1753: (cart_line_id,

Line 1815: -- Update the invidual segments from the account id.

1811: WHERE cart_id = v_cart_id
1812: AND cart_line_id = v_cart_line_id
1813: AND distribution_id = distribution.distribution_id;
1814:
1815: -- Update the invidual segments from the account id.
1816: -- This need to done because the invidual segments are not
1817: -- available from po_req_distributions table.
1818: icx_req_acct2.update_account_by_id( v_cart_id => v_cart_id,
1819: v_cart_line_id => v_cart_line_id,

Line 1816: -- This need to done because the invidual segments are not

1812: AND cart_line_id = v_cart_line_id
1813: AND distribution_id = distribution.distribution_id;
1814:
1815: -- Update the invidual segments from the account id.
1816: -- This need to done because the invidual segments are not
1817: -- available from po_req_distributions table.
1818: icx_req_acct2.update_account_by_id( v_cart_id => v_cart_id,
1819: v_cart_line_id => v_cart_line_id,
1820: v_oo_id => v_org_id,