DBA Data[Home] [Help]

APPS.PA_MCB_INVOICE_PKG dependencies on PA_BILLING

Line 1066: tmp_funding_rate_date_tab(1) := nvl(tmp_funding_rate_date,TO_DATE(pa_billing.globvars.invoicedate,'YYYY/MM/DD'));

1062: x_funding_currency_code := tmp_funding_currency_code;
1063: tmp_bill_trans_currency_tab(1) := tmp_bill_trans_currency_code;
1064: tmp_funding_currency_tab(1) := tmp_funding_currency_code;
1065: tmp_funding_rate_type_tab(1) := tmp_funding_rate_type;
1066: tmp_funding_rate_date_tab(1) := nvl(tmp_funding_rate_date,TO_DATE(pa_billing.globvars.invoicedate,'YYYY/MM/DD'));
1067: tmp_funding_exchange_rate_tab(1) := tmp_funding_exchange_rate;
1068: tmp_bill_trans_bill_amount_tab(1) := tmp_bill_trans_inv_amount;
1069: tmp_funding_bill_amount_tab(1) := 0;
1070: tmp_status_tab(1) := 'N';

Line 1081: nvl(to_char(tmp_funding_rate_date, 'YYYY/MM/DD'), pa_billing.globvars.invoicedate));

1077: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || 'From Currency Code : ' || tmp_bill_trans_currency_code);
1078: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || ' To Currency Code : ' || tmp_funding_currency_code);
1079: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || ' Ex Rate Type : ' || tmp_funding_rate_type);
1080: PA_MCB_INVOICE_PKG.log_message(' Ex Rate Date : ' ||
1081: nvl(to_char(tmp_funding_rate_date, 'YYYY/MM/DD'), pa_billing.globvars.invoicedate));
1082: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || ' Ex Rate : ' || tmp_funding_exchange_rate);
1083: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || ' From Amount : ' || tmp_bill_trans_inv_amount);
1084: END IF;
1085:

Line 1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;

1306: AND lu.lookup_code = reject_code;
1307:
1308: -- Bug : 4298230 Added the following parameters for the call to PA_MULTI_CURRENCY_BILLING.convert_amount_bulk
1309: l_reject_reason_meaning VARCHAR2(500);
1310: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1311: tmp_pfc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1312: tmp_btc_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1313: tmp_bill_trans_amount_tab PA_PLSQL_DATATYPES.NumTabTyp;
1314: tmp_denominator_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 1759: l_invoice_date DATE := pa_billing.GetInvoiceDate;

1755:
1756: l_sum_projfunc_bill_amount NUMBER:=0;
1757:
1758: --For Bug 4146846 :Added following variables
1759: l_invoice_date DATE := pa_billing.GetInvoiceDate;
1760: l_use_pfc_flag VARCHAR2(1);
1761: l_projfunc_exchange_rate NUMBER;
1762: l_projfunc_exchg_rate_type VARCHAR2(30);
1763: l_projfunc_exchg_rate_date Date;