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_MCB_INVOICE_PKG dependencies on PA_MULTI_CURRENCY_BILLING

Line 118: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');

114: BEGIN
115:
116: IF g1_debug_mode = 'Y' THEN
117: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk');
118: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
119: END IF;
120:
121:
122: IF g1_debug_mode = 'Y' THEN

Line 151: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');

147: END IF;
148:
149:
150: IF g1_debug_mode = 'Y' THEN
151: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
152: END IF;
153:
154: -- Get the Project Level Defaults
155: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

Line 155: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

151: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Call PA_MULTI_CURRENCY_BILLING.get_project_defaults');
152: END IF;
153:
154: -- Get the Project Level Defaults
155: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
156: p_project_id => p_project_id,
157: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
158: x_baseline_funding_flag => l_baseline_funding_flag,
159: x_revproc_currency_code => l_revproc_currency_code,

Line 287: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

283: IF g1_debug_mode = 'Y' THEN
284: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Convert Bill Transaction To Project functional ' );
285: END IF;
286:
287: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
288: p_from_currency_tab => p_bill_trans_currency_code,
289: p_to_currency_tab => p_projfunc_currency_code,
290: p_conversion_date_tab => tmp_projfunc_rate_date,
291: p_conversion_type_tab => p_projfunc_rate_type,

Line 328: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

324: IF g1_debug_mode = 'Y' THEN
325: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Convert Bill Transaction To Project ' );
326: END IF;
327:
328: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
329: p_from_currency_tab => p_bill_trans_currency_code,
330: p_to_currency_tab => p_project_currency_code,
331: p_conversion_date_tab => tmp_project_rate_date,
332: p_conversion_type_tab => p_project_rate_type,

Line 392: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

388: IF g1_debug_mode = 'Y' THEN
389: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Convert Bill Transaction To Funding Write-ON ' );
390: END IF;
391:
392: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
393: p_from_currency_tab => p_bill_trans_currency_code,
394: p_to_currency_tab => tmp_funding_currency_code,
395: p_conversion_date_tab => tmp_funding_rate_date,
396: p_conversion_type_tab => p_funding_rate_type,

Line 450: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

446: IF g1_debug_mode = 'Y' THEN
447: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Convert Bill Transaction To Funding -Invproc ' );
448: END IF;
449:
450: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
451: p_from_currency_tab => p_bill_trans_currency_code,
452: p_to_currency_tab => tmp_invproc_currency_code,
453: p_conversion_date_tab => tmp_invproc_rate_date,
454: p_conversion_type_tab => tmp_invproc_rate_type,

Line 481: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

477: IF g1_debug_mode = 'Y' THEN
478: PA_MCB_INVOICE_PKG.log_message('Event_Convert_amount_bulk: ' || 'Convert Bill Transaction To Funding ' );
479: END IF;
480:
481: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
482: p_from_currency_tab => p_bill_trans_currency_code,
483: p_to_currency_tab => tmp_invproc_currency_code,
484: p_conversion_date_tab => tmp_invproc_rate_date,
485: p_conversion_type_tab => tmp_invproc_rate_type,

