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.

[Home] [Help]

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 46: FROM pa_draft_invoice_items

42: END IF;
43:
44: SELECT line_num
45: INTO NetZero_line_num
46: FROM pa_draft_invoice_items
47: WHERE project_id = p_project_id
48: AND draft_invoice_num = p_draft_invoice_num
49: AND invoice_line_type = 'NET ZERO ADJUSTMENT';
50:

Line 55: Update pa_draft_invoice_items

51: IF g1_debug_mode = 'Y' THEN
52: pa_retention_util.write_log('Get_NetZero_Line : ' || NetZero_line_num);
53: END IF;
54:
55: Update pa_draft_invoice_items
56: set line_num = NetZero_line_num * (-1)
57: WHERE project_id = p_project_id
58: AND draft_invoice_num = p_draft_invoice_num
59: AND invoice_line_type = 'NET ZERO ADJUSTMENT';

Line 499: UPDATE pa_draft_invoice_items

495: p_bill_trans_currency IN VARCHAR2,
496: p_request_id IN NUMBER) IS
497:
498: BEGIN
499: UPDATE pa_draft_invoice_items
500: SET bill_trans_currency_code = p_bill_trans_currency,
501: inv_amount =PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(bill_trans_bill_amount, trim(p_bill_trans_currency)),
502: request_id = p_request_id
503: WHERE DRAFT_invoice_num = p_draft_invoice_num

Line 634: FROM pa_draft_invoice_items dii

630: SUM(dii.projfunc_bill_amount) pfc_invoice_amount,
631: SUM(dii.project_bill_amount) pc_invoice_amount,
632: SUM(dii.funding_bill_amount) fc_invoice_amount,
633: SUM(dii.bill_trans_bill_amount) btc_invoice_amount
634: FROM pa_draft_invoice_items dii
635: WHERE dii.project_id = p_project_id
636: AND dii.request_id = p_request_id
637: AND dii.draft_invoice_num = p_draft_invoice_num
638: AND dii.event_num IS NOT NULL

Line 1336: INSERT INTO pa_draft_invoice_items

1332: END IF;
1333:
1334: -- Insert a Retention Line
1335:
1336: INSERT INTO pa_draft_invoice_items
1337: ( PROJECT_ID,
1338: DRAFT_INVOICE_NUM,
1339: LINE_NUM,
1340: AMOUNT,

Line 1477: UPDATE pa_draft_invoice_items

1473: IF g1_debug_mode = 'Y' THEN
1474: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update DII ');
1475: END IF;
1476:
1477: UPDATE pa_draft_invoice_items
1478: SET retn_draft_invoice_num = p_draft_invoice_num,
1479: retn_draft_invoice_line_num = LastLineNum,
1480: retained_amount =
1481: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 2008: UPDATE pa_draft_invoice_items dii

2004: -- 1. Update the Event Type Level Retention Setup in DII only for EVENTS
2005: /* Bug 3258414: The update statements below are done only for Events of type MANUAL or AUTOMATIC.
2006: The WRITE ON events are already updated using the ERDL table above. */
2007:
2008: UPDATE pa_draft_invoice_items dii
2009: SET dii.retention_rule_id=
2010: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2011: rt.retention_rule_id,
2012: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2063: UPDATE pa_draft_invoice_items dii

2059: END IF;
2060:
2061: -- 2. Update the Revenue Category Level Retention Setup in DII for events
2062:
2063: UPDATE pa_draft_invoice_items dii
2064: SET dii.retention_rule_id=
2065: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2066: rt.retention_rule_id,
2067: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2119: UPDATE pa_draft_invoice_items dii

2115: IF g1_debug_mode = 'Y' THEN
2116: pa_retention_util.write_log('Proj_Invoice_Retn_Processing: ' || 'PROJECT Defaults Level ');
2117: END IF;
2118:
2119: UPDATE pa_draft_invoice_items dii
2120: SET dii.retention_rule_id=
2121: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2122: rt.retention_rule_id,
2123: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2508: UPDATE pa_draft_invoice_items dii

2504:
2505:
2506: -- 1. Update the Event Type Level Retention Setup in DII only for EVENTS
2507:
2508: UPDATE pa_draft_invoice_items dii
2509: SET dii.retention_rule_id=
2510: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2511: rt.retention_rule_id,
2512: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2569: UPDATE pa_draft_invoice_items dii

2565: END IF;
2566:
2567: -- 2. Update the Revenue Category Level Retention Setup in DII for events
2568:
2569: UPDATE pa_draft_invoice_items dii
2570: SET dii.retention_rule_id=
2571: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2572: rt.retention_rule_id,
2573: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2629: UPDATE pa_draft_invoice_items dii

2625:
2626:
2627: -- 3. Update the Top Task Level Retention Setup in DIIs for Events
2628:
2629: UPDATE pa_draft_invoice_items dii
2630: SET dii.retention_rule_id=
2631: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2632: rt.retention_rule_id,
2633: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2719: UPDATE PA_DRAFT_INVOICE_ITEMS

2715: p_draft_invoice_num=>DraftInvoiceNum);
2716:
2717: /* Update net zero line to the last line after retention lines */
2718:
2719: UPDATE PA_DRAFT_INVOICE_ITEMS
2720: SET LINE_NUM = LastLineNum
2721: WHERE PROJECT_ID = p_project_id
2722: AND DRAFT_INVOICE_NUM = draftinvoicenum
2723: AND LINE_NUM = NetZeroLineNum * (-1);

Line 2834: FROM pa_draft_invoice_items di

2830: UNION
2831: SELECT NVL(di.retention_rule_id,-1) retention_rule_id,
2832: SUM(DECODE(NVL(di.retention_rule_id,-1) ,-1,
2833: NVL(di.amount,0) ,NVL(di.retained_amount,0) ) ) invoice_amount
2834: FROM pa_draft_invoice_items di
2835: WHERE di.project_id = p_project_id
2836: AND di.draft_invoice_num = l_credit_invoice_num
2837: AND di.event_num is not null
2838: GROUP BY NVL(di.retention_rule_id,-1)) CR_RET

Line 2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2921: di.agreement_id agreement_id,
2922: agr.customer_id customer_id,
2923: rtn.task_id rtn_task_id,
2924: dii.line_num line_num_credited
2925: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2926: pa_agreements_all agr,
2927: pa_proj_retn_rules rtn
2928: WHERE dii.project_id = p_project_id
2929: AND dii.draft_invoice_num = l_org_invoice_num

Line 2968: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

2964: di.agreement_id agreement_id,
2965: agr.customer_id customer_id,
2966: dii.retention_rule_id rtn_task_id, -- To get the retention lines
2967: dii.line_num line_num_credited
2968: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
2969: pa_agreements_all agr
2970: WHERE dii.project_id = p_project_id
2971: AND dii.draft_invoice_num = l_org_invoice_num
2972: AND dii.project_id = di.project_id

Line 2988: INSERT INTO pa_draft_invoice_items

2984: pa_retention_util.write_log('Proj_Invoice_Credit_Memo: ' || 'New Invoice :' || l_credit_invoice_num);
2985: pa_retention_util.write_log('Proj_Invoice_Credit_Memo: ' || 'Retn Line Credited :' || lastlinenum);
2986: END IF;
2987:
2988: INSERT INTO pa_draft_invoice_items
2989: ( PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM,
2990: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
2991: CREATED_BY, AMOUNT, TEXT,
2992: INVOICE_LINE_TYPE, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 3080: UPDATE pa_draft_invoice_items

3076: END IF;
3077:
3078: -- Update the DII - Added for bug 3958970
3079:
3080: UPDATE pa_draft_invoice_items
3081: SET retn_draft_invoice_num = l_credit_invoice_num,
3082: retn_draft_invoice_line_num = LastLineNum
3083: WHERE retention_rule_id = InvoiceLines.Retention_rule_id
3084: AND draft_invoice_num = l_credit_invoice_num

Line 3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,

3330: di.agreement_id agreement_id,
3331: agr.customer_id customer_id,
3332: nvl(rtn.task_id, dii.task_id) rtn_task_id,
3333: dii.inv_amount inv_amount
3334: FROM pa_draft_invoice_items dii, pa_draft_invoices_all di,
3335: pa_agreements_all agr,
3336: pa_proj_retn_rules rtn
3337: WHERE di.project_id = p_project_id
3338: AND di.draft_invoice_num = p_draft_invoice_num

Line 3344: INSERT INTO pa_draft_invoice_items

3340: AND di.project_id = dii.project_id
3341: AND di.draft_invoice_num = dii.draft_invoice_num
3342: AND dii.retention_rule_id = rtn.retention_rule_id(+)) LOOP
3343:
3344: INSERT INTO pa_draft_invoice_items
3345: ( PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM,
3346: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
3347: CREATED_BY, AMOUNT, TEXT,
3348: INVOICE_LINE_TYPE, REQUEST_ID, PROGRAM_APPLICATION_ID,

Line 3457: FROM pa_draft_invoice_items dii,

3453: dii.retention_rule_id retention_rule_id,
3454: di.agreement_id agreement_id,
3455: agr.customer_id customer_id,
3456: rtn.task_id rtn_task_id
3457: FROM pa_draft_invoice_items dii,
3458: pa_draft_invoices_all di,
3459: pa_agreements_all agr,
3460: pa_proj_retn_rules rtn
3461: WHERE di.project_id = p_project_id

Line 3540: FROM pa_draft_invoice_items dii,

3536: dii.retention_rule_id retention_rule_id,
3537: di.agreement_id agreement_id,
3538: agr.customer_id customer_id,
3539: NVL(rtn.task_id,dii.task_id) rtn_task_id
3540: FROM pa_draft_invoice_items dii,
3541: pa_draft_invoices_all di,
3542: pa_agreements_all agr,
3543: pa_proj_retn_rules rtn
3544: WHERE di.project_id = p_project_id

Line 3647: FROM pa_draft_invoice_items dii,

3643: dii.retention_rule_id retention_rule_id,
3644: di.agreement_id agreement_id,
3645: agr.customer_id customer_id,
3646: rtn.task_id rtn_task_id
3647: FROM pa_draft_invoice_items dii,
3648: pa_draft_invoices_all di,
3649: pa_agreements_all agr,
3650: pa_proj_retn_rules rtn
3651: WHERE di.project_id = p_project_id

Line 3697: FROM pa_draft_invoice_items dii,

3693: dii.retention_rule_id retention_rule_id,
3694: di.agreement_id agreement_id,
3695: agr.customer_id customer_id,
3696: dii.task_id dii_task_id
3697: FROM pa_draft_invoice_items dii,
3698: pa_draft_invoices_all di,
3699: pa_agreements_all agr
3700: WHERE di.project_id = p_project_id
3701: AND di.draft_invoice_num = p_draft_invoice_num