APPS.CSP_PARTS_ORDER dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 1178: FROM po_unique_identifier_control

1174:
1175: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1176: CURSOR req_number_cur IS
1177: SELECT to_char(current_max_unique_identifier + 1)
1178: FROM po_unique_identifier_control
1179: WHERE table_name = 'PO_REQUISITION_HEADERS'
1180: FOR UPDATE OF current_max_unique_identifier;
1181:
1182: -- Get unique requisition_header_id

Line 1919: UPDATE po_unique_identifier_control

1915: -- Requisition_number
1916: IF l_header_rec.requisition_number IS NULL THEN
1917: OPEN req_number_cur;
1918: FETCH req_number_cur INTO l_header_rec.requisition_number;
1919: UPDATE po_unique_identifier_control
1920: SET current_max_unique_identifier
1921: = current_max_unique_identifier + 1
1922: WHERE CURRENT of req_number_cur;
1923: CLOSE req_number_cur;

Line 4375: FROM po_unique_identifier_control

4371:
4372: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
4373: CURSOR req_number_cur IS
4374: SELECT to_char(current_max_unique_identifier + 1)
4375: FROM po_unique_identifier_control
4376: WHERE table_name = 'PO_REQUISITION_HEADERS'
4377: FOR UPDATE OF current_max_unique_identifier;
4378:
4379: -- Get unique requisition_header_id

Line 4477: UPDATE po_unique_identifier_control

4473: -- Requisition_number
4474: -- IF l_header_rec.requisition_number IS NULL THEN
4475: OPEN req_number_cur;
4476: FETCH req_number_cur INTO l_header_rec.requisition_number;
4477: UPDATE po_unique_identifier_control
4478: SET current_max_unique_identifier
4479: = current_max_unique_identifier + 1
4480: WHERE CURRENT of req_number_cur;
4481: CLOSE req_number_cur;