APPS.PA_CLIENT_EXTN_PWP dependencies on PA_PWP_RELEASE_REPORT

Line 26: PA_PWP_RELEASE_REPORT_ALL WHERE REQUEST_ID = P_REQUEST_ID ;

22: /*Cursor to select the records inserted by Oracle seeded code during concurrent program processing for a run i.e request_id*/
23:
24: CURSOR C_REPORTED_REC IS
25: SELECT REQUEST_ID,PROJECT_ID,DRAFT_INVOICE_NUM,RA_INVOICE_NUM,AP_INVOICE_ID,LINK_TYPE FROM
26: PA_PWP_RELEASE_REPORT_ALL WHERE REQUEST_ID = P_REQUEST_ID ;
27:
28:
29:
30: /*Sample cursor :As an example :To pick up all invoices rejected by Oracle code where invoice amount < 5000*/

Line 35: PA_PWP_RELEASE_REPORT PWP

31:
32: CURSOR C_OVERRIDE IS
33: SELECT AP_INVOICE_ID
34: FROM
35: PA_PWP_RELEASE_REPORT PWP
36: ,AP_INVOICES APINV
37: WHERE
38: PWP.AP_INVOICE_ID = APINV.INVOICE_ID
39: AND PWP.REQUEST_ID = P_REQUEST_ID

Line 48: PA_PWP_RELEASE_REPORT_ALL

44: /* To pick up all unlinked draft invoices */
45:
46: CURSOR C_UNLINKED IS
47: SELECT REQUEST_ID,PROJECT_ID,DRAFT_INVOICE_NUM FROM
48: PA_PWP_RELEASE_REPORT_ALL
49: WHERE REQUEST_ID = P_REQUEST_ID
50: AND link_type = 'UNLINKED'
51: AND release_flag = 'X';
52:

Line 64: Update PA_PWP_RELEASE_REPORT_ALL

60: This will override the RELEASE_FLAG set by Oracle code.
61:
62: FOR rec IN c_reported_rec LOOP
63:
64: Update PA_PWP_RELEASE_REPORT_ALL
65: set CUSTOM_RELEASE_FLAG = 'Y'
66: where request_id = p_request_id
67: AND ........
68:

Line 82: Update PA_PWP_RELEASE_REPORT_ALL

78: The CUSTOM_RELEASE_FLAG column value updated by this package will always take precedence over the RELEASE_FLAG value updated by the standard Oracle code.
79:
80: FOR rec IN C_OVERRIDE LOOP
81:
82: Update PA_PWP_RELEASE_REPORT_ALL
83: set CUSTOM_RELEASE_FLAG = 'Y'
84: where request_id = p_request_id
85: AND AP_INVOICE_ID = rec.AP_INVOICE_ID
86: AND ....

Line 96: as COST, there will be a template record in PA_PWP_RELEASE_REPORT with

92:
93:
94: /*
95: For draft invoices that are created based on an invoice distribution rule
96: as COST, there will be a template record in PA_PWP_RELEASE_REPORT with
97: LINK_TYPE as UNLINKED and RELEASE_FLAG as 'X'.
98: This record can be used as a reference to view all unlinked invoices
99: that got picked up by the concurrent request.
100: The PAID_STATUS column indicates wehther the invoice is paid or not.

Line 102: the PA_PWP_RELEASE_REPORT_ALL table with CUSTOM_RELEASE_FLAG set to 'Y'.

98: This record can be used as a reference to view all unlinked invoices
99: that got picked up by the concurrent request.
100: The PAID_STATUS column indicates wehther the invoice is paid or not.
101: If a user wants to associate a supplier invoice with any of these draft invoices and release the supplier invoice, they can do so by inserting a record in
102: the PA_PWP_RELEASE_REPORT_ALL table with CUSTOM_RELEASE_FLAG set to 'Y'.
103: Users should not modify the package to update the template record that has
104: RELEASE_FLAG value as 'X'.
105:
106:

Line 120: INSERT INTO PA_PWP_RELEASE_REPORT

116:
117:
118: FOR rec IN c_reported_rec LOOP
119:
120: INSERT INTO PA_PWP_RELEASE_REPORT
121: (
122: ORG_ID,
123: REQUEST_ID,
124: PROJECT_ID,