APPS.CSP_REPAIR_PO_PVT dependencies on PO_REQUISITIONS_INTERFACE_ALL

Line 58: FROM PO_REQUISITIONS_INTERFACE_ALL PRIL

54: ORDER BY REPAIR_PO_HEADER_ID;
55:
56: CURSOR PO_REQ_INTERFACE_ALL(l_requisition_number NUMBER,l_requisition_line_id NUMBER) IS
57: SELECT PRIL.authorization_status, PRIL.req_number_segment1
58: FROM PO_REQUISITIONS_INTERFACE_ALL PRIL
59: WHERE PRIL.req_number_segment1 = l_requisition_number
60: AND PRIL.requisition_line_id = l_requisition_line_id;
61:
62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/

Line 277: i.e In PO_REQUISITIONS_INTERFACE_ALL table AUTHORIZATION_STATUS = 'INCOMPLETE' (or) 'IN PROCESS' (or) 'REJECTED' (or) other.

273: ---- Start Step:1 ----
274:
275: /**
276: For all the Repair_po's with status '1'
277: i.e In PO_REQUISITIONS_INTERFACE_ALL table AUTHORIZATION_STATUS = 'INCOMPLETE' (or) 'IN PROCESS' (or) 'REJECTED' (or) other.
278: Check AUTHORIZATION_STATUS in PO_REQUISITIONS_INTERFACE_ALL is moved to 'APPROVED'
279: If that is true or record is moved to PO_REQUISITION_HEADERS_ALL then update the status = 2
280: else keep status = 1 as it may be still 'IN PROCESS' (or) 'REJECTED' (or) other status
281: **/

Line 278: Check AUTHORIZATION_STATUS in PO_REQUISITIONS_INTERFACE_ALL is moved to 'APPROVED'

274:
275: /**
276: For all the Repair_po's with status '1'
277: i.e In PO_REQUISITIONS_INTERFACE_ALL table AUTHORIZATION_STATUS = 'INCOMPLETE' (or) 'IN PROCESS' (or) 'REJECTED' (or) other.
278: Check AUTHORIZATION_STATUS in PO_REQUISITIONS_INTERFACE_ALL is moved to 'APPROVED'
279: If that is true or record is moved to PO_REQUISITION_HEADERS_ALL then update the status = 2
280: else keep status = 1 as it may be still 'IN PROCESS' (or) 'REJECTED' (or) other status
281: **/
282: