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 1015: AND (pa_multi_currency.is_user_rate_type_allowed(

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

Line 1024: WHERE pa_multi_currency.is_user_rate_type_allowed(

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

Line 1077: AND (pa_multi_currency.is_user_rate_type_allowed(

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

Line 1086: WHERE pa_multi_currency.is_user_rate_type_allowed(

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

Line 1671: PA_MULTI_CURRENCY_BILLING.get_project_defaults (

1667: END IF;
1668:
1669: /* The following logic has been added for MCB2 functionality */
1670: l_project_id := nvl(X_project_id, pa_billing.GlobVars.ProjectId);
1671: PA_MULTI_CURRENCY_BILLING.get_project_defaults (
1672: p_project_id => l_project_id,
1673: x_multi_currency_billing_flag => l_multi_currency_billing_flag,
1674: x_baseline_funding_flag => l_baseline_funding_flag,
1675: x_revproc_currency_code => l_revproc_currency_code,

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

1708: RAISE l_invalid_currency;
1709: END;
1710:
1711: /* Rounding the transaction amount upto the precision of transaction currency for MCB2 */
1712: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
1713: IF g1_debug_mode = 'Y' THEN
1714: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: rev amt'||to_char(XD_bill_trans_rev_amt));
1715: END IF;
1716: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);

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

1712: XD_bill_trans_rev_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_rev_amt, 0),l_txn_currency_code);
1713: IF g1_debug_mode = 'Y' THEN
1714: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: rev amt'||to_char(XD_bill_trans_rev_amt));
1715: END IF;
1716: XD_bill_trans_bill_amt := PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(NVL(X_bill_amt,0),l_txn_currency_code);
1717: IF g1_debug_mode = 'Y' THEN
1718: PA_MCB_INVOICE_PKG.log_message('after pa_billing_pub.insert_event2: inv amt'||to_char(XD_bill_trans_bill_amt));
1719: END IF;
1720: /* The following amounts have been commented for MCB2, the above amounts are satisfying the same requirement */

Line 1854: AND (pa_multi_currency.is_user_rate_type_allowed(

1850: INTO l_found
1851: FROM ( SELECT conversion_type, user_conversion_type
1852: FROM pa_conversion_types_v
1853: WHERE conversion_type <>'User'
1854: AND (pa_multi_currency.is_user_rate_type_allowed(
1855: l_txn_currency_code,
1856: l_projfunc_currency_code,
1857: DECODE(l_projfunc_bil_rate_date_code,
1858: 'PA_INVOICE_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),

Line 1863: WHERE pa_multi_currency.is_user_rate_type_allowed(

1859: 'FIXED_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date)))= 'N')
1860: UNION
1861: SELECT conversion_type, user_conversion_type
1862: FROM pa_conversion_types_v
1863: WHERE pa_multi_currency.is_user_rate_type_allowed(
1864: l_txn_currency_code,
1865: l_projfunc_currency_code,
1866: DECODE(l_projfunc_bil_rate_date_code,
1867: 'PA_INVOICE_DATE',NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),

Line 1916: AND (pa_multi_currency.is_user_rate_type_allowed(

1912: INTO l_found
1913: FROM ( SELECT conversion_type, user_conversion_type
1914: FROM pa_conversion_types_v
1915: WHERE conversion_type <>'User'
1916: AND (pa_multi_currency.is_user_rate_type_allowed(
1917: l_txn_currency_code,
1918: l_project_currency_code,
1919: DECODE(l_project_bil_rate_date_code,
1920: 'PA_INVOICE_DATE', NVL(X_project_rate_date,l_project_bil_rate_date),

Line 1925: WHERE pa_multi_currency.is_user_rate_type_allowed(

1921: 'FIXED_DATE', NVL(X_project_rate_date,l_project_bil_rate_date)))= 'N')
1922: UNION
1923: SELECT conversion_type, user_conversion_type
1924: FROM pa_conversion_types_v
1925: WHERE pa_multi_currency.is_user_rate_type_allowed(
1926: l_txn_currency_code,
1927: l_project_currency_code,
1928: DECODE(l_project_bil_rate_date_code,
1929: 'PA_INVOICE_DATE',NVL(X_project_rate_date,l_project_bil_rate_date),