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_MCB_INVOICE_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 1410: FROM pa_draft_invoice_items dii

1406: tmp_rate_tab(1) := p_inv_ex_rate; -- Bug 4298230
1407:
1408: SELECT NVL(sum(dii.bill_trans_bill_amount),0)
1409: INTO tmp_bill_trans_amount_tab(1)
1410: FROM pa_draft_invoice_items dii
1411: WHERE dii.project_id = p_project_id
1412: AND dii.draft_invoice_num = p_draft_invoice_num
1413: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1414: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'

Line 1491: FROM pa_draft_invoice_items dii

1487: /*Start of code change for Bug 6084445*/
1488:
1489: SELECT sum(NVL(dii.projfunc_bill_amount,0))
1490: INTO l_sum_projfunc_bill_amount
1491: FROM pa_draft_invoice_items dii
1492: WHERE dii.project_id = P_Project_Id
1493: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1494: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1495: AND dii.invoice_line_type <> 'RETENTION'

Line 1500: FROM pa_draft_invoice_items dii

1496: AND dii.draft_invoice_num = p_draft_invoice_num;
1497:
1498: SELECT sum(NVL(dii.bill_trans_bill_amount,0))
1499: INTO l_sum_inv_amount
1500: FROM pa_draft_invoice_items dii
1501: WHERE dii.project_id = P_Project_Id
1502: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1503: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1504: AND dii.invoice_line_type <> 'RETENTION'

Line 1512: FROM pa_draft_invoice_items dii

1508: IF l_sum_projfunc_bill_amount <> 0 AND l_sum_inv_amount <> 0
1509: THEN
1510: SELECT sum(NVL(dii.bill_trans_bill_amount,0))/sum(NVL(dii.projfunc_bill_amount,0))
1511: INTO l_rate
1512: FROM pa_draft_invoice_items dii
1513: WHERE dii.project_id = P_Project_Id
1514: AND dii.draft_invoice_num = p_draft_invoice_num
1515: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1516: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'

Line 1525: FROM pa_draft_invoice_items dii

1521: BEGIN
1522:
1523: SELECT NVL(dii.bill_trans_bill_amount,0)/NVL(dii.projfunc_bill_amount,0)
1524: INTO l_rate
1525: FROM pa_draft_invoice_items dii
1526: WHERE dii.project_id = P_Project_Id
1527: AND dii.draft_invoice_num = p_draft_invoice_num
1528: AND nvl(dii.projfunc_bill_amount,0) <> 0
1529: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')

Line 1544: FROM pa_draft_invoice_items dii

1540:
1541: /* Commented for Bug 6084445 Start
1542: SELECT NVL(sum(dii.bill_trans_bill_amount),0) / nvl(sum(dii.projfunc_bill_amount),0)
1543: INTO l_rate
1544: FROM pa_draft_invoice_items dii
1545: WHERE dii.project_id = p_project_id
1546: AND dii.draft_invoice_num = p_draft_invoice_num
1547: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1548: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'

Line 1567: FROM pa_draft_invoice_items dii

1563: PA_MCB_INVOICE_PKG.log_message('cal_conversion_Attr: ' || 'Before the Select statement ');
1564:
1565: SELECT NVL(sum(dii.bill_trans_bill_amount),0)
1566: INTO tmp_bill_trans_amount_tab(1)
1567: FROM pa_draft_invoice_items dii
1568: WHERE dii.project_id = p_project_id
1569: AND dii.draft_invoice_num = p_draft_invoice_num
1570: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1571: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'

Line 1694: pa_draft_invoice_items dii,

1690: dii.invoice_line_type,
1691: NVL(dii.event_num,0) event_num,
1692: NVL(evt.revenue_amount,0) revenue_amount
1693: FROM pa_draft_invoices_all di,
1694: pa_draft_invoice_items dii,
1695: pa_events evt
1696: WHERE di.project_id = p_project_id
1697: AND di.project_id = dii.project_id
1698: AND dii.request_id = p_request_id

Line 1716: FROM pa_draft_invoices_all di, pa_draft_invoice_items dii

1712: CURSOR cur_cm IS
1713: SELECT di.draft_invoice_num,
1714: di.draft_invoice_num_credited,
1715: dii.line_num
1716: FROM pa_draft_invoices_all di, pa_draft_invoice_items dii
1717: WHERE di.project_id = p_project_id
1718: AND di.request_id = p_request_id
1719: AND dii.project_id= di.project_id
1720: AND dii.draft_invoice_num = di.draft_invoice_num

Line 1875: UPDATE pa_draft_invoice_items dii

1871:
1872: /* Bug 4735682: Following update clause altered to include the exchange rate *
1873:
1874: /* Commented and rewritten for bug 4735682
1875: UPDATE pa_draft_invoice_items dii
1876: SET dii.inv_amount =
1877: (SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) FROM pa_cust_rev_dist_lines_all rdl
1878: WHERE rdl.project_id = dii.project_id
1879: AND rdl.draft_invoice_num = dii.draft_invoice_num

Line 1899: UPDATE pa_draft_invoice_items dii

1895: /* End of bug 4735682 .. bug 4995695 */
1896:
1897: /* Bug 4995695.. modified the query for compatibility with 8i */
1898:
1899: UPDATE pa_draft_invoice_items dii
1900: SET dii.inv_amount =
1901: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_calc_inv_amount, l_head_inv_curr_code)
1902: WHERE dii.project_id = p_project_id
1903: AND dii.draft_invoice_num = cm_rec.draft_invoice_num

Line 1907: UPDATE pa_draft_invoice_items dii

1903: AND dii.draft_invoice_num = cm_rec.draft_invoice_num
1904: AND dii.line_num = cm_rec.line_num
1905: AND dii.invoice_line_type = 'STANDARD';
1906:
1907: UPDATE pa_draft_invoice_items dii
1908: SET inv_amount = bill_trans_bill_amount
1909: WHERE dii.project_id = p_project_id
1910: AND dii.draft_invoice_num = cm_rec.draft_invoice_num
1911: AND dii.line_num = cm_rec.line_num

Line 2042: UPDATE pa_draft_invoice_items

2038: IF (TmpInvHeaders.EXISTS(TmpInvHeaders.first)) THEN
2039: -- Reset the line number for newly created invoices
2040: /* Bug 2870248 fix starts*/
2041: FOR k IN TmpInvLines.FIRST.. TmpInvLines.LAST LOOP
2042: UPDATE pa_draft_invoice_items
2043: SET line_num = TmpInvLines(k).current_line_num+1000000
2044: WHERE project_id = p_project_id
2045: AND request_id = p_request_id
2046: AND draft_invoice_num = TmpInvLines(k).current_draft_invoice_num

Line 2091: UPDATE pa_draft_invoice_items

2087: -- ' N Inv Num : ' || TmpInvLInes(k).new_draft_invoice_num ||
2088: -- ' O LineNum : ' || TmpInvLInes(k).current_line_num ||
2089: -- ' N Inv Num : ' || TmpInvLInes(k).new_line_num);
2090:
2091: UPDATE pa_draft_invoice_items
2092: SET draft_invoice_num = TmpInvLines(k).new_draft_invoice_num,
2093: line_num = TmpInvLines(k).new_line_num,
2094: inv_amount= bill_trans_bill_amount
2095: WHERE project_id = p_project_id

Line 2130: update pa_draft_invoice_items

2126: END LOOP;
2127:
2128: -- Final Update to calculate the rate between invoice currency and project functional currency
2129:
2130: update pa_draft_invoice_items
2131: set inv_amount = 0
2132: where project_id = P_Project_Id
2133: and invoice_line_type = 'NET ZERO ADJUSTMENT'
2134: and request_id = p_request_id;

Line 2164: FROM pa_draft_invoice_items dii

2160: l_pc_amount,
2161: l_btc_amount,
2162: l_fc_amount,
2163: l_ret_line_num
2164: FROM pa_draft_invoice_items dii
2165: WHERE dii.project_id = P_Project_Id
2166: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2167: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
2168: AND dii.invoice_line_type <> 'RETENTION';

Line 2191: FROM pa_draft_invoice_items dii

2187:
2188: /* Commented for 3436063
2189: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
2190: INTO l_projfunc_invtrans_rate
2191: FROM pa_draft_invoice_items dii
2192: WHERE dii.project_id = P_Project_Id
2193: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2194: AND nvl(dii.projfunc_bill_amount,0) <> 0
2195: AND rownum=1;

Line 2202: FROM pa_draft_invoice_items dii

2198:
2199: /****Code added for 3436063****/
2200: SELECT sum(NVL(dii.projfunc_bill_amount,0))
2201: INTO l_sum_projfunc_bill_amount
2202: FROM pa_draft_invoice_items dii
2203: WHERE dii.project_id = P_Project_Id
2204: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num;
2205:
2206: /*** For Bug 5346566 ***/

Line 2209: FROM pa_draft_invoice_items dii

2205:
2206: /*** For Bug 5346566 ***/
2207: SELECT sum(NVL(dii.inv_amount,0))
2208: INTO l_sum_inv_amount
2209: FROM pa_draft_invoice_items dii
2210: WHERE dii.project_id = P_Project_Id
2211: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num;
2212: /*** End of code change for Bug 5346566 ***/
2213:

Line 2218: FROM pa_draft_invoice_items dii

2214: IF l_sum_projfunc_bill_amount <> 0 AND l_sum_inv_amount <> 0 /*** Condition added for bug 5346566 ***/
2215: THEN
2216: SELECT sum(NVL(dii.inv_amount,0))/sum(NVL(dii.projfunc_bill_amount,0))
2217: INTO l_projfunc_invtrans_rate
2218: FROM pa_draft_invoice_items dii
2219: WHERE dii.project_id = P_Project_Id
2220: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2221: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
2222: ELSE

Line 2227: FROM pa_draft_invoice_items dii

2223: /* Added begin and end to handle the exception for bug 8666892 */
2224: BEGIN
2225: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
2226: INTO l_projfunc_invtrans_rate
2227: FROM pa_draft_invoice_items dii
2228: WHERE dii.project_id = P_Project_Id
2229: AND dii.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num
2230: AND nvl(dii.projfunc_bill_amount,0) <> 0
2231: AND rownum=1;

Line 2424: INSERT INTO pa_draft_invoice_items(

2420: END IF;
2421:
2422: -- Insert new retention line
2423:
2424: INSERT INTO pa_draft_invoice_items(
2425: project_id,
2426: draft_invoice_num,
2427: line_num,
2428: last_update_date,

Line 2522: FROM pa_draft_invoice_items

2518: invproc_currency_code,
2519: TmpInvHeaders(k).inv_currency_code,
2520: NVL(l_btc_amount,0) *
2521: (NVL(TmpInvHeaders(k).retention_percentage,0)/100)
2522: FROM pa_draft_invoice_items
2523: WHERE project_id = p_project_id
2524: AND draft_invoice_num = TmpInvHeaders(k).current_draft_invoice_num
2525: AND invoice_Line_type ='RETENTION';
2526:

Line 2560: UPDATE pa_draft_invoice_items

2556: IF g1_debug_mode = 'Y' THEN
2557: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || ' Update Existing Invoice Retention Line ');
2558: END IF;
2559:
2560: UPDATE pa_draft_invoice_items
2561: SET bill_trans_currency_code = TmpInvHeaders(k).inv_currency_code,
2562: projfunc_bill_amount =
2563: NVL(l_pfc_amount,0) *
2564: (NVL(TmpInvHeaders(k).retention_percentage,0)/100),