DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_CURRENCY

Line 3114: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';

3110: -- derive the receipt exchange rate from the ratio of quantity
3111: -- to receipt amount
3112:
3113: IF PG_DEBUG = 'Y' THEN
3114: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3115: log_message('log_message: ' || pa_debug.G_err_Stage);
3116: END IF;
3117: X_receipt_exchange_rate := (X_qty/
3118: pa_currency.round_trans_currency_amt1(

Line 3118: pa_currency.round_trans_currency_amt1(

3114: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3115: log_message('log_message: ' || pa_debug.G_err_Stage);
3116: END IF;
3117: X_receipt_exchange_rate := (X_qty/
3118: pa_currency.round_trans_currency_amt1(
3119: X_receipt_currency_amount,
3120: nvl(X_receipt_currency_code,X_denom_currency_code)));
3121:
3122:

Line 3302: IF ( pa_currency.round_trans_currency_amt1(X_acct_raw_cost, G_accounting_currency_code) <>

3298: log_message('log_message: ' || pa_debug.G_err_Stage);
3299: END IF;
3300:
3301: /* Added the call to round off X_acct_raw_cost for bug 2871273 */
3302: IF ( pa_currency.round_trans_currency_amt1(X_acct_raw_cost, G_accounting_currency_code) <>
3303: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,
3304: X_denom_currency_code )) THEN
3305:
3306: X_status := 'PA_INVALID_ACCT_DENOM_COST';

Line 3303: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,

3299: END IF;
3300:
3301: /* Added the call to round off X_acct_raw_cost for bug 2871273 */
3302: IF ( pa_currency.round_trans_currency_amt1(X_acct_raw_cost, G_accounting_currency_code) <>
3303: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,
3304: X_denom_currency_code )) THEN
3305:
3306: X_status := 'PA_INVALID_ACCT_DENOM_COST';
3307: pa_cc_utils.reset_curr_function;

Line 3737: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';

3733: --
3734:
3735: /* --Commented code for Bug 2798971
3736: IF PG_DEBUG = 'Y' THEN
3737: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3738: log_message('log_message: ' || pa_debug.G_err_Stage);
3739: END IF;
3740: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
3741: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);

Line 3740: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(

3736: IF PG_DEBUG = 'Y' THEN
3737: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3738: log_message('log_message: ' || pa_debug.G_err_Stage);
3739: END IF;
3740: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
3741: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);
3742:
3743: X_acct_burdened_cost := pa_currency.round_currency_amt1(
3744: X_acct_raw_cost * (1 + G_compiled_multiplier));

Line 3743: X_acct_burdened_cost := pa_currency.round_currency_amt1(

3739: END IF;
3740: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
3741: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);
3742:
3743: X_acct_burdened_cost := pa_currency.round_currency_amt1(
3744: X_acct_raw_cost * (1 + G_compiled_multiplier));
3745:
3746: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3747: X_project_raw_cost * (1 + g_compiled_multiplier),

Line 3746: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

3742:
3743: X_acct_burdened_cost := pa_currency.round_currency_amt1(
3744: X_acct_raw_cost * (1 + G_compiled_multiplier));
3745:
3746: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3747: X_project_raw_cost * (1 + g_compiled_multiplier),
3748: X_projfunc_currency_code);
3749:
3750: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

Line 3750: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

3746: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3747: X_project_raw_cost * (1 + g_compiled_multiplier),
3748: X_projfunc_currency_code);
3749:
3750: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3751: X_actual_project_raw_cost * (1 + g_compiled_multiplier),
3752: X_project_currency_code);
3753: --Commented code for Bug 2798971 ends*/
3754:

Line 3951: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';

3947: -- acct_burdened_cost is derived by multiplying the acct_raw_cost with
3948: -- denom_cost_ratio.
3949:
3950: IF PG_DEBUG = 'Y' THEN
3951: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3952: log_message('log_message: ' || pa_debug.G_err_Stage);
3953: END IF;
3954:
3955: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

Line 3955: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

3951: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3952: log_message('log_message: ' || pa_debug.G_err_Stage);
3953: END IF;
3954:
3955: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3956: X_project_raw_cost *
3957: (X_denom_burdened_cost/X_denom_raw_cost),
3958: X_projfunc_currency_code);
3959:

Line 3960: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

3956: X_project_raw_cost *
3957: (X_denom_burdened_cost/X_denom_raw_cost),
3958: X_projfunc_currency_code);
3959:
3960: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(
3961: X_actual_project_raw_cost *
3962: (X_denom_burdened_cost/X_denom_raw_cost),
3963: X_project_currency_code);
3964:

Line 3966: X_acct_burdened_cost := pa_currency.round_currency_amt1(

3962: (X_denom_burdened_cost/X_denom_raw_cost),
3963: X_project_currency_code);
3964:
3965: IF ( nvl( X_acct_burdened_cost ,0 ) = 0 ) THEN
3966: X_acct_burdened_cost := pa_currency.round_currency_amt1(
3967: X_acct_raw_cost * (X_denom_burdened_cost/X_denom_raw_cost));
3968: END IF; -- end acct_burdened_cost = 0
3969: END IF; -- End denom_raw_cost = 0
3970: END IF; -- end G_burdened_flag = N

