DBA Data[Home] [Help]

APPS.PA_BILLING_PUB dependencies on PA_MULTI_CURRENCY

Line 832: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

828: END IF;
829:
830: /* The following logic has been added for MCB2 functionality */
831: l_project_id := nvl(X_project_id, pa_billing.GlobVars.ProjectId);
832: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
833: p_project_id => l_project_id,
834: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
835: x_baseline_funding_flag => l_baseline_funding_flag,
836: x_revproc_currency_code => l_revproc_currency_code,

Line 873: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);

869: RAISE l_invalid_currency;
870: END;
871:
872: /* Rounding the transaction amount upto the precision of transaction currency for MCB2 */
873: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
874: IF g1_debug_mode = 'Y' THEN
875: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));
876: END IF;
877: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);

Line 877: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);

873: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
874: IF g1_debug_mode = 'Y' THEN
875: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: rev amt'||to_char(XD_bill_trans_rev_amt));
876: END IF;
877: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
878: IF g1_debug_mode = 'Y' THEN
879: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event: inv amt'||to_char(XD_bill_trans_bill_amt));
880: END IF;
881: /* The following amounts have been commented for MCB2, the above amounts are satisfying the same requirement */

Line 1014: AND (pa_multi_currency.is_user_rate_type_allowed(

1010: INTO l_found
1011: FROM ( SELECT conversion_type, user_conversion_type
1012: FROM pa_conversion_types_v
1013: WHERE conversion_type <>'User'
1014: AND (pa_multi_currency.is_user_rate_type_allowed(
1015: l_txn_currency_code,
1016: l_projfunc_currency_code,
1017: DECODE(l_projfunc_bil_rate_date_code,
1018: 'PA_INVOICE_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),

Line 1023: WHERE pa_multi_currency.is_user_rate_type_allowed(

1019: 'FIXED_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date)))= 'N')
1020: UNION
1021: SELECT conversion_type, user_conversion_type
1022: FROM pa_conversion_types_v
1023: WHERE pa_multi_currency.is_user_rate_type_allowed(
1024: l_txn_currency_code,
1025: l_projfunc_currency_code,
1026: DECODE(l_projfunc_bil_rate_date_code,
1027: 'PA_INVOICE_DATE',NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),

Line 1076: AND (pa_multi_currency.is_user_rate_type_allowed(

1072: INTO l_found
1073: FROM ( SELECT conversion_type, user_conversion_type
1074: FROM pa_conversion_types_v
1075: WHERE conversion_type <>'User'
1076: AND (pa_multi_currency.is_user_rate_type_allowed(
1077: l_txn_currency_code,
1078: l_project_currency_code,
1079: DECODE(l_project_bil_rate_date_code,
1080: 'PA_INVOICE_DATE', NVL(X_project_rate_date,l_project_bil_rate_date),

Line 1085: WHERE pa_multi_currency.is_user_rate_type_allowed(

1081: 'FIXED_DATE', NVL(X_project_rate_date,l_project_bil_rate_date)))= 'N')
1082: UNION
1083: SELECT conversion_type, user_conversion_type
1084: FROM pa_conversion_types_v
1085: WHERE pa_multi_currency.is_user_rate_type_allowed(
1086: l_txn_currency_code,
1087: l_project_currency_code,
1088: DECODE(l_project_bil_rate_date_code,
1089: 'PA_INVOICE_DATE',NVL(X_project_rate_date,l_project_bil_rate_date),