APPS.PA_PWP_SUMM_PKG dependencies on PA_PWP_CUSTOMER_SUMM

Line 4: -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.

1: PACKAGE BODY PA_PWP_SUMM_PKG AS
2: -- $Header: PAPWPSMB.pls 120.0.12010000.16 2009/02/05 06:01:26 jjgeorge noship $
3:
4: -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.
5: -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor
6: --(supplier) workbench.
7: PROCEDURE Populate_summary
8: (P_Project_Id IN NUMBER)

Line 5: -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor

1: PACKAGE BODY PA_PWP_SUMM_PKG AS
2: -- $Header: PAPWPSMB.pls 120.0.12010000.16 2009/02/05 06:01:26 jjgeorge noship $
3:
4: -- This procedure populates data in PA_PWP_CUSTOMER_SUMM_ALL table.
5: -- The data populated in PA_PWP_CUSTOMER_SUMM_ALL table is used in subcontractor
6: --(supplier) workbench.
7: PROCEDURE Populate_summary
8: (P_Project_Id IN NUMBER)
9: IS

Line 18: FROM PA_PWP_CUSTOMER_SUMM WHERE project_id = P_Project_Id ;

14: l_org_id number(15);
15: BEGIN
16:
17: DELETE
18: FROM PA_PWP_CUSTOMER_SUMM WHERE project_id = P_Project_Id ;
19:
20: SELECT org_id
21: INTO l_org_id
22: FROM pa_implementations;

Line 27: INTO PA_PWP_CUSTOMER_SUMM

23:
24:
25: --Insert the Invoice level attributes to the temp Table
26: INSERT
27: INTO PA_PWP_CUSTOMER_SUMM
28: ( ORG_ID
29: , PROJECT_ID
30: , draft_invoice_num
31: , RA_INVOICE_NUMBER

Line 105: UPDATE PA_PWP_CUSTOMER_SUMM pwp

101: 'R', 'REJECTED' ) ) ) ) ;
102:
103: --Update the Bill Amount /Line Amounts for PFC,PC,INV
104:
105: UPDATE PA_PWP_CUSTOMER_SUMM pwp
106: SET
107: ( PFC_BILL_AMOUNT -- Bug 7707807 re-ordered the columns
108: ,PFC_LINE_AMOUNT
109: ,PFC_OUTSTANDING_AMOUNT --Bug 8200941 Outstanding amount columns added in the query

Line 139: UPDATE PA_PWP_CUSTOMER_SUMM pwp

135:
136: --Update columns with AR amounts .
137: --Only records of interfaced invoices will get updated
138:
139: UPDATE PA_PWP_CUSTOMER_SUMM pwp
140: SET
141: (
142: INV_BILL_AMOUNT
143: , INV_OUTSTANDING_AMOUNT

Line 183: UPDATE PA_PWP_CUSTOMER_SUMM pwp

179: );
180:
181: --Update current period Amounts
182: /*
183: UPDATE PA_PWP_CUSTOMER_SUMM pwp
184: SET
185: (
186: INV_CP_BILL_AMOUNT
187: ,INV_CP_RECIEPT_AMOUNT

Line 200: UPDATE PA_PWP_CUSTOMER_SUMM pwp

196: WHERE project_id = P_Project_Id; */ -- bug 8208525 commented the code .
197:
198: -- FOR UNINTERFACED INVOCIES...
199:
200: UPDATE PA_PWP_CUSTOMER_SUMM pwp
201: SET ( INV_CP_BILL_AMOUNT
202: ,PFC_CP_BILL_AMOUNT
203: ,PC_CP_BILL_AMOUNT)
204: =

Line 222: UPDATE PA_PWP_CUSTOMER_SUMM pwp

218:
219: -- FOR INTERFACED INVOICES...
220:
221:
222: UPDATE PA_PWP_CUSTOMER_SUMM pwp
223: SET INV_CP_BILL_AMOUNT = (SELECT SUM(ARP.amount_due_original )
224:
225: FROM AR_PAYMENT_SCHEDULES ARP,
226: PA_DRAFT_INVOICES PDA

Line 235: UPDATE PA_PWP_CUSTOMER_SUMM PWP

231: WHERE PWP.project_id = P_Project_Id AND PWP.TRANSFER_STATUS_CODE = 'A';
232:
233: --FOR RECEIPT AMOUNTS
234:
235: UPDATE PA_PWP_CUSTOMER_SUMM PWP
236: SET INV_CP_RECIEPT_AMOUNT =
237: (SELECT SUM(AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
238: WHERE
239: PWP.SYSTEM_REFERENCE = ARA.APPLIED_CUSTOMER_TRX_ID

Line 247: UPDATE PA_PWP_CUSTOMER_SUMM pwp

243:
244:
245:
246:
247: UPDATE PA_PWP_CUSTOMER_SUMM pwp
248: SET (PROJFUNC_CURRENCY_CODE ,PROJECT_CURRENCY_CODE)
249: = (select PROJFUNC_CURRENCY_CODE, PROJECT_CURRENCY_CODE
250: from pa_projects_all pa where pwp.project_id = pa.project_id )
251: Where project_id = P_Project_Id;

Line 257: UPDATE PA_PWP_CUSTOMER_SUMM

253:
254: -- Updating the PC/PFC amounts by convertig the INV amount fetched from AR
255:
256:
257: UPDATE PA_PWP_CUSTOMER_SUMM
258: SET PFC_BILL_AMOUNT = INV_BILL_AMOUNT * (PFC_LINE_AMOUNT/ INV_LINE_AMOUNT)
259: , PFC_CP_BILL_AMOUNT = INV_CP_BILL_AMOUNT * (PFC_LINE_AMOUNT/ INV_LINE_AMOUNT)
260: , PFC_RECIEPT_AMOUNT = INV_RECIEPT_AMOUNT * (PFC_LINE_AMOUNT/ INV_LINE_AMOUNT)
261: , PFC_CP_RECIEPT_AMOUNT = INV_CP_RECIEPT_AMOUNT * (PFC_LINE_AMOUNT/ INV_LINE_AMOUNT)

Line 278: UPDATE PA_PWP_CUSTOMER_SUMM

274: WHERE project_id = P_project_id
275: AND TRANSFER_STATUS_CODE = 'A';
276:
277: /* --Bug 8200941 commented
278: UPDATE PA_PWP_CUSTOMER_SUMM
279: SET PFC_OUTSTANDING_AMOUNT = (INV_BILL_AMOUNT - nvl(INV_RECIEPT_AMOUNT,0)) * (PFC_LINE_AMOUNT/ INV_LINE_AMOUNT)
280: ,PC_OUTSTANDING_AMOUNT = (INV_BILL_AMOUNT - nvl(INV_RECIEPT_AMOUNT,0)) * (PC_LINE_AMOUNT/ INV_LINE_AMOUNT)
281: ,INV_OUTSTANDING_AMOUNT = (INV_BILL_AMOUNT - nvl(INV_RECIEPT_AMOUNT,0))
282: WHERE project_id = P_project_id ;

Line 287: UPDATE PA_PWP_CUSTOMER_SUMM

283:
284: */
285: /* bug 8200961 updating receipt amounts to 0 for credit memos. */
286:
287: UPDATE PA_PWP_CUSTOMER_SUMM
288: SET PFC_RECIEPT_AMOUNT = 0
289: ,PFC_CP_RECIEPT_AMOUNT = 0
290: ,PC_RECIEPT_AMOUNT = 0
291: ,PC_CP_RECIEPT_AMOUNT = 0