APPS.PA_MCB_INVOICE_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 1377: UPDATE pa_draft_invoices_all

1373: PA_MCB_INVOICE_PKG.log_message('cal_conversion_attr: ' || ' if (p_invproc_currency_code = p_btc_currency_code) AND (p_btc_currency_code = p_pfc_currency_code)');
1374: END IF;
1375: X_Status := NULL;
1376:
1377: UPDATE pa_draft_invoices_all
1378: SET projfunc_invtrans_rate_type = NULL
1379: ,projfunc_invtrans_rate_date = NULL
1380: ,projfunc_invtrans_ex_rate = NULL
1381: WHERE project_id = p_project_id

Line 1398: UPDATE pa_draft_invoices_all

1394:
1395: --The projfunc_inv_trans_rate derived in the procedure Inv_by_Bill_trans_Currency remains as it is
1396: -- We are going to use the same as derived rate with Rate Type ='User and Date= InvoiceDate
1397:
1398: UPDATE pa_draft_invoices_all
1399: SET projfunc_invtrans_rate_type = 'User'
1400: ,projfunc_invtrans_rate_date = l_invoice_date
1401: WHERE project_id = p_project_id
1402: AND draft_invoice_num = p_draft_invoice_num;

Line 1444: UPDATE pa_draft_invoices_all

1440: OPEN reject_reason (tmp_status_tab(1));
1441: FETCH reject_reason INTO l_reject_reason_meaning;
1442: CLOSE reject_reason;
1443:
1444: UPDATE pa_draft_invoices_all
1445: SET generation_error_flag = 'Y',
1446: TRANSFER_REJECTION_REASON = l_reject_reason_meaning
1447: WHERE project_id = p_project_id
1448: AND draft_invoice_num = p_draft_invoice_num;

Line 1452: UPDATE pa_draft_invoices_all

1448: AND draft_invoice_num = p_draft_invoice_num;
1449:
1450: ELSE
1451:
1452: UPDATE pa_draft_invoices_all
1453: SET projfunc_invtrans_rate_type = p_pfc_rate_type
1454: ,projfunc_invtrans_rate_date = DECODE(p_pfc_ex_rate_date_code,'PA_INVOICE_DATE',
1455: tmp_projfunc_rate_date_tab(1),p_pfc_rate_date)
1456: ,projfunc_invtrans_ex_rate = DECODE(p_pfc_ex_rate_date_code,'PA_INVOICE_DATE',

Line 1552: UPDATE pa_draft_invoices_all

1548: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1549: AND dii.invoice_line_type <> 'RETENTION';
1550: Commented for Bug 6084445 End */
1551:
1552: UPDATE pa_draft_invoices_all
1553: SET projfunc_invtrans_rate_type = 'User'
1554: ,projfunc_invtrans_rate_date = NVL(l_invoice_date,p_bill_thru_date)
1555: ,projfunc_invtrans_ex_rate = l_rate
1556: WHERE project_id = p_project_id

Line 1607: UPDATE pa_draft_invoices_all

1603: OPEN reject_reason (tmp_status_tab(1));
1604: FETCH reject_reason INTO l_reject_reason_meaning;
1605: CLOSE reject_reason;
1606:
1607: UPDATE pa_draft_invoices_all
1608: SET generation_error_flag = 'Y',
1609: TRANSFER_REJECTION_REASON = l_reject_reason_meaning
1610: WHERE project_id = p_project_id
1611: AND draft_invoice_num = p_draft_invoice_num;

Line 1615: UPDATE pa_draft_invoices_all

1611: AND draft_invoice_num = p_draft_invoice_num;
1612:
1613: ELSE
1614:
1615: UPDATE pa_draft_invoices_all
1616: SET projfunc_invtrans_rate_type = p_inv_rate_type
1617: ,projfunc_invtrans_rate_date = NVL(p_inv_rate_date,NVL(l_invoice_date,p_bill_thru_date))
1618: ,projfunc_invtrans_ex_rate = NVL(p_inv_ex_rate,tmp_rate_tab(1))
1619: WHERE project_id = p_project_id

Line 1693: FROM pa_draft_invoices_all di,

1689: dii.bill_trans_currency_code,
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

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 1860: from pa_draft_invoices_all da

1856: inv_num_cached := cm_rec.draft_invoice_num;
1857:
1858: select nvl(da.INV_EXCHANGE_RATE, 1), da.INV_CURRENCY_CODE
1859: into l_head_inv_exch_rate, l_head_inv_curr_code
1860: from pa_draft_invoices_all da
1861: where project_id = p_project_id
1862: and draft_invoice_num = inv_num_cached;
1863:
1864: IF g1_debug_mode = 'Y' THEN

Line 1920: FROM pa_draft_invoices_all

1916:
1917: -- Get the last invoice number
1918: BEGIN
1919: SELECT NVL(MAX(draft_invoice_num),0) INTO Last_invoice_num
1920: FROM pa_draft_invoices_all
1921: WHERE project_id = p_project_id;
1922: END;
1923: IF g1_debug_mode = 'Y' THEN
1924: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || 'Max Invoice Number: ' || Last_invoice_num);

Line 2248: INSERT INTO pa_draft_invoices_all

2244: IF g1_debug_mode = 'Y' THEN
2245: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || ' Insert New Invoices ');
2246: END IF;
2247:
2248: INSERT INTO pa_draft_invoices_all
2249: (project_id,
2250: draft_invoice_num,
2251: last_update_date,
2252: last_updated_by,

Line 2409: FROM pa_draft_invoices_all

2405: bill_to_customer_id,
2406: ship_to_customer_id,
2407: bill_to_contact_id,
2408: ship_to_contact_id
2409: FROM pa_draft_invoices_all
2410: WHERE project_id = p_project_id
2411: AND draft_invoice_num = TmpInvHeaders(k).current_draft_invoice_num;
2412:
2413: -- Handling Retention lines

Line 2538: UPDATE pa_draft_invoices_all

2534: IF g1_debug_mode = 'Y' THEN
2535: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || ' Update Existing Invoice ');
2536: END IF;
2537:
2538: UPDATE pa_draft_invoices_all
2539: set inv_currency_code = TmpInvHeaders(k).inv_currency_code,
2540: inv_rate_type = NULL, --'User',
2541: inv_rate_date = NULL, --sysdate,
2542: inv_exchange_rate = NULL, --1,

Line 2597: FROM pa_draft_invoices_all i,

2593: SELECT agr.customer_id,
2594: i.bill_through_date
2595: INTO l_customer_id,
2596: l_bill_thru_date
2597: FROM pa_draft_invoices_all i,
2598: pa_agreements_all agr
2599: WHERE i.project_id = p_project_id
2600: AND i.request_id = p_request_id
2601: AND i.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num