DBA Data[Home] [Help]

APPS.ICX_REQ_NAVIGATION dependencies on ICX_CART_DISTRIBUTIONS

Line 1124: icx_cart_distributions_s.nextval

1120: -- get a requisition number
1121:
1122: SELECT to_char(current_max_unique_identifier +1),
1123: sysdate,
1124: icx_cart_distributions_s.nextval
1125: INTO v_req_num, v_sysdate, v_dist_id
1126: FROM po_unique_identifier_control
1127: WHERE table_name = 'PO_REQUISITION_HEADERS'
1128: FOR UPDATE OF current_max_unique_identifier;

Line 1188: insert into icx_cart_distributions (

1184: v_req_num,
1185: l_emer,
1186: v_oo_id);
1187:
1188: insert into icx_cart_distributions (
1189: cart_id,
1190: DISTRIBUTION_ID,
1191: LAST_UPDATED_BY,
1192: LAST_UPDATE_DATE,

Line 1582: insert into icx_cart_distributions

1578: '',
1579: '');
1580:
1581: -- insert a default req distribtuion line
1582: insert into icx_cart_distributions
1583: (cart_id,
1584: distribution_id,
1585: last_updated_by,
1586: last_update_date,

Line 1593: icx_cart_distributions_s.nextval,

1589: created_by,
1590: org_id)
1591: select
1592: v_cart_id,
1593: icx_cart_distributions_s.nextval,
1594: rh.last_updated_by,
1595: sysdate,
1596: rh.created_by,
1597: sysdate,