APPS.ICX_REQ_NAVIGATION dependencies on ICX_SHOPPING_CARTS

Line 1013: from icx_shopping_carts_v

1009: ------------------------------------------------------------
1010:
1011: cursor DETERMINE_CART(v_cart_id number, v_shopper_id number) is
1012: select count(-1)
1013: from icx_shopping_carts_v
1014: where cart_id = v_cart_id
1015: and shopper_id = v_shopper_id;
1016:
1017: --change by alex for attachment

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 1147: insert into icx_shopping_carts (

1143: else
1144: l_emer := 'Y';
1145: end if;
1146:
1147: insert into icx_shopping_carts (
1148: cart_id,
1149: last_update_date,
1150: last_updated_by,
1151: creation_date,

Line 1469: -- select icx_shopping_carts_s.nextval

1465: l_emer := 'N';
1466: end if;
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

Line 1478: insert into icx_shopping_carts (

1474: into v_cart_id
1475: from sys.dual;
1476:
1477:
1478: insert into icx_shopping_carts (
1479: cart_id,
1480: last_update_date,
1481: last_updated_by,
1482: creation_date,