[Home] [Help]
5: Return VARCHAR2 is
6:
7: cursor ISInterPrjRPrvdrPrj is
8: select 'This is an Inter-Project Provider Project'
9: from dual
10: where exists ( select NULL
11: from pa_project_customers ppc
12: where ppc.project_id = p_project_id
13: and ppc.bill_another_project_flag = 'Y'
42: Return VARCHAR2 is
43:
44: cursor ISInterPrjRecvPrj IS
45: select 'This is an Inter-Project Receiver Project'
46: from dual
47: where exists ( select NULL
48: from pa_tasks pt
49: where pt.project_id = p_project_id
50: and pt.receive_project_invoice_flag = 'Y'
116: draft invoices are not yet generated. ***/
117:
118: cursor IsIntercompany_InvGen is
119: select 'INTERCOMPANY INV NOT GENERATED'
120: from dual
121: where exists (
122: select ei.expenditure_item_id
123: from pa_expenditure_items_all ei,
124: pa_tasks t
158: These change is done in the cursors IsIcInv_Transferred_to_AR and IsIcInv_Accepted_in_AP */
159:
160: cursor IsIcInv_Transferred_to_AR is
161: select 'IC INV NOT TIEDBACK SUCCESSFULLY'
162: from dual
163: where exists (
164: select null
165: from pa_expenditure_items_all ei,
166: pa_tasks t
183: );
184:
185: cursor IsIcInv_Accepted_in_AP is
186: select 'IC INV NOT ACCEPTED IN AP'
187: from dual
188: where exists (
189: select null
190: from pa_expenditure_items_all ei,
191: pa_tasks t
363: */
364:
365: cursor IsIpInv_Transferred_to_AR is
366: select 'IP INV NOT TIEDBACK SUCCESSFULLY'
367: from dual
368: where exists (
369: select null
370: from pa_draft_invoices_all di,
371: pa_project_customers ppc,
380: );
381:
382: cursor IsIpInv_Accepted_in_AP is
383: select 'IP INV NOT ACCEPTED IN AP'
384: from dual
385: where exists (
386: select null
387: from pa_draft_invoices_all di,
388: pa_project_customers ppc,
708: remove receiver project from the batch to make the batch valid for purge.
709: To implement the above logic with the receiver project and provider projects are in the same
710: purge batch, the Interproject receiver project validation is called after all the regular
711: checks are completed in pa_purge_validate.BatchVal.
712: Individually receiver and provider projects can be valid for regular checks but after the
713: receiver project validation, the receiver project can be invalid incase,
714: 1. if any of its provider projects which is not in purge status and is not included in the
715: purge batch or
716: 2. included in the purge batch but is invalid for regular checks