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_RETENTION_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 21: FROM pa_draft_invoice_items

17: END IF;
18:
19: SELECT NVL(MAX(line_num),0) +1
20: INTO last_line_num
21: FROM pa_draft_invoice_items
22: WHERE project_id = p_project_id
23: AND draft_invoice_num = p_draft_invoice_num;
24:
25: IF g1_debug_mode = 'Y' THEN

Line 40: FROM pa_draft_invoice_items

36: p_draft_invoice_num IN NUMBER) RETURN NUMBER IS
37: NetZero_line_num NUMBER;
38: /* Added for Bug 9690548 Start */
39: CURSOR NZ_Line_Num is SELECT line_num
40: FROM pa_draft_invoice_items
41: WHERE project_id = p_project_id
42: AND draft_invoice_num = p_draft_invoice_num
43: AND invoice_line_type = 'NET ZERO ADJUSTMENT' ORDER BY 1;
44:

Line 57: FROM pa_draft_invoice_items

53:
54: /* Commented the code for Bug 9690548 Start
55: SELECT line_num
56: INTO NetZero_line_num
57: FROM pa_draft_invoice_items
58: WHERE project_id = p_project_id
59: AND draft_invoice_num = p_draft_invoice_num
60: AND invoice_line_type = 'NET ZERO ADJUSTMENT';
61: Commented the code for Bug 9690548 End */

Line 69: Update pa_draft_invoice_items

65: IF g1_debug_mode = 'Y' THEN
66: pa_retention_util.write_log('Get_NetZero_Line : ' || NZ_Line_Rec.line_num);
67: END IF;
68:
69: Update pa_draft_invoice_items
70: set line_num = NZ_Line_Rec.line_num * (-1) /* Modified for Bug 9690548 */
71: WHERE project_id = p_project_id
72: AND draft_invoice_num = p_draft_invoice_num
73: AND invoice_line_type = 'NET ZERO ADJUSTMENT'

Line 517: UPDATE pa_draft_invoice_items

513: p_bill_trans_currency IN VARCHAR2,
514: p_request_id IN NUMBER) IS
515:
516: BEGIN
517: UPDATE pa_draft_invoice_items
518: SET bill_trans_currency_code = p_bill_trans_currency,
519: inv_amount =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(bill_trans_bill_amount, trim(p_bill_trans_currency)),
520: request_id = p_request_id
521: WHERE DRAFT_invoice_num = p_draft_invoice_num

Line 652: FROM pa_draft_invoice_items dii

648: SUM(dii.projfunc_bill_amount) pfc_invoice_amount,
649: SUM(dii.project_bill_amount) pc_invoice_amount,
650: SUM(dii.funding_bill_amount) fc_invoice_amount,
651: SUM(dii.bill_trans_bill_amount) btc_invoice_amount
652: FROM pa_draft_invoice_items dii
653: WHERE dii.project_id = p_project_id
654: AND dii.request_id = p_request_id
655: AND dii.draft_invoice_num = p_draft_invoice_num
656: AND dii.event_num IS NOT NULL

Line 1354: INSERT INTO pa_draft_invoice_items

