[Home] [Help]
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'
1415: AND dii.invoice_line_type <> 'RETENTION';
1416:
1417: tmp_projfunc_rate_type_tab(1) := p_pfc_rate_type; -- bug 4298230
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'
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'
1505: AND dii.draft_invoice_num = p_draft_invoice_num;
1506:
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'
1517: AND dii.invoice_line_type <> 'RETENTION'
1518: having sum(nvl(dii.projfunc_bill_amount,0)) <> 0;
1519: ELSE
1522: FROM pa_draft_invoice_items dii
1523: WHERE dii.project_id = P_Project_Id
1524: AND dii.draft_invoice_num = p_draft_invoice_num
1525: AND nvl(dii.projfunc_bill_amount,0) <> 0
1526: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1527: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1528: AND dii.invoice_line_type <> 'RETENTION'
1529: AND rownum=1;
1530: END IF;
1535: INTO l_rate
1536: FROM pa_draft_invoice_items dii
1537: WHERE dii.project_id = p_project_id
1538: AND dii.draft_invoice_num = p_draft_invoice_num
1539: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1540: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1541: AND dii.invoice_line_type <> 'RETENTION';
1542: Commented for Bug 6084445 End */
1543:
1558: INTO tmp_bill_trans_amount_tab(1)
1559: FROM pa_draft_invoice_items dii
1560: WHERE dii.project_id = p_project_id
1561: AND dii.draft_invoice_num = p_draft_invoice_num
1562: AND dii.invoice_line_type in ('STANDARD','INVOICE REDUCTION')
1563: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1564: AND dii.invoice_line_type <> 'RETENTION';
1565:
1566: tmp_bill_trans_rate_date_tab(1) :=NVL(p_inv_rate_date,NVL(l_invoice_date,p_bill_thru_date)); -- Bug 4298230
1872: AND rdl.draft_invoice_item_line_num = dii.line_num)
1873: WHERE dii.project_id = p_project_id
1874: AND dii.draft_invoice_num = cm_rec.draft_invoice_num
1875: AND dii.line_num = cm_rec.line_num
1876: AND dii.invoice_line_type = 'STANDARD';
1877: */
1878: /* Select query for bug 4735682 brought out to comply with 8i.. bug 4995695 */
1879:
1880: SELECT sum(nvl(rdl.bill_trans_bill_amount, 0)) * l_head_inv_exch_rate
1893: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_calc_inv_amount, l_head_inv_curr_code)
1894: WHERE dii.project_id = p_project_id
1895: AND dii.draft_invoice_num = cm_rec.draft_invoice_num
1896: AND dii.line_num = cm_rec.line_num
1897: AND dii.invoice_line_type = 'STANDARD';
1898:
1899: UPDATE pa_draft_invoice_items dii
1900: SET inv_amount = bill_trans_bill_amount
1901: WHERE dii.project_id = p_project_id