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_CUST_REV_DIST_LINES

Line 605: FROM pa_cust_rev_dist_lines_all rdl

601: SUM(rdl.projfunc_bill_amount) pfc_invoice_amount,
602: SUM(rdl.project_bill_amount) pc_invoice_amount,
603: SUM(rdl.funding_bill_amount) fc_invoice_amount,
604: SUM(rdl.bill_trans_bill_amount) btc_invoice_amount
605: FROM pa_cust_rev_dist_lines_all rdl
606: WHERE rdl.project_id = p_project_id
607: AND rdl.request_id = p_request_id
608: AND rdl.draft_invoice_num = p_draft_invoice_num
609: GROUP BY rdl.retention_rule_id

Line 1434: UPDATE pa_cust_rev_dist_lines_all

1430: IF g1_debug_mode = 'Y' THEN
1431: pa_retention_util.write_log('Create_Proj_Inv_Retn_Lines: ' || 'Update RDLs ');
1432: END IF;
1433:
1434: UPDATE pa_cust_rev_dist_lines_all
1435: SET retn_draft_invoice_num = p_draft_invoice_num,
1436: retn_draft_invoice_line_num = LastLineNum,
1437: retained_amount =
1438: PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT(

Line 1725: UPDATE pa_cust_rev_dist_lines_all rdl

1721: END IF;
1722:
1723: -- 1. Update the Non Labor Resource Override in RDLs
1724:
1725: UPDATE pa_cust_rev_dist_lines_all rdl
1726: SET rdl.retention_rule_id=
1727: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1728: rt.retention_rule_id,
1729: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1760: UPDATE pa_cust_rev_dist_lines_all rdl

1756:
1757:
1758: -- 2. Update the Expenditure Type Level Override in RDLs
1759:
1760: UPDATE pa_cust_rev_dist_lines_all rdl
1761: SET rdl.retention_rule_id=
1762: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1763: rt.retention_rule_id,
1764: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1795: UPDATE pa_cust_rev_dist_lines_all rdl

1791: END IF;
1792:
1793: -- 3. Update the Expenditure Category Level Override in RDLs
1794:
1795: UPDATE pa_cust_rev_dist_lines_all rdl
1796: SET rdl.retention_rule_id=
1797: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1798: rt.retention_rule_id,
1799: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 1839: UPDATE pa_cust_rev_dist_lines_all rdl

1835:
1836:
1837: -- 4. Update the Project Level Retention Setup in RDLs
1838:
1839: UPDATE pa_cust_rev_dist_lines_all rdl
1840: SET rdl.retention_rule_id=
1841: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
1842: rt.retention_rule_id,
1843: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2176: UPDATE pa_cust_rev_dist_lines_all rdl

2172: END IF;
2173:
2174: -- 1. Update the Non Labor Resource Override in RDLs
2175:
2176: UPDATE pa_cust_rev_dist_lines_all rdl
2177: SET rdl.retention_rule_id=
2178: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2179: rt.retention_rule_id,
2180: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2218: UPDATE pa_cust_rev_dist_lines_all rdl

2214: pa_retention_util.write_log('RDL: No Records Update At Non Labor Level ' ||sql%rowcount);
2215: END IF;
2216: -- 2. Update the Expenditure Type Level Override in RDLs
2217:
2218: UPDATE pa_cust_rev_dist_lines_all rdl
2219: SET rdl.retention_rule_id=
2220: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2221: rt.retention_rule_id,
2222: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2262: UPDATE pa_cust_rev_dist_lines_all rdl

2258: END IF;
2259:
2260: -- 3. Update the Expenditure Category Level Override in RDLs
2261:
2262: UPDATE pa_cust_rev_dist_lines_all rdl
2263: SET rdl.retention_rule_id=
2264: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2265: rt.retention_rule_id,
2266: DECODE(SIGN(NVL(rt.total_retained,0) - NVL(rt.threshold_amount,0)),

Line 2311: UPDATE pa_cust_rev_dist_lines_all rdl

2307: pa_retention_util.write_log('RDL: No Records Update At Expenditure Category Level ' ||sql%rowcount);
2308: END IF;
2309: -- 4. Update the Project Level Retention Setup in RDLs
2310:
2311: UPDATE pa_cust_rev_dist_lines_all rdl
2312: SET rdl.retention_rule_id=
2313: ( SELECT DECODE(NVL(rt.threshold_amount,0),0,
2314: rt.retention_rule_id,
2315: DECODE(SIGN(NVL(rt.total_retained,0) -NVL(rt.threshold_amount,0)),

Line 2725: UPDATE PA_CUST_REV_DIST_LINES

2721: WHERE PROJECT_ID = p_project_id
2722: AND DRAFT_INVOICE_NUM = draftinvoicenum
2723: AND LINE_NUM = NetZeroLineNum * (-1);
2724:
2725: UPDATE PA_CUST_REV_DIST_LINES
2726: SET DRAFT_INVOICE_ITEM_LINE_NUM = LastLineNum
2727: WHERE PROJECT_ID = p_project_id
2728: AND DRAFT_INVOICE_NUM = draftinvoicenum
2729: AND DRAFT_INVOICE_ITEM_LINE_NUM = NetZeroLineNum;

Line 2814: FROM pa_cust_rev_dist_lines_all rdl

2810: CURSOR cur_credit_memo IS
2811: SELECT NVL(rdl.retention_rule_id,-1) retention_rule_id,
2812: SUM(DECODE(NVL(rdl.retention_rule_id,-1) ,-1,
2813: NVL(rdl.bill_amount,0) ,NVL(rdl.retained_amount,0) ) ) invoice_amount
2814: FROM pa_cust_rev_dist_lines_all rdl
2815: WHERE rdl.project_id = p_project_id
2816: -- AND rdl.request_id = p_request_id
2817: AND rdl.draft_invoice_num = l_credit_invoice_num
2818: GROUP BY NVL(rdl.retention_rule_id,-1); */

Line 2826: FROM pa_cust_rev_dist_lines_all rdl

2822: FROM
2823: (SELECT NVL(rdl.retention_rule_id,-1) retention_rule_id,
2824: SUM(DECODE(NVL(rdl.retention_rule_id,-1) ,-1,
2825: NVL(rdl.bill_amount,0) ,NVL(rdl.retained_amount,0) ) ) invoice_amount
2826: FROM pa_cust_rev_dist_lines_all rdl
2827: WHERE rdl.project_id = p_project_id
2828: AND rdl.draft_invoice_num = l_credit_invoice_num
2829: GROUP BY NVL(rdl.retention_rule_id,-1)
2830: UNION

Line 3067: UPDATE pa_cust_rev_dist_lines_all

3063: END IF;
3064:
3065: -- Update the RDL
3066:
3067: UPDATE pa_cust_rev_dist_lines_all
3068: SET retn_draft_invoice_num = l_credit_invoice_num,
3069: retn_draft_invoice_line_num = LastLineNum
3070: WHERE retention_rule_id = InvoiceLines.Retention_rule_id
3071: AND draft_invoice_num = l_credit_invoice_num