APPS.PA_RETENTION_PKG dependencies on PA_CUST_EVENT_RDL_ALL

Line 621: FROM pa_cust_event_rdl_all erdl

617: SUM(erdl.projfunc_bill_amount) pfc_invoice_amount,
618: SUM(erdl.project_bill_amount) pc_invoice_amount,
619: SUM(erdl.funding_bill_amount) fc_invoice_amount,
620: SUM(erdl.bill_trans_amount) btc_invoice_amount
621: FROM pa_cust_event_rdl_all erdl
622: WHERE erdl.project_id = p_project_id
623: AND erdl.request_id = p_request_id
624: AND erdl.draft_invoice_num = p_draft_invoice_num
625: GROUP BY erdl.retention_rule_id

Line 1455: UPDATE pa_cust_event_rdl_all

1451: IF g1_debug_mode = 'Y' THEN
1452: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update ERDLs ');
1453: END IF;
1454:
1455: UPDATE pa_cust_event_rdl_all
1456: SET retn_draft_invoice_num = p_draft_invoice_num,
1457: retn_draft_invoice_line_num = LastLineNum,
1458: retained_amount =
1459: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1876: UPDATE pa_cust_event_rdl_all erdl

1872:
1873:
1874: -- 1. Update the Event Type Level Retention Setup in ERDLs
1875:
1876: UPDATE pa_cust_event_rdl_all erdl
1877: SET erdl.retention_rule_id=
1878: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1879: rt.retention_rule_id,
1880: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1923: UPDATE pa_cust_event_rdl_all erdl

1919: pa_retention_util.write_log('ERDL: No Records Update At Event Type Level ' ||sql%rowcount);
1920: END IF;
1921: -- 2. Update the Revenue Category Level Retention Setup in ERDLs
1922:
1923: UPDATE pa_cust_event_rdl_all erdl
1924: SET erdl.retention_rule_id=
1925: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1926: rt.retention_rule_id,
1927: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),

Line 1968: UPDATE pa_cust_event_rdl_all erdl

1964: pa_retention_util.write_log('ERDL: No Records Update At Revenue Category Level ' ||sql%rowcount);
1965: END IF;
1966: -- 3. Update the Project Level Retention Setup in ERDLs
1967:
1968: UPDATE pa_cust_event_rdl_all erdl
1969: SET erdl.retention_rule_id=
1970: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1971: rt.retention_rule_id,
1972: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2353: UPDATE pa_cust_event_rdl_all erdl

2349: END IF;
2350:
2351: -- 1. Update the Event Type Level Retention Setup in ERDLs
2352:
2353: UPDATE pa_cust_event_rdl_all erdl
2354: SET erdl.retention_rule_id=
2355: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2356: rt.retention_rule_id,
2357: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2408: UPDATE pa_cust_event_rdl_all erdl

2404: END IF;
2405:
2406: -- 2. Update the Revenue Category Level Retention Setup in ERDLs
2407:
2408: UPDATE pa_cust_event_rdl_all erdl
2409: SET erdl.retention_rule_id=
2410: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2411: rt.retention_rule_id,
2412: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2461: UPDATE pa_cust_event_rdl_all erdl

2457: END IF;
2458:
2459: -- 3. Update the Top Task Level Retention Setup in ERDLs
2460:
2461: UPDATE pa_cust_event_rdl_all erdl
2462: SET erdl.retention_rule_id=
2463: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2464: rt.retention_rule_id,
2465: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),