eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BILLING_WORKBENCH_BILL_PKG dependencies on PA_BILL_WRKBENCH_INV_TEMP

Line 873: DELETE pa_bill_wrkbench_inv_temp;

869: BEGIN
870: x_return_status := FND_API.G_RET_STS_SUCCESS;
871:
872:
873: DELETE pa_bill_wrkbench_inv_temp;
874:
875:
876: /* Added search flag filter if for search region */
877:

Line 881: INTO pa_bill_wrkbench_inv_temp(

877:
878: IF (NVL(UPPER(p_search_flag),'N') = 'N') THEN
879:
880: INSERT
881: INTO pa_bill_wrkbench_inv_temp(
882: PROJECT_ID
883: ,AGREEMENT_ID
884: ,CUSTOMER_ID
885: ,CUSTOMER_NAME

Line 940: UPDATE pa_bill_wrkbench_inv_temp pbw

936: /**
937: * Updating Project invoiced amount and project functional invoice amount
938: **/
939:
940: UPDATE pa_bill_wrkbench_inv_temp pbw
941: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
942: (SELECT
943: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
944: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt

Line 978: UPDATE pa_bill_wrkbench_inv_temp pbw

974: * Updating Project due amount (accepted) and project functional due amount (accepted)
975: * Project tax amount, tax due amount and project functional tax amount tax due amount
976: **/
977: /* Modified the below query completely for the Bug 8249757 includes the fix of bug 7394622 - Start */
978: UPDATE pa_bill_wrkbench_inv_temp pbw
979: /* added group function SUM to Ar amounts,modifed query to calculate billing amounts for bug 7628408 */
980: SET (pbw.pc_due_accepted,pbw.pfc_due_accepted, pbw.pc_tax, pbw.pfc_tax, pbw.pc_tax_due, pbw.pfc_tax_due ) =
981: ( SELECT
982: SUM(( pa_inv.pc_inv_amt /Nvl(pa_ar.line_amt_orig,1)) * Nvl(pa_ar.line_amt_remn,1)) due_accepted_pc,

Line 1010: PA_BILL_WRKBENCH_INV_TEMP pbwi

1006: SUM(dii.project_bill_amount) pc_inv_amt,
1007: SUM(dii.projfunc_bill_amount) pfc_inv_amt
1008: FROM pa_draft_invoices_all di,
1009: pa_draft_invoice_items dii,
1010: PA_BILL_WRKBENCH_INV_TEMP pbwi
1011: WHERE di.project_id = dii.project_id
1012: AND di.draft_invoice_num = dii.draft_invoice_num
1013: AND di.transfer_status_code = 'A'
1014: AND di.customer_id = pbwi.customer_id

Line 1053: UPDATE pa_bill_wrkbench_inv_temp pbw

1049: AND pa_ar.line_amt_orig(+) <> 0 /* Condition added for bug 5230465 */
1050: GROUP BY pa_inv.project_id, pa_inv.customer_id,pa_inv.agreement_id);
1051: /* Modified the query completely for the Bug 8249757 includes the fix of bug 7394622 - End */
1052:
1053: UPDATE pa_bill_wrkbench_inv_temp pbw
1054: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
1055: ( SELECT
1056: SUM(dii.project_bill_amount) ,
1057: SUM(dii.projfunc_bill_amount)

Line 1096: INTO pa_bill_wrkbench_inv_temp(

1092:
1093: ELSIF (NVL(UPPER(p_search_flag),'N') = 'Y') THEN
1094:
1095: INSERT
1096: INTO pa_bill_wrkbench_inv_temp(
1097: PROJECT_ID
1098: ,AGREEMENT_ID
1099: ,CUSTOMER_ID
1100: ,CUSTOMER_NAME

Line 1169: UPDATE pa_bill_wrkbench_inv_temp pbw

1165: /**
1166: * Updating Project invoiced amount and project functional invoice amount
1167: **/
1168:
1169: UPDATE pa_bill_wrkbench_inv_temp pbw
1170: SET (pbw.pc_invoiced,pbw.pfc_invoiced ) =
1171: (SELECT
1172: SUM(NVL(dii.project_bill_amount,0)) projinv_amt
1173: ,SUM(NVL(dii.projfunc_bill_amount,0)) projfuncinv_amt

Line 1218: UPDATE pa_bill_wrkbench_inv_temp pbw

1214: * Updating Project due amount (accepted) and project functional due amount (accepted)
1215: * Project tax amount, tax due amount and project functional tax amount tax due amount
1216: **/
1217: /* Modified the below query completely for the Bug 8249757 includes the fix of bug 7394622 - Start */
1218: UPDATE pa_bill_wrkbench_inv_temp pbw
1219: /* added group function SUM to Ar amounts,modifed query to calculate billing amounts for bug 7628408 */
1220: SET (pbw.pc_due_accepted,pbw.pfc_due_accepted, pbw.pc_tax, pbw.pfc_tax, pbw.pc_tax_due, pbw.pfc_tax_due ) =
1221: ( SELECT
1222: SUM(( pa_inv.pc_inv_amt /Nvl(pa_ar.line_amt_orig,1)) * Nvl(pa_ar.line_amt_remn,1)) due_accepted_pc,

Line 1246: PA_BILL_WRKBENCH_INV_TEMP pbwi

1242: SUM(dii.project_bill_amount) pc_inv_amt,
1243: SUM(dii.projfunc_bill_amount) pfc_inv_amt
1244: FROM pa_draft_invoices_all di,
1245: pa_draft_invoice_items dii,
1246: PA_BILL_WRKBENCH_INV_TEMP pbwi
1247: WHERE di.project_id = dii.project_id
1248: AND di.draft_invoice_num = dii.draft_invoice_num
1249: AND di.agreement_id = NVL(p_agreement_id,di.agreement_id)
1250: AND di.draft_invoice_num = NVL(p_draft_num,di.draft_invoice_num)

Line 1301: UPDATE pa_bill_wrkbench_inv_temp pbw

1297: AND pa_ar.line_amt_orig(+) <> 0 /* Condition added for bug 5230465 */
1298: GROUP BY pa_inv.project_id, pa_inv.customer_id,pa_inv.agreement_id);
1299: /* Modified the query completely for the Bug 8249757 includes the fix of bug 7394622 - End */
1300:
1301: UPDATE pa_bill_wrkbench_inv_temp pbw
1302: SET (pbw.pc_due_pending,pbw.pfc_due_pending ) =
1303: ( SELECT
1304: SUM(dii.project_bill_amount) ,
1305: SUM(dii.projfunc_bill_amount)

Line 1361: INTO pa_bill_wrkbench_inv_temp(

1357: * temp table should not return null pointer exception
1358: **/
1359:
1360: INSERT
1361: INTO pa_bill_wrkbench_inv_temp(
1362: PROJECT_ID
1363: ,AGREEMENT_ID
1364: ,CUSTOMER_ID
1365: ,CUSTOMER_NAME

Line 1398: FROM pa_bill_wrkbench_inv_temp a

1394: ,NULL
1395: FROM
1396: dual
1397: WHERE NOT EXISTS( SELECT 'x'
1398: FROM pa_bill_wrkbench_inv_temp a
1399: WHERE a.project_id = p_project_id);
1400:
1401:
1402: