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 1544: UPDATE pa_draft_invoices_all

1540: AND dii.invoice_line_type <> 'NET ZERO ADJUSTMENT'
1541: AND dii.invoice_line_type <> 'RETENTION';
1542: Commented for Bug 6084445 End */
1543:
1544: UPDATE pa_draft_invoices_all
1545: SET projfunc_invtrans_rate_type = 'User'
1546: ,projfunc_invtrans_rate_date = NVL(l_invoice_date,p_bill_thru_date)
1547: ,projfunc_invtrans_ex_rate = l_rate
1548: WHERE project_id = p_project_id

Line 1599: UPDATE pa_draft_invoices_all

1595: OPEN reject_reason (tmp_status_tab(1));
1596: FETCH reject_reason INTO l_reject_reason_meaning;
1597: CLOSE reject_reason;
1598:
1599: UPDATE pa_draft_invoices_all
1600: SET generation_error_flag = 'Y',
1601: TRANSFER_REJECTION_REASON = l_reject_reason_meaning
1602: WHERE project_id = p_project_id
1603: AND draft_invoice_num = p_draft_invoice_num;

Line 1607: UPDATE pa_draft_invoices_all

1603: AND draft_invoice_num = p_draft_invoice_num;
1604:
1605: ELSE
1606:
1607: UPDATE pa_draft_invoices_all
1608: SET projfunc_invtrans_rate_type = p_inv_rate_type
1609: ,projfunc_invtrans_rate_date = NVL(p_inv_rate_date,NVL(l_invoice_date,p_bill_thru_date))
1610: ,projfunc_invtrans_ex_rate = NVL(p_inv_ex_rate,tmp_rate_tab(1))
1611: WHERE project_id = p_project_id

Line 1685: FROM pa_draft_invoices_all di,

1681: dii.bill_trans_currency_code,
1682: dii.invoice_line_type,
1683: NVL(dii.event_num,0) event_num,
1684: NVL(evt.revenue_amount,0) revenue_amount
1685: FROM pa_draft_invoices_all di,
1686: pa_draft_invoice_items dii,
1687: pa_events evt
1688: WHERE di.project_id = p_project_id
1689: AND di.project_id = dii.project_id

Line 1708: FROM pa_draft_invoices_all di, pa_draft_invoice_items dii

1704: CURSOR cur_cm IS
1705: SELECT di.draft_invoice_num,
1706: di.draft_invoice_num_credited,
1707: dii.line_num
1708: FROM pa_draft_invoices_all di, pa_draft_invoice_items dii
1709: WHERE di.project_id = p_project_id
1710: AND di.request_id = p_request_id
1711: AND dii.project_id= di.project_id
1712: AND dii.draft_invoice_num = di.draft_invoice_num

Line 1852: from pa_draft_invoices_all da

1848: inv_num_cached := cm_rec.draft_invoice_num;
1849:
1850: select nvl(da.INV_EXCHANGE_RATE, 1), da.INV_CURRENCY_CODE
1851: into l_head_inv_exch_rate, l_head_inv_curr_code
1852: from pa_draft_invoices_all da
1853: where project_id = p_project_id
1854: and draft_invoice_num = inv_num_cached;
1855:
1856: IF g1_debug_mode = 'Y' THEN

Line 1912: FROM pa_draft_invoices_all

1908:
1909: -- Get the last invoice number
1910: BEGIN
1911: SELECT NVL(MAX(draft_invoice_num),0) INTO Last_invoice_num
1912: FROM pa_draft_invoices_all
1913: WHERE project_id = p_project_id;
1914: END;
1915: IF g1_debug_mode = 'Y' THEN
1916: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || 'Max Invoice Number: ' || Last_invoice_num);

Line 2233: INSERT INTO pa_draft_invoices_all

2229: IF g1_debug_mode = 'Y' THEN
2230: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || ' Insert New Invoices ');
2231: END IF;
2232:
2233: INSERT INTO pa_draft_invoices_all
2234: (project_id,
2235: draft_invoice_num,
2236: last_update_date,
2237: last_updated_by,

Line 2394: FROM pa_draft_invoices_all

2390: bill_to_customer_id,
2391: ship_to_customer_id,
2392: bill_to_contact_id,
2393: ship_to_contact_id
2394: FROM pa_draft_invoices_all
2395: WHERE project_id = p_project_id
2396: AND draft_invoice_num = TmpInvHeaders(k).current_draft_invoice_num;
2397:
2398: -- Handling Retention lines

Line 2523: UPDATE pa_draft_invoices_all

2519: IF g1_debug_mode = 'Y' THEN
2520: PA_MCB_INVOICE_PKG.log_message('Inv_by_Bill_Trans_Currency: ' || ' Update Existing Invoice ');
2521: END IF;
2522:
2523: UPDATE pa_draft_invoices_all
2524: set inv_currency_code = TmpInvHeaders(k).inv_currency_code,
2525: inv_rate_type = NULL, --'User',
2526: inv_rate_date = NULL, --sysdate,
2527: inv_exchange_rate = NULL, --1,

Line 2582: FROM pa_draft_invoices_all i,

2578: SELECT agr.customer_id,
2579: i.bill_through_date
2580: INTO l_customer_id,
2581: l_bill_thru_date
2582: FROM pa_draft_invoices_all i,
2583: pa_agreements_all agr
2584: WHERE i.project_id = p_project_id
2585: AND i.request_id = p_request_id
2586: AND i.draft_invoice_num = TmpInvHeaders(k).new_draft_invoice_num