APPS.PA_RETENTION_PKG dependencies on PA_CUST_EVENT_RDL_ALL

Line 639: FROM pa_cust_event_rdl_all erdl

635: SUM(erdl.projfunc_bill_amount) pfc_invoice_amount,
636: SUM(erdl.project_bill_amount) pc_invoice_amount,
637: SUM(erdl.funding_bill_amount) fc_invoice_amount,
638: SUM(erdl.bill_trans_amount) btc_invoice_amount
639: FROM pa_cust_event_rdl_all erdl
640: WHERE erdl.project_id = p_project_id
641: AND erdl.request_id = p_request_id
642: AND erdl.draft_invoice_num = p_draft_invoice_num
643: GROUP BY erdl.retention_rule_id

Line 1473: UPDATE pa_cust_event_rdl_all

1469: IF g1_debug_mode = 'Y' THEN
1470: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update ERDLs ');
1471: END IF;
1472:
1473: UPDATE pa_cust_event_rdl_all
1474: SET retn_draft_invoice_num = p_draft_invoice_num,
1475: retn_draft_invoice_line_num = LastLineNum,
1476: retained_amount =
1477: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1895: UPDATE pa_cust_event_rdl_all erdl

1891:
1892:
1893: -- 1. Update the Event Type Level Retention Setup in ERDLs
1894:
1895: UPDATE pa_cust_event_rdl_all erdl
1896: SET erdl.retention_rule_id=
1897: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1898: rt.retention_rule_id,
1899: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1942: UPDATE pa_cust_event_rdl_all erdl

1938: pa_retention_util.write_log('ERDL: No Records Update At Event Type Level ' ||sql%rowcount);
1939: END IF;
1940: -- 2. Update the Revenue Category Level Retention Setup in ERDLs
1941:
1942: UPDATE pa_cust_event_rdl_all erdl
1943: SET erdl.retention_rule_id=
1944: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1945: rt.retention_rule_id,
1946: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),

Line 1987: UPDATE pa_cust_event_rdl_all erdl

1983: pa_retention_util.write_log('ERDL: No Records Update At Revenue Category Level ' ||sql%rowcount);
1984: END IF;
1985: -- 3. Update the Project Level Retention Setup in ERDLs
1986:
1987: UPDATE pa_cust_event_rdl_all erdl
1988: SET erdl.retention_rule_id=
1989: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1990: rt.retention_rule_id,
1991: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2372: UPDATE pa_cust_event_rdl_all erdl

2368: END IF;
2369:
2370: -- 1. Update the Event Type Level Retention Setup in ERDLs
2371:
2372: UPDATE pa_cust_event_rdl_all erdl
2373: SET erdl.retention_rule_id=
2374: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2375: rt.retention_rule_id,
2376: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2427: UPDATE pa_cust_event_rdl_all erdl

2423: END IF;
2424:
2425: -- 2. Update the Revenue Category Level Retention Setup in ERDLs
2426:
2427: UPDATE pa_cust_event_rdl_all erdl
2428: SET erdl.retention_rule_id=
2429: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2430: rt.retention_rule_id,
2431: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2480: UPDATE pa_cust_event_rdl_all erdl

2476: END IF;
2477:
2478: -- 3. Update the Top Task Level Retention Setup in ERDLs
2479:
2480: UPDATE pa_cust_event_rdl_all erdl
2481: SET erdl.retention_rule_id=
2482: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2483: rt.retention_rule_id,
2484: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),