DBA Data[Home] [Help]

APPS.ICX_REQ_SUBMIT dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 1015: FROM po_unique_identifier_control

1011: and shopper_id = shopperId;
1012:
1013:
1014: CURSOR C3 IS SELECT to_char(current_max_unique_identifier + 1)
1015: FROM po_unique_identifier_control
1016: WHERE table_name = 'PO_HEADERS'
1017: FOR UPDATE OF current_max_unique_identifier;
1018:
1019: begin

Line 1119: UPDATE po_unique_identifier_control

1115: if l_po_number is NULL and
1116: user_action <> 'MODIFY' and user_action <> 'ATTACHMENT' then
1117: open C3;
1118: fetch C3 into l_po_number;
1119: UPDATE po_unique_identifier_control
1120: SET current_max_unique_identifier =
1121: current_max_unique_identifier + 1
1122: WHERE CURRENT of C3;
1123: CLOSE C3;