APPS.ICX_REQ_NAVIGATION dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 1126: FROM po_unique_identifier_control

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;
1129:
1130: UPDATE po_unique_identifier_control

Line 1130: UPDATE po_unique_identifier_control

1126: FROM po_unique_identifier_control
1127: WHERE table_name = 'PO_REQUISITION_HEADERS'
1128: FOR UPDATE OF current_max_unique_identifier;
1129:
1130: UPDATE po_unique_identifier_control
1131: SET current_max_unique_identifier =
1132: current_max_unique_identifier+1
1133: WHERE table_name = 'PO_REQUISITION_HEADERS';
1134:

Line 1426: from po_unique_identifier_control

1422: -- get a new requisition number
1423:
1424: select to_char(current_max_unique_identifier +1)
1425: into v_req_num
1426: from po_unique_identifier_control
1427: WHERE table_name = 'PO_REQUISITION_HEADERS'
1428: FOR UPDATE OF current_max_unique_identifier;
1429:
1430: UPDATE po_unique_identifier_control

Line 1430: UPDATE po_unique_identifier_control

1426: from po_unique_identifier_control
1427: WHERE table_name = 'PO_REQUISITION_HEADERS'
1428: FOR UPDATE OF current_max_unique_identifier;
1429:
1430: UPDATE po_unique_identifier_control
1431: SET current_max_unique_identifier = current_max_unique_identifier+1
1432: WHERE table_name = 'PO_REQUISITION_HEADERS';
1433:
1434: commit;