1350: END IF;
1351:
1352: -- Insert a Retention Line
1353:
1354: INSERT INTO pa_draft_invoice_items
1355: ( PROJECT_ID,
1356: DRAFT_INVOICE_NUM,
1357: LINE_NUM,
1358: AMOUNT,

Line 1495: UPDATE pa_draft_invoice_items

1491: IF g1_debug_mode = 'Y' THEN
1492: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update DII ');
1493: END IF;
1494:
1495: UPDATE pa_draft_invoice_items
1496: SET retn_draft_invoice_num = p_draft_invoice_num,
1497: retn_draft_invoice_line_num = LastLineNum,
1498: retained_amount =
1499: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 2027: UPDATE pa_draft_invoice_items dii

2023: -- 1. Update the Event Type Level Retention Setup in DII only for EVENTS
2024: /* Bug 3258414: The update statements below are done only for Events of type MANUAL or AUTOMATIC.
2025: The WRITE ON events are already updated using the ERDL table above. */
2026:
2027: UPDATE pa_draft_invoice_items dii
2028: SET dii.retention_rule_id=
2029: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2030: rt.retention_rule_id,
2031: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2082: UPDATE pa_draft_invoice_items dii

2078: END IF;
2079:
2080: -- 2. Update the Revenue Category Level Retention Setup in DII for events
2081:
2082: UPDATE pa_draft_invoice_items dii
2083: SET dii.retention_rule_id=
2084: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2085: rt.retention_rule_id,
2086: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2138: UPDATE pa_draft_invoice_items dii

2134: IF g1_debug_mode = 'Y' THEN
2135: pa_retention_util.write_log('Proj_Invoice_Retn_Processing: ' || 'PROJECT Defaults Level ');
2136: END IF;
2137:
2138: UPDATE pa_draft_invoice_items dii
2139: SET dii.retention_rule_id=
2140: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2141: rt.retention_rule_id,
2142: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2527: UPDATE pa_draft_invoice_items dii

2523:
2524:
2525: -- 1. Update the Event Type Level Retention Setup in DII only for EVENTS
2526:
2527: UPDATE pa_draft_invoice_items dii
2528: SET dii.retention_rule_id=
2529: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2530: rt.retention_rule_id,
2531: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2588: UPDATE pa_draft_invoice_items dii

2584: END IF;
2585:
2586: -- 2. Update the Revenue Category Level Retention Setup in DII for events
2587:
2588: UPDATE pa_draft_invoice_items dii
2589: SET dii.retention_rule_id=
2590: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2591: rt.retention_rule_id,
2592: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2648: UPDATE pa_draft_invoice_items dii

2644:
2645:
2646: -- 3. Update the Top Task Level Retention Setup in DIIs for Events
2647:
2648: UPDATE pa_draft_invoice_items dii
2649: SET dii.retention_rule_id=
2650: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2651: rt.retention_rule_id,
2652: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2734: FROM pa_draft_invoice_items

2730:
2731: /* Added for Bug 9690548 */
2732: SELECT count(*)
2733: INTO NZCount
2734: FROM pa_draft_invoice_items
2735: WHERE project_id = p_project_id
2736: AND draft_invoice_num = DraftInvoiceNum
2737: AND invoice_line_type = 'NET ZERO ADJUSTMENT';
2738:

Line 2753: UPDATE PA_DRAFT_INVOICE_ITEMS

2749: END IF;
2750:
2751: /* Update net zero line to the last line after retention lines */
2752:
2753: UPDATE PA_DRAFT_INVOICE_ITEMS
2754: SET LINE_NUM = LastLineNum
2755: WHERE PROJECT_ID = p_project_id
2756: AND DRAFT_INVOICE_NUM = draftinvoicenum
2757: AND LINE_NUM = (NetZeroLineNum-NZCount+j) * (-1); /* Modified for Bug 9690548 */

Line 2871: FROM pa_draft_invoice_items di

2867: UNION
2868: SELECT NVL(di.retention_rule_id,-1) retention_rule_id,
2869: SUM(DECODE(NVL(di.retention_rule_id,-1) ,-1,
2870: NVL(di.amount,0) ,NVL(di.retained_amount,0) ) ) invoice_amount
2871: FROM pa_draft_invoice_items di
2872: WHERE di.project_id = p_project_id
2873: AND di.draft_invoice_num = l_credit_invoice_num
2874: AND di.event_num is not null
2875: GROUP BY NVL(di.retention_rule_id,-1)) CR_RET

Line 2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2958: di.agreement_id agreement_id,
2959: agr.customer_id customer_id,
2960: rtn.task_id rtn_task_id,
2961: dii.line_num line_num_credited
2962: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2963: pa_agreements_all agr,
2964: pa_proj_retn_rules rtn
2965: WHERE dii.project_id = p_project_id
2966: AND dii.draft_invoice_num = l_org_invoice_num

Line 3005: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3001: di.agreement_id agreement_id,
3002: agr.customer_id customer_id,
3003: dii.retention_rule_id rtn_task_id, -- To get the retention lines
3004: dii.line_num line_num_credited
3005: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3006: pa_agreements_all agr
3007: WHERE dii.project_id = p_project_id
3008: AND dii.draft_invoice_num = l_org_invoice_num
3009: AND dii.project_id = di.project_id

Line 3025: INSERT INTO pa_draft_invoice_items

3021: pa_retention_util.write_log('Proj_Invoice_Credit_Memo: ' || 'New Invoice :' || l_credit_invoice_num);
3022: pa_retention_util.write_log('Proj_Invoice_Credit_Memo: ' || 'Retn Line Credited :' || lastlinenum);
3023: END IF;
3024:
3025: INSERT INTO pa_draft_invoice_items
3026: ( PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM,
3027: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
3028: CREATED_BY, AMOUNT, TEXT,
3029: INVOICE_LINE_TYPE, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 3117: UPDATE pa_draft_invoice_items

3113: END IF;
3114:
3115: -- Update the DII - Added for bug 3958970
3116:
3117: UPDATE pa_draft_invoice_items
3118: SET retn_draft_invoice_num = l_credit_invoice_num,
3119: retn_draft_invoice_line_num = LastLineNum
3120: WHERE retention_rule_id = InvoiceLines.Retention_rule_id
3121: AND draft_invoice_num = l_credit_invoice_num

Line 3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3367: di.agreement_id agreement_id,
3368: agr.customer_id customer_id,
3369: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3370: dii.inv_amount inv_amount
3371: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3372: pa_agreements_all agr,
3373: pa_proj_retn_rules rtn
3374: WHERE di.project_id = p_project_id
3375: AND di.draft_invoice_num = p_draft_invoice_num

Line 3381: INSERT INTO pa_draft_invoice_items

3377: AND di.project_id = dii.project_id
3378: AND di.draft_invoice_num = dii.draft_invoice_num
3379: AND dii.retention_rule_id = rtn.retention_rule_id(+)) LOOP
3380:
3381: INSERT INTO pa_draft_invoice_items
3382: ( PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM,
3383: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
3384: CREATED_BY, AMOUNT, TEXT,
3385: INVOICE_LINE_TYPE, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 3494: FROM pa_draft_invoice_items dii,

3490: dii.retention_rule_id retention_rule_id,
3491: di.agreement_id agreement_id,
3492: agr.customer_id customer_id,
3493: rtn.task_id rtn_task_id
3494: FROM pa_draft_invoice_items dii,
3495: pa_draft_invoices_all di,
3496: pa_agreements_all agr,
3497: pa_proj_retn_rules rtn
3498: WHERE di.project_id = p_project_id

Line 3577: FROM pa_draft_invoice_items dii,

3573: dii.retention_rule_id retention_rule_id,
3574: di.agreement_id agreement_id,
3575: agr.customer_id customer_id,
3576: NVL(rtn.task_id,dii.task_id) rtn_task_id
3577: FROM pa_draft_invoice_items dii,
3578: pa_draft_invoices_all di,
3579: pa_agreements_all agr,
3580: pa_proj_retn_rules rtn
3581: WHERE di.project_id = p_project_id

Line 3684: FROM pa_draft_invoice_items dii,

3680: dii.retention_rule_id retention_rule_id,
3681: di.agreement_id agreement_id,
3682: agr.customer_id customer_id,
3683: rtn.task_id rtn_task_id
3684: FROM pa_draft_invoice_items dii,
3685: pa_draft_invoices_all di,
3686: pa_agreements_all agr,
3687: pa_proj_retn_rules rtn
3688: WHERE di.project_id = p_project_id

Line 3734: FROM pa_draft_invoice_items dii,

3730: dii.retention_rule_id retention_rule_id,
3731: di.agreement_id agreement_id,
3732: agr.customer_id customer_id,
3733: dii.task_id dii_task_id
3734: FROM pa_draft_invoice_items dii,
3735: pa_draft_invoices_all di,
3736: pa_agreements_all agr
3737: WHERE di.project_id = p_project_id
3738: AND di.draft_invoice_num = p_draft_invoice_num