APPS.CSP_REPAIR_PO_PVT dependencies on PO_REQUISITION_HEADERS_ALL

Line 62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/

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 **/
63: CURSOR PO_REQ_HEADERS_ALL(l_requisition_number NUMBER, l_requisition_line_id NUMBER) IS
64: SELECT PRH.REQUISITION_HEADER_ID,PRH.AUTHORIZATION_STATUS,PRH.segment1
65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
66: WHERE PRH.SEGMENT1 = l_requisition_number AND

Line 65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL

61:
62: /** Possible to check only in the PO_REQUISITION_HEADERS_ALL table and no need to join with PO_REQUISITION_LINES_ALL table **/
63: CURSOR PO_REQ_HEADERS_ALL(l_requisition_number NUMBER, l_requisition_line_id NUMBER) IS
64: SELECT PRH.REQUISITION_HEADER_ID,PRH.AUTHORIZATION_STATUS,PRH.segment1
65: FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL
66: WHERE PRH.SEGMENT1 = l_requisition_number AND
67: PRL.REQUISITION_LINE_ID = l_requisition_line_id AND
68: PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID;
69:

Line 240: If that is true or record is moved to PO_REQUISITION_HEADERS_ALL then update the status = 2

236: /**
237: For all the Repair_po's with status '1'
238: i.e In PO_REQUISITIONS_INTERFACE_ALL table AUTHORIZATION_STATUS = 'INCOMPLETE' (or) 'IN PROCESS' (or) 'REJECTED' (or) other.
239: Check AUTHORIZATION_STATUS in PO_REQUISITIONS_INTERFACE_ALL is moved to 'APPROVED'
240: If that is true or record is moved to PO_REQUISITION_HEADERS_ALL then update the status = 2
241: else keep status = 1 as it may be still 'IN PROCESS' (or) 'REJECTED' (or) other status
242: **/
243:
244: FOR CSP_REPAIR_PO_HEADERS_rec IN C_CSP_REPAIR_PO_HEADERS(1)

Line 277: i.e In PO_REQUISITION_HEADERS_ALL table AUTHORIZATION_STATUS = 'CREATED' or 'IN PROCESS' or other

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

Line 278: check AUTHORIZATION_STATUS in PO_REQUISITION_HEADERS_ALL is moved to 'APPROVED'

274:
275: /**
276: For all the Repair_po whose status is '2'
277: i.e In PO_REQUISITION_HEADERS_ALL table AUTHORIZATION_STATUS = 'CREATED' or 'IN PROCESS' or other
278: check AUTHORIZATION_STATUS in PO_REQUISITION_HEADERS_ALL is moved to 'APPROVED'
279: If that is true update the status = 3
280: else keep status = 2 as it may be still in 'IN PROCESS' (or) 'REJECTED' (or) other status
281: **/
282: SAVEPOINT RUN_REPAIR_EXECUTION_PVT;