Line 5848: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080

5844: , denom_burdened_cost
5845: , acct_rate_date
5846: , acct_rate_type
5847: , acct_exchange_rate
5848: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080
5849: , acct_raw_cost
5850: , acct_burdened_cost
5851: , acct_exchange_rounding_limit
5852: , project_currency_code

Line 6007: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080

6003: , denom_burdened_cost
6004: , acct_rate_date
6005: , acct_rate_type
6006: , acct_exchange_rate
6007: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080
6008: , acct_raw_cost
6009: , acct_burdened_cost
6010: , acct_exchange_rounding_limit
6011: , project_currency_code

Line 8310: l_DenomRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomRawCostTab(j),l_DenomCurrCodeTab(j));

8306: pa_debug.G_err_stage := 'rounding transaction raw cost';
8307: log_message('log_message: ' || pa_debug.G_err_stage);
8308: END IF;
8309:
8310: l_DenomRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomRawCostTab(j),l_DenomCurrCodeTab(j));
8311:
8312: /* Added the call to round off denom_burdened_cost for bug 2871273 */
8313:
8314: IF PG_DEBUG = 'Y' THEN

Line 8319: l_DenomBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomBdCostTab(j),l_DenomCurrCodeTab(j));

8315: pa_debug.G_err_stage := 'rounding transaction burden cost';
8316: log_message('log_message: ' || pa_debug.G_err_stage);
8317: END IF;
8318:
8319: l_DenomBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomBdCostTab(j),l_DenomCurrCodeTab(j));
8320:
8321: END IF;
8322:
8323: /* REL12-AP Lines uptake START */

Line 8523: l_AcctRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctRawCostTab(j),G_accounting_currency_code);

8519: /* Added the ELSE section to round off the acct raw and burden costs for gl costed transactions for bug 2871273 */
8520:
8521: ELSE
8522:
8523: l_AcctRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctRawCostTab(j),G_accounting_currency_code);
8524: l_AcctBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctBdCostTab(j),G_accounting_currency_code);
8525:
8526: END IF; -- end G_gl_accted_flag = N
8527:

Line 8524: l_AcctBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctBdCostTab(j),G_accounting_currency_code);

8520:
8521: ELSE
8522:
8523: l_AcctRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctRawCostTab(j),G_accounting_currency_code);
8524: l_AcctBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctBdCostTab(j),G_accounting_currency_code);
8525:
8526: END IF; -- end G_gl_accted_flag = N
8527:
8528: IF (l_DenomCurrCodeTab(j) = G_accounting_currency_code) THEN

Line 13324: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))

13320: ,bcc.Document_Type
13321: ,bcc.Document_Header_Id
13322: ,bcc.Document_Distribution_Id
13323: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13324: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13325: ,0
13326: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13327: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13328: ,0

Line 13327: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))

13323: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13324: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13325: ,0
13326: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13327: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13328: ,0
13329: ,g_Request_Id
13330: ,G_Program_Id
13331: ,G_PROG_APPL_ID

Line 13441: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))

13437: ,bcc.Document_Type
13438: ,bcc.Document_Header_Id
13439: ,bcc.Document_Distribution_Id
13440: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13441: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13442: ,0
13443: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13444: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13445: ,0

Line 13444: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))

13440: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13441: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13442: ,0
13443: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
13444: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
13445: ,0
13446: ,g_Request_Id
13447: ,G_Program_Id
13448: ,G_PROG_APPL_ID

Line 14220: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/

14216: ,bcc.Document_Header_Id
14217: ,bcc.Document_Distribution_Id
14218: ,DECODE(bcc.parent_bc_packet_id,NULL,
14219: (-1 * p_cmt_raw_cost), --rshaik
14220: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/
14221: decode((nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0)),
14222: 0,1,(nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0))))
14223: *p_cmt_raw_cost), G_accounting_currency_code))))
14224: ,0

Line 14227: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/

14223: *p_cmt_raw_cost), G_accounting_currency_code))))
14224: ,0
14225: ,DECODE(bcc.parent_bc_packet_id,NULL,
14226: (-1 * p_cmt_raw_cost)
14227: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/
14228: decode((nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))
14229: ,0,1,(nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))))
14230: *p_cmt_raw_cost), G_accounting_currency_code))))
14231: ,0

Line 14349: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/

14345: ,bcc.Document_Header_Id
14346: ,bcc.Document_Distribution_Id
14347: ,DECODE(bcc.parent_bc_packet_id,NULL,
14348: -1 * p_cmt_raw_cost,
14349: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/
14350: decode((nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0)),
14351: 0,1,(nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i) ,0))))
14352: *p_cmt_raw_cost), G_accounting_currency_code))))
14353: ,0

Line 14356: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/

14352: *p_cmt_raw_cost), G_accounting_currency_code))))
14353: ,0
14354: ,DECODE(bcc.parent_bc_packet_id,NULL,
14355: -1 * p_cmt_raw_cost
14356: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/
14357: decode((nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))
14358: ,0,1,(nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))))
14359: *p_cmt_raw_cost), G_accounting_currency_code))))
14360: ,0