APPS.PA_RETENTION_PKG dependencies on PA_CUST_REV_DIST_LINES

Line 623: FROM pa_cust_rev_dist_lines_all rdl

619: SUM(rdl.projfunc_bill_amount) pfc_invoice_amount,
620: SUM(rdl.project_bill_amount) pc_invoice_amount,
621: SUM(rdl.funding_bill_amount) fc_invoice_amount,
622: SUM(rdl.bill_trans_bill_amount) btc_invoice_amount
623: FROM pa_cust_rev_dist_lines_all rdl
624: WHERE rdl.project_id = p_project_id
625: AND rdl.request_id = p_request_id
626: AND rdl.draft_invoice_num = p_draft_invoice_num
627: GROUP BY rdl.retention_rule_id

Line 1452: UPDATE pa_cust_rev_dist_lines_all

1448: IF g1_debug_mode = 'Y' THEN
1449: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update RDLs ');
1450: END IF;
1451:
1452: UPDATE pa_cust_rev_dist_lines_all
1453: SET retn_draft_invoice_num = p_draft_invoice_num,
1454: retn_draft_invoice_line_num = LastLineNum,
1455: retained_amount =
1456: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1744: UPDATE pa_cust_rev_dist_lines_all rdl

1740: END IF;
1741:
1742: -- 1. Update the Non Labor Resource Override in RDLs
1743:
1744: UPDATE pa_cust_rev_dist_lines_all rdl
1745: SET rdl.retention_rule_id=
1746: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1747: rt.retention_rule_id,
1748: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1779: UPDATE pa_cust_rev_dist_lines_all rdl

1775:
1776:
1777: -- 2. Update the Expenditure Type Level Override in RDLs
1778:
1779: UPDATE pa_cust_rev_dist_lines_all rdl
1780: SET rdl.retention_rule_id=
1781: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1782: rt.retention_rule_id,
1783: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1814: UPDATE pa_cust_rev_dist_lines_all rdl

1810: END IF;
1811:
1812: -- 3. Update the Expenditure Category Level Override in RDLs
1813:
1814: UPDATE pa_cust_rev_dist_lines_all rdl
1815: SET rdl.retention_rule_id=
1816: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1817: rt.retention_rule_id,
1818: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1858: UPDATE pa_cust_rev_dist_lines_all rdl

1854:
1855:
1856: -- 4. Update the Project Level Retention Setup in RDLs
1857:
1858: UPDATE pa_cust_rev_dist_lines_all rdl
1859: SET rdl.retention_rule_id=
1860: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1861: rt.retention_rule_id,
1862: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2195: UPDATE pa_cust_rev_dist_lines_all rdl

2191: END IF;
2192:
2193: -- 1. Update the Non Labor Resource Override in RDLs
2194:
2195: UPDATE pa_cust_rev_dist_lines_all rdl
2196: SET rdl.retention_rule_id=
2197: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2198: rt.retention_rule_id,
2199: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2237: UPDATE pa_cust_rev_dist_lines_all rdl

2233: pa_retention_util.write_log('RDL: No Records Update At Non Labor Level ' ||sql%rowcount);
2234: END IF;
2235: -- 2. Update the Expenditure Type Level Override in RDLs
2236:
2237: UPDATE pa_cust_rev_dist_lines_all rdl
2238: SET rdl.retention_rule_id=
2239: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2240: rt.retention_rule_id,
2241: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2281: UPDATE pa_cust_rev_dist_lines_all rdl

2277: END IF;
2278:
2279: -- 3. Update the Expenditure Category Level Override in RDLs
2280:
2281: UPDATE pa_cust_rev_dist_lines_all rdl
2282: SET rdl.retention_rule_id=
2283: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2284: rt.retention_rule_id,
2285: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2330: UPDATE pa_cust_rev_dist_lines_all rdl

2326: pa_retention_util.write_log('RDL: No Records Update At Expenditure Category Level ' ||sql%rowcount);
2327: END IF;
2328: -- 4. Update the Project Level Retention Setup in RDLs
2329:
2330: UPDATE pa_cust_rev_dist_lines_all rdl
2331: SET rdl.retention_rule_id=
2332: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2333: rt.retention_rule_id,
2334: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),

Line 2759: UPDATE PA_CUST_REV_DIST_LINES

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 */
2758:
2759: UPDATE PA_CUST_REV_DIST_LINES
2760: SET DRAFT_INVOICE_ITEM_LINE_NUM = LastLineNum
2761: WHERE PROJECT_ID = p_project_id
2762: AND DRAFT_INVOICE_NUM = draftinvoicenum
2763: AND DRAFT_INVOICE_ITEM_LINE_NUM = (NetZeroLineNum-NZCount+j); /* Modified for Bug 9690548 */

Line 2851: FROM pa_cust_rev_dist_lines_all rdl

2847: CURSOR cur_credit_memo IS
2848: SELECT NVL(rdl.retention_rule_id,-1) retention_rule_id,
2849: SUM(DECODE(NVL(rdl.retention_rule_id,-1) ,-1,
2850: NVL(rdl.bill_amount,0) ,NVL(rdl.retained_amount,0) ) ) invoice_amount
2851: FROM pa_cust_rev_dist_lines_all rdl
2852: WHERE rdl.project_id = p_project_id
2853: -- AND rdl.request_id = p_request_id
2854: AND rdl.draft_invoice_num = l_credit_invoice_num
2855: GROUP BY NVL(rdl.retention_rule_id,-1); */

Line 2863: FROM pa_cust_rev_dist_lines_all rdl

2859: FROM
2860: (SELECT NVL(rdl.retention_rule_id,-1) retention_rule_id,
2861: SUM(DECODE(NVL(rdl.retention_rule_id,-1) ,-1,
2862: NVL(rdl.bill_amount,0) ,NVL(rdl.retained_amount,0) ) ) invoice_amount
2863: FROM pa_cust_rev_dist_lines_all rdl
2864: WHERE rdl.project_id = p_project_id
2865: AND rdl.draft_invoice_num = l_credit_invoice_num
2866: GROUP BY NVL(rdl.retention_rule_id,-1)
2867: UNION

Line 3104: UPDATE pa_cust_rev_dist_lines_all

3100: END IF;
3101:
3102: -- Update the RDL
3103:
3104: UPDATE pa_cust_rev_dist_lines_all
3105: SET retn_draft_invoice_num = l_credit_invoice_num,
3106: retn_draft_invoice_line_num = LastLineNum
3107: WHERE retention_rule_id = InvoiceLines.Retention_rule_id
3108: AND draft_invoice_num = l_credit_invoice_num