APPS.CSP_PARTS_ORDER dependencies on PO_UNIQUE_IDENTIFIER_CONTROL

Line 1056: FROM po_unique_identifier_control

1052:
1053: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
1054: CURSOR req_number_cur IS
1055: SELECT to_char(current_max_unique_identifier + 1)
1056: FROM po_unique_identifier_control
1057: WHERE table_name = 'PO_REQUISITION_HEADERS'
1058: FOR UPDATE OF current_max_unique_identifier;
1059:
1060: -- Get unique requisition_header_id

Line 1457: UPDATE po_unique_identifier_control

1453: -- Requisition_number
1454: IF l_header_rec.requisition_number IS NULL THEN
1455: OPEN req_number_cur;
1456: FETCH req_number_cur INTO l_header_rec.requisition_number;
1457: UPDATE po_unique_identifier_control
1458: SET current_max_unique_identifier
1459: = current_max_unique_identifier + 1
1460: WHERE CURRENT of req_number_cur;
1461: CLOSE req_number_cur;

Line 2883: FROM po_unique_identifier_control

2879:
2880: -- Get requisition_number (PO_REQUSITION_HEADERS.segment1)
2881: CURSOR req_number_cur IS
2882: SELECT to_char(current_max_unique_identifier + 1)
2883: FROM po_unique_identifier_control
2884: WHERE table_name = 'PO_REQUISITION_HEADERS'
2885: FOR UPDATE OF current_max_unique_identifier;
2886:
2887: -- Get unique requisition_header_id

Line 2954: UPDATE po_unique_identifier_control

2950: -- Requisition_number
2951: -- IF l_header_rec.requisition_number IS NULL THEN
2952: OPEN req_number_cur;
2953: FETCH req_number_cur INTO l_header_rec.requisition_number;
2954: UPDATE po_unique_identifier_control
2955: SET current_max_unique_identifier
2956: = current_max_unique_identifier + 1
2957: WHERE CURRENT of req_number_cur;
2958: CLOSE req_number_cur;