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

Line 126: from pa_draft_invoice_items dii,

122: /* Added for Payroll Billing ER #11847630 - Start */
123: ,nvl(dii.credit_process_flag,'N') credit_process_flag
124: ,dii.inv_exchange_rate
125: /* Added for Payroll Billing ER #11847630 - End */
126: from pa_draft_invoice_items dii,
127: pa_draft_invoices_all di
128: where dii.project_id = P_Project_Id
129: and dii.draft_invoice_num = P_Draft_Inv_Num
130: and dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')

Line 143: from pa_draft_invoice_items dii,

139: /* Added for Payroll Billing ER #11847630 - Start */
140: ,nvl(dii.credit_process_flag,'N') credit_process_flag
141: ,dii.inv_exchange_rate
142: /* Added for Payroll Billing ER #11847630 - End */
143: from pa_draft_invoice_items dii,
144: pa_draft_invoices_all di
145: where dii.project_id = P_Project_Id
146: and dii.draft_invoice_num = P_Draft_Inv_Num
147: and dii.invoice_line_type = 'RETENTION'

Line 162: pa_draft_invoice_items dii

158: dii.line_num line,
159: dii.projfunc_bill_amount,
160: NVL(di.retention_invoice_flag,'N') retention_invoice_flag
161: from pa_draft_invoices di,
162: pa_draft_invoice_items dii
163: where di.project_id = dii.project_id
164: and di.draft_invoice_num = dii.draft_invoice_num
165: and di.project_id = P_Project_Id
166: and di.draft_invoice_num = P_Draft_Inv_Num

Line 375: Update pa_draft_invoice_items

371: ,projfunc_invtrans_ex_rate = NULL
372: where project_id = P_Project_Id
373: and draft_invoice_num = P_Draft_Inv_Num;
374:
375: Update pa_draft_invoice_items
376: set inv_amount = amount
377: where project_id = P_Project_Id
378: and draft_invoice_num = P_Draft_Inv_Num;
379:

Line 398: Update pa_draft_invoice_items

394: ,inv_exchange_rate = NULL
395: where project_id = P_Project_Id
396: and draft_invoice_num = P_Draft_Inv_Num;
397:
398: Update pa_draft_invoice_items
399: set inv_amount = amount
400: where project_id = P_Project_Id
401: and draft_invoice_num = P_Draft_Inv_Num;
402:

Line 435: Update pa_draft_invoice_items

431: ,inv_exchange_rate = NULL
432: where project_id = P_Project_Id
433: and draft_invoice_num = P_Draft_Inv_Num;
434:
435: Update pa_draft_invoice_items
436: set inv_amount = projfunc_bill_amount
437: where project_id = P_Project_Id
438: and draft_invoice_num = P_Draft_Inv_Num;
439:

Line 579: update pa_draft_invoice_items

575: IF g1_debug_mode = 'Y' THEN
576: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Update DII ');
577: END IF;
578:
579: update pa_draft_invoice_items
580: set inv_amount = l_inv_amt
581: ,inv_rate_type = decode(CREDIT_PROCESs_FLAG,'X',inv_rate_type,l_inv_rate_type)
582: ,inv_rate_date = decode(CREDIT_PROCESs_FLAG,'X',inv_rate_date,l_inv_rate_date)
583: ,inv_exchange_rate = decode(CREDIT_PROCESs_FLAG,'X',inv_exchange_rate,l_rate)

Line 665: update pa_draft_invoice_items

661: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || 'Retention Amount in IPC : ' || cur_get_ret_lines.amt);
662: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || 'Retention Amount in ITC : ' || l_inv_ret_amt);
663: END IF;
664:
665: update pa_draft_invoice_items
666: set inv_amount = l_inv_ret_amt
667: where rowid = cur_get_ret_lines.dii_rowid;
668:
669: l_total_retn_amount := NVL(l_total_retn_amount,0) + NVL(l_inv_ret_amt,0);

Line 679: FROM pa_draft_invoice_items