Line 894: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(

890: sign(nvl(p_invproc_bill_amount, 1)) * sign(nvl(tmp_bill_trans_event_amount,1));
891:
892: ELSE
893: /* end of the bug fix 3548844 */
894: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(
895: NVL(p_invproc_bill_amount,0) *
896: (1/ NVL(tmp_projfunc_inv_exch_rate,0))
897: , tmp_bill_trans_currency_code);
898:

Line 919: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(

915: sign(nvl(p_invproc_bill_amount,1)) * sign(nvl(tmp_bill_trans_event_amount,1));
916:
917: ELSE
918: /* end of the bug fix 3548844 */
919: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(
920: NVL(p_invproc_bill_amount,0) *
921: (1/ NVL(tmp_project_inv_exch_rate,0))
922: , tmp_bill_trans_currency_code);
923:

Line 943: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(

939: sign(nvl(p_invproc_bill_amount,1)) * sign(nvl(tmp_bill_trans_event_amount,1));
940:
941: ELSE
942: /* end of the bug fix 3548844 */
943: tmp_bill_trans_inv_amount := pa_multi_currency_billing.round_trans_currency_amt(
944: tmp_bill_trans_event_amount
945: * (NVL(p_invproc_bill_amount,0) /
946: NVL(tmp_invproc_event_amount,0) ) , tmp_bill_trans_currency_code);
947: END IF; --- Added for bug 3548844

Line 978: x_projfunc_bill_amount := TO_CHAR ( pa_multi_currency_billing.round_trans_currency_amt(

974: IF g1_debug_mode = 'Y' THEN
975: PA_MCB_INVOICE_PKG.log_message('Convert_Line_Event_Amount: ' || 'tmp_projfunc_currency_code <> tmp_bill_trans_currency_code');
976: END IF;
977:
978: x_projfunc_bill_amount := TO_CHAR ( pa_multi_currency_billing.round_trans_currency_amt(
979: NVL(tmp_projfunc_event_amount,0) *
980: (NVL(tmp_bill_trans_inv_amount,0)/
981: NVL(tmp_bill_trans_event_amount,0)), tmp_projfunc_currency_code));
982: end if;/* Added for bug 2784321 */

Line 1004: x_project_bill_amount := TO_CHAR ( pa_multi_currency_billing.round_trans_currency_amt(

1000: x_project_bill_amount := x_projfunc_bill_amount ;
1001:
1002: else
1003:
1004: x_project_bill_amount := TO_CHAR ( pa_multi_currency_billing.round_trans_currency_amt(
1005: NVL(tmp_project_event_amount,0) *
1006: (NVL(tmp_bill_trans_inv_amount,0)/
1007: NVL(tmp_bill_trans_event_amount,0)), tmp_project_currency_code));
1008:

Line 1086: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

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:
1086: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
1087: p_from_currency_tab => tmp_bill_trans_currency_tab,
1088: p_to_currency_tab => tmp_funding_currency_tab,
1089: p_conversion_date_tab => tmp_funding_rate_date_tab,
1090: p_conversion_type_tab => tmp_funding_rate_type_tab,

Line 1213: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

1209: tmp_denominator_tab(1) :=0;
1210: tmp_numerator_tab(1) :=0;
1211: tmp_user_validate_flag_tab(1) :='N';
1212:
1213: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
1214: p_from_currency_tab => tmp_bill_trans_currency_tab,
1215: p_to_currency_tab => tmp_funding_currency_tab,
1216: p_conversion_date_tab => tmp_funding_rate_date_tab,
1217: p_conversion_type_tab => tmp_funding_rate_type_tab,

Line 1308: -- Bug : 4298230 Added the following parameters for the call to PA_MULTI_CURRENCY_BILLING.convert_amount_bulk

1304: FROM pa_lookups lu
1305: WHERE lu.lookup_type = 'INVOICE DISTRIBUTION WARNING'
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;

Line 1421: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

1417: tmp_projfunc_rate_type_tab(1) := p_pfc_rate_type; -- bug 4298230
1418: tmp_projfunc_rate_date_tab(1) := l_invoice_date; --Bug 4298230
1419:
1420:
1421: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
1422: p_from_currency_tab => tmp_pfc_currency_code_tab ,
1423: p_to_currency_tab => tmp_btc_currency_code_tab,
1424: p_conversion_date_tab => tmp_projfunc_rate_date_tab,
1425: p_conversion_type_tab => tmp_projfunc_rate_type_tab,

Line 1572: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (

1568: --Converting the PFC to BTC as per Rate Types and DAtes defined in Ct. Screen
1569: tmp_rate_tab(1) := p_inv_ex_rate; --Bug 4298230
1570: tmp_bill_trans_rate_type_tab(1) := p_inv_rate_type; --Bug 4298230
1571:
1572: PA_MULTI_CURRENCY_BILLING.convert_amount_bulk (
1573: p_from_currency_tab => tmp_pfc_currency_code_tab ,
1574: p_to_currency_tab => tmp_btc_currency_code_tab,
1575: p_conversion_date_tab => tmp_bill_trans_rate_date_tab,
1576: p_conversion_type_tab => tmp_bill_trans_rate_type_tab,

Line 1893: PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(l_calc_inv_amount, l_head_inv_curr_code)

1889: /* Bug 4995695.. modified the query for compatibility with 8i */
1890:
1891: UPDATE pa_draft_invoice_items dii
1892: SET dii.inv_amount =
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';