675: /*Added for Payroll Billing Integration Bug# 12383803*/
676:
677: SELECT NVL(sum(amount * inv_exchange_rate),0)
678: INTO l_conv_rev_amt
679: FROM pa_draft_invoice_items
680: WHERE project_id = P_Project_Id
681: AND draft_invoice_num = P_Draft_Inv_Num
682: AND NVL(credit_process_flag ,'N') = 'X';
683: l_con_amt := pa_currency.round_trans_currency_amt((((l_tot_proj_amt/

Line 700: Update PA_DRAFT_INVOICE_ITEMS dii

696: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Total Calcul Amount : ' || l_con_amt);
697: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Total Round Off Amt : ' || l_round_off_amt);
698: END IF;
699: /*Added nvl for l_round_off_amt for bug 12604419*/
700: Update PA_DRAFT_INVOICE_ITEMS dii
701: SET dii.Inv_amount = pa_currency.round_trans_currency_amt(
702: dii.Inv_amount - nvl(l_round_off_amt,0),l_inv_currency_code)
703: Where dii.project_id = P_Project_Id
704: and dii.Draft_Invoice_num = P_Draft_Inv_Num

Line 712: update pa_draft_invoice_items

708: /* Set invoice currency amount for net zero line to zero */
709: IF g1_debug_mode = 'Y' THEN
710: PA_MCB_INVOICE_PKG.log_message('recalculATE: ' || ' Update DII for net zero ');
711: END IF;
712: update pa_draft_invoice_items
713: set inv_amount = 0
714: where project_id = P_Project_Id
715: and draft_invoice_num = P_Draft_Inv_Num
716: and invoice_line_type = 'NET ZERO ADJUSTMENT';

Line 740: FROM pa_draft_invoice_items dii

736:
737: /* Start of comment for bug 2544659 : To avoid divide by 0 on 0$ invoices
738: SELECT NVL(sum(dii.inv_amount),0)/NVL(sum(dii.projfunc_bill_amount),0)
739: INTO l_projfunc_invtrans_rate
740: FROM pa_draft_invoice_items dii
741: WHERE dii.project_id = P_Project_Id
742: AND dii.draft_invoice_num = P_Draft_Inv_Num;
743: End of comment for bug 2544659*/
744:

Line 749: FROM pa_draft_invoice_items dii

745: /* Code added for bug 2544659 */
746: /* Code Commented for bug 3436063
747: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
748: INTO l_projfunc_invtrans_rate
749: FROM pa_draft_invoice_items dii
750: WHERE dii.project_id = P_Project_Id
751: AND dii.draft_invoice_num = P_Draft_Inv_Num
752: AND nvl(dii.projfunc_bill_amount,0) <> 0
753: AND rownum=1;

Line 759: FROM pa_draft_invoice_items dii

755: /****Code added for 3436063****/
756:
757: SELECT sum(NVL(dii.projfunc_bill_amount,0))
758: INTO l_sum_projfunc_bill_amount
759: FROM pa_draft_invoice_items dii
760: WHERE dii.project_id = P_Project_Id
761: AND dii.draft_invoice_num = P_Draft_Inv_Num;
762:
763: /*** For Bug 5346566 ***/

Line 766: FROM pa_draft_invoice_items dii

762:
763: /*** For Bug 5346566 ***/
764: SELECT sum(NVL(dii.inv_amount,0))
765: INTO l_sum_inv_amount
766: FROM pa_draft_invoice_items dii
767: WHERE dii.project_id = P_Project_Id
768: AND dii.draft_invoice_num = P_Draft_Inv_Num;
769: /*** End of code change for Bug 5346566 ***/
770:

Line 775: FROM pa_draft_invoice_items dii

771: IF l_sum_projfunc_bill_amount <> 0 AND l_sum_inv_amount <> 0 /*** Condition added for bug 5346566 ***/
772: THEN
773: SELECT sum(NVL(dii.inv_amount,0))/sum(NVL(dii.projfunc_bill_amount,0))
774: INTO l_projfunc_invtrans_rate
775: FROM pa_draft_invoice_items dii
776: WHERE dii.project_id = P_Project_Id
777: AND dii.draft_invoice_num = P_Draft_Inv_Num
778: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
779: ELSE

Line 782: FROM pa_draft_invoice_items dii

778: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
779: ELSE
780: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
781: INTO l_projfunc_invtrans_rate
782: FROM pa_draft_invoice_items dii
783: WHERE dii.project_id = P_Project_Id
784: AND dii.draft_invoice_num = P_Draft_Inv_Num
785: AND nvl(dii.projfunc_bill_amount,0) <> 0
786: AND rownum=1;

Line 1051: from pa_draft_invoice_items dii,

1047: is
1048: select sum(dii.amount),
1049: sum(dii.inv_amount),
1050: nvl(di.canceled_flag,'N'),max(dii.line_num) /*Added max line for bug 6501526*/
1051: from pa_draft_invoice_items dii,
1052: pa_draft_invoices di
1053: where di.project_id = P_Project_Id
1054: and di.draft_invoice_num = P_Draft_Inv_Num_Credited
1055: and di.project_id = dii.project_id

Line 1070: pa_draft_invoice_items cmdii

1066: cmdi.retention_percentage retper,
1067: cmdi.inv_currency_code curcode,
1068: cmdii.line_num line_num
1069: from pa_draft_invoices cmdi,
1070: pa_draft_invoice_items cmdii
1071: where cmdi.project_id = P_Project_Id
1072: and cmdi.draft_invoice_num = P_Draft_Inv_Num
1073: and cmdi.project_id = cmdii.project_id
1074: and cmdi.draft_invoice_num = cmdii.draft_invoice_num

Line 1086: pa_draft_invoice_items cmdii,

1082: cmdi.retention_percentage retper,
1083: cmdi.inv_currency_code curcode,
1084: cmdii.line_num line_num
1085: from pa_draft_invoices cmdi,
1086: pa_draft_invoice_items cmdii,
1087: pa_draft_invoice_items cmdii1
1088: where cmdi.project_id = P_Project_Id
1089: and cmdi.draft_invoice_num = P_Draft_Inv_Num
1090: and cmdi.project_id = cmdii.project_id

Line 1087: pa_draft_invoice_items cmdii1

1083: cmdi.inv_currency_code curcode,
1084: cmdii.line_num line_num
1085: from pa_draft_invoices cmdi,
1086: pa_draft_invoice_items cmdii,
1087: pa_draft_invoice_items cmdii1
1088: where cmdi.project_id = P_Project_Id
1089: and cmdi.draft_invoice_num = P_Draft_Inv_Num
1090: and cmdi.project_id = cmdii.project_id
1091: and cmdi.draft_invoice_num = cmdii.draft_invoice_num

Line 1105: from pa_draft_invoice_items

1101: cursor get_ret_amt
1102: is
1103: select amount,
1104: line_num
1105: from pa_draft_invoice_items
1106: where project_id = P_Project_Id
1107: and draft_invoice_num = P_Draft_Inv_Num
1108: and invoice_line_type = 'RETENTION'
1109: for update of amount;

Line 1120: pa_draft_invoice_items cmdii,

1116: select cmdii.amount amt,
1117: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
1118: cmdii.line_num line_num
1119: from pa_draft_invoices cmdi,
1120: pa_draft_invoice_items cmdii,
1121: pa_draft_invoice_items cmdii1
1122: where cmdi.project_id = P_Project_Id
1123: and cmdi.draft_invoice_num = P_Draft_Inv_Num
1124: and cmdi.project_id = cmdii.project_id

Line 1121: pa_draft_invoice_items cmdii1

1117: pa_currency.round_trans_currency_amt((cmdii.amount* cmdii1.inv_amount/cmdii1.amount ),cmdi.inv_currency_code) line_amt,
1118: cmdii.line_num line_num
1119: from pa_draft_invoices cmdi,
1120: pa_draft_invoice_items cmdii,
1121: pa_draft_invoice_items cmdii1
1122: where cmdi.project_id = P_Project_Id
1123: and cmdi.draft_invoice_num = P_Draft_Inv_Num
1124: and cmdi.project_id = cmdii.project_id
1125: and cmdi.draft_invoice_num = cmdii.draft_invoice_num

Line 1288: Update pa_draft_invoice_items

1284: ,projfunc_invtrans_ex_rate = NULL
1285: where project_id = P_Project_Id
1286: and draft_invoice_num = P_Draft_Inv_Num;
1287:
1288: Update pa_draft_invoice_items
1289: set inv_amount = amount
1290: where project_id = P_Project_Id
1291: and draft_invoice_num = P_Draft_Inv_Num;
1292:

Line 1312: Update pa_draft_invoice_items

1308: ,inv_exchange_rate = NULL
1309: where project_id = P_Project_Id
1310: and draft_invoice_num = P_Draft_Inv_Num;
1311:
1312: Update pa_draft_invoice_items
1313: set inv_amount = amount
1314: where project_id = P_Project_Id
1315: and draft_invoice_num = P_Draft_Inv_Num;
1316:

Line 1337: Update pa_draft_invoice_items

1333: ,inv_exchange_rate = NULL
1334: where project_id = P_Project_Id
1335: and draft_invoice_num = P_Draft_Inv_Num;
1336:
1337: Update pa_draft_invoice_items
1338: set inv_amount = projfunc_bill_amount
1339: where project_id = P_Project_Id
1340: and draft_invoice_num = P_Draft_Inv_Num;
1341:

Line 1363: Update pa_draft_invoice_items

1359: -- Updation of Non Retention Line
1360: for cur_get_adjust_cm in get_adjust_cm ( l_inv_cur_amt,
1361: l_proj_cur_amt )
1362: loop
1363: Update pa_draft_invoice_items
1364: set inv_amount = cur_get_adjust_cm.line_amt
1365: where current of get_adjust_cm;
1366:
1367: l_tot_inv_cur_amt := l_tot_inv_cur_amt + cur_get_adjust_cm.line_amt;

Line 1393: update pa_draft_invoice_items

1389:
1390: l_tot_proj_cur_amt := l_tot_proj_cur_amt + l_ret_proj_cur_amt;
1391: l_tot_inv_cur_amt := l_tot_inv_cur_amt + l_ret_amt;
1392:
1393: update pa_draft_invoice_items
1394: set inv_amount = l_ret_amt
1395: where current of get_ret_amt;
1396:
1397: l_max_line_num := l_line_num;

Line 1407: update pa_draft_invoice_items dii

1403: else /* added for 2689348 for new retention model */
1404:
1405: for cur_mult_ret_amt in get_mult_ret_amt
1406: loop
1407: update pa_draft_invoice_items dii
1408: set inv_amount= cur_mult_ret_amt.line_amt
1409: where current of get_mult_ret_amt;
1410:
1411: l_tot_inv_cur_amt := l_tot_inv_cur_amt + cur_mult_ret_amt.line_amt;

Line 1424: update pa_draft_invoice_items

1420: l_round_off_amt := l_tot_inv_cur_amt -
1421: pa_currency.round_trans_currency_amt((l_inv_cur_amt/l_proj_cur_amt)
1422: *l_tot_proj_cur_amt,l_curcode);
1423:
1424: update pa_draft_invoice_items
1425: set inv_amount = inv_amount - l_round_off_amt
1426: where project_id = P_Project_Id
1427: and draft_invoice_num = P_Draft_Inv_Num
1428: and line_num = l_max_line_num

Line 1436: Update pa_draft_invoice_items dii

1432:
1433: Else
1434:
1435: -- For Cancellation Of Invoice
1436: Update pa_draft_invoice_items dii
1437: set dii.inv_amount = ( select (-1)*dii1.inv_amount
1438: from pa_draft_invoice_items dii1
1439: where dii1.project_id = dii.project_id
1440: and dii1.draft_invoice_num = P_Draft_Inv_Num_credited

Line 1438: from pa_draft_invoice_items dii1

1434:
1435: -- For Cancellation Of Invoice
1436: Update pa_draft_invoice_items dii
1437: set dii.inv_amount = ( select (-1)*dii1.inv_amount
1438: from pa_draft_invoice_items dii1
1439: where dii1.project_id = dii.project_id
1440: and dii1.draft_invoice_num = P_Draft_Inv_Num_credited
1441: and dii1.line_num
1442: = dii.draft_inv_line_num_credited)

Line 1453: FROM pa_draft_invoice_items dii

1449: /* Start of comment for bug 2544659 : To avoid divide by 0 on 0$ invoices
1450:
1451: SELECT NVL(sum(dii.inv_amount),0)/NVL(sum(dii.amount),0)
1452: INTO l_rate
1453: FROM pa_draft_invoice_items dii
1454: WHERE dii.project_id = P_Project_Id
1455: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1456: End of comments for bug 2544659 */
1457:

Line 1462: FROM pa_draft_invoice_items dii

1458: /* code fix for bug 2544659 */
1459: /*Code commented for 3436063
1460: SELECT NVL(dii.inv_amount,0)/NVL(dii.amount,0)
1461: INTO l_rate
1462: FROM pa_draft_invoice_items dii
1463: WHERE dii.project_id = P_Project_Id
1464: AND dii.draft_invoice_num = P_Draft_Inv_Num
1465: AND nvl(dii.amount,0)<>0
1466: AND rownum=1 ;

Line 1472: FROM pa_draft_invoice_items dii

1468: /****Code added for 3436063****/
1469: /* commented for bug 6501526
1470: SELECT sum(NVL(dii.projfunc_bill_amount,0))
1471: INTO l_sum_projfunc_bill_amount
1472: FROM pa_draft_invoice_items dii
1473: WHERE dii.project_id = P_Project_Id
1474: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1475: */
1476: /*** For Bug 5346566 ***/

Line 1480: FROM pa_draft_invoice_items dii

1476: /*** For Bug 5346566 ***/
1477: /* commented for bug 6501526
1478: SELECT sum(NVL(dii.inv_amount,0))
1479: INTO l_sum_inv_amount
1480: FROM pa_draft_invoice_items dii
1481: WHERE dii.project_id = P_Project_Id
1482: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1483: */
1484: /*** End of code change for Bug 5346566 ***/

Line 1491: FROM pa_draft_invoice_items dii

1487: IF l_sum_projfunc_bill_amount <> 0 AND l_sum_inv_amount <> 0 /*** Condtion added for bug 5346566 ***
1488: THEN
1489: SELECT sum(NVL(dii.inv_amount,0))/sum(NVL(dii.amount,0))
1490: INTO l_rate
1491: FROM pa_draft_invoice_items dii
1492: WHERE dii.project_id = P_Project_Id
1493: AND dii.draft_invoice_num = P_Draft_Inv_Num
1494: having sum(nvl(dii.amount,0)) <> 0;
1495: ELSE

Line 1498: FROM pa_draft_invoice_items dii

1494: having sum(nvl(dii.amount,0)) <> 0;
1495: ELSE
1496: SELECT NVL(dii.inv_amount,0)/NVL(dii.amount,0)
1497: INTO l_rate
1498: FROM pa_draft_invoice_items dii
1499: WHERE dii.project_id = P_Project_Id
1500: AND dii.draft_invoice_num = P_Draft_Inv_Num
1501: AND nvl(dii.amount,0) <> 0
1502: AND rownum=1;

Line 1551: FROM pa_draft_invoice_items dii

1547:
1548: /* Start of comment for bug 2544659 : To avoid divide by 0 on 0$ invoices
1549: SELECT NVL(sum(dii.inv_amount),0)/NVL(sum(dii.projfunc_bill_amount),0)
1550: INTO l_projfunc_invtrans_rate
1551: FROM pa_draft_invoice_items dii
1552: WHERE dii.project_id = P_Project_Id
1553: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1554: End of comments for bug 2544659 */
1555:

Line 1560: FROM pa_draft_invoice_items dii

1556: /* Code added for bug 2544659 */
1557: /*Code commented for 3436063
1558: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
1559: INTO l_projfunc_invtrans_rate
1560: FROM pa_draft_invoice_items dii
1561: WHERE dii.project_id = P_Project_Id
1562: AND dii.draft_invoice_num = P_Draft_Inv_Num
1563: AND nvl(dii.projfunc_bill_amount,0) <> 0
1564: AND rownum=1;

Line 1570: FROM pa_draft_invoice_items dii

1566:
1567: /****Code added for 3436063****/
1568: SELECT sum(NVL(dii.projfunc_bill_amount,0))
1569: INTO l_sum_projfunc_bill_amount
1570: FROM pa_draft_invoice_items dii
1571: WHERE dii.project_id = P_Project_Id
1572: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1573:
1574: /*** For Bug 5346566 ***/

Line 1577: FROM pa_draft_invoice_items dii

1573:
1574: /*** For Bug 5346566 ***/
1575: SELECT sum(NVL(dii.inv_amount,0))
1576: INTO l_sum_inv_amount
1577: FROM pa_draft_invoice_items dii
1578: WHERE dii.project_id = P_Project_Id
1579: AND dii.draft_invoice_num = P_Draft_Inv_Num;
1580: /*** End of code change for Bug 5346566 ***/
1581:

Line 1586: FROM pa_draft_invoice_items dii

1582: IF l_sum_projfunc_bill_amount <> 0 AND l_sum_inv_amount <> 0 /*** Condition added for bug 5346566 ***/
1583: THEN
1584: SELECT sum(NVL(dii.inv_amount,0))/sum(NVL(dii.projfunc_bill_amount,0))
1585: INTO l_projfunc_invtrans_rate
1586: FROM pa_draft_invoice_items dii
1587: WHERE dii.project_id = P_Project_Id
1588: AND dii.draft_invoice_num = P_Draft_Inv_Num
1589: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
1590: ELSE

Line 1593: FROM pa_draft_invoice_items dii

1589: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
1590: ELSE
1591: SELECT NVL(dii.inv_amount,0)/NVL(dii.projfunc_bill_amount,0)
1592: INTO l_projfunc_invtrans_rate
1593: FROM pa_draft_invoice_items dii
1594: WHERE dii.project_id = P_Project_Id
1595: AND dii.draft_invoice_num = P_Draft_Inv_Num
1596: AND nvl(dii.projfunc_bill_amount,0) <> 0
1597: AND rownum=1;

Line 1717: AND EXISTS (SELECT 1 from PA_DRAFT_INVOICE_ITEMS dii

1713: AND nvl(i.generation_error_flag, 'N') = 'N'
1714: AND i.project_id+0 = P_Project_ID
1715: AND i.agreement_id = agr.agreement_id
1716: AND p_calling_process = 'PROJECT_INVOICES'
1717: AND EXISTS (SELECT 1 from PA_DRAFT_INVOICE_ITEMS dii
1718: WHERE dii.project_id = i.project_id
1719: AND dii.draft_invoice_num = i.draft_invoice_num)
1720: UNION
1721: SELECT i.project_id,

Line 1736: AND EXISTS (SELECT 1 from PA_DRAFT_INVOICE_ITEMS dii

1732: AND i.project_id+0 = P_Project_ID
1733: AND i.agreement_id = agr.agreement_id
1734: AND p_calling_process = 'RETENTION_INVOICES'
1735: AND i.retention_invoice_flag ='Y'
1736: AND EXISTS (SELECT 1 from PA_DRAFT_INVOICE_ITEMS dii
1737: WHERE dii.project_id = i.project_id
1738: AND dii.draft_invoice_num = i.draft_invoice_num);
1739:
1740: