DBA Data[Home] [Help]

APPS.PA_TRX_IMPORT dependencies on PA_CURRENCY

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

3505: -- derive the receipt exchange rate from the ratio of quantity
3506: -- to receipt amount
3507:
3508: IF PG_DEBUG = 'Y' THEN
3509: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3510: log_message('log_message: ' || pa_debug.G_err_Stage);
3511: END IF;
3512: X_receipt_exchange_rate := (X_qty/
3513: pa_currency.round_trans_currency_amt1(

Line 3513: pa_currency.round_trans_currency_amt1(

3509: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
3510: log_message('log_message: ' || pa_debug.G_err_Stage);
3511: END IF;
3512: X_receipt_exchange_rate := (X_qty/
3513: pa_currency.round_trans_currency_amt1(
3514: X_receipt_currency_amount,
3515: nvl(X_receipt_currency_code,X_denom_currency_code)));
3516:
3517:

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

3724:
3725: /* End 10357604 */
3726:
3727: /* Added the call to round off X_acct_raw_cost for bug 2871273 */
3728: IF ( pa_currency.round_trans_currency_amt1(X_acct_raw_cost, G_accounting_currency_code) <>
3729: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,
3730: X_denom_currency_code )) THEN
3731:
3732: X_status := 'PA_INVALID_ACCT_DENOM_COST';

Line 3729: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,

3725: /* End 10357604 */
3726:
3727: /* Added the call to round off X_acct_raw_cost for bug 2871273 */
3728: IF ( pa_currency.round_trans_currency_amt1(X_acct_raw_cost, G_accounting_currency_code) <>
3729: pa_currency.round_trans_currency_amt1(X_denom_raw_cost,
3730: X_denom_currency_code )) THEN
3731:
3732: X_status := 'PA_INVALID_ACCT_DENOM_COST';
3733: pa_cc_utils.reset_curr_function;

Line 3792: X_actual_project_raw_cost := pa_currency.round_trans_currency_amt1(X_actual_project_raw_cost,X_project_currency_code); -- Bug 8621083 / 8595274

3788: P_projfunc_cost_rate_date => X_projfunc_cost_rate_date,
3789: P_projfunc_cost_exch_rate => X_projfunc_cost_exchange_rate,
3790: P_project_raw_cost => X_actual_project_raw_cost);
3791:
3792: X_actual_project_raw_cost := pa_currency.round_trans_currency_amt1(X_actual_project_raw_cost,X_project_currency_code); -- Bug 8621083 / 8595274
3793:
3794: /***************PA-I changes************************
3795: Commenting the exception section as the exceptions are already handled in
3796: the pa_multi_currency_txn pkg.

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

4163: --
4164:
4165: /* --Commented code for Bug 2798971
4166: IF PG_DEBUG = 'Y' THEN
4167: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
4168: log_message('log_message: ' || pa_debug.G_err_Stage);
4169: END IF;
4170: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
4171: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);

Line 4170: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(

4166: IF PG_DEBUG = 'Y' THEN
4167: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
4168: log_message('log_message: ' || pa_debug.G_err_Stage);
4169: END IF;
4170: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
4171: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);
4172:
4173: X_acct_burdened_cost := pa_currency.round_currency_amt1(
4174: X_acct_raw_cost * (1 + G_compiled_multiplier));

Line 4173: X_acct_burdened_cost := pa_currency.round_currency_amt1(

4169: END IF;
4170: X_denom_burdened_cost := pa_currency.round_trans_currency_amt1(
4171: X_denom_raw_cost * (1 + G_compiled_multiplier ),X_denom_currency_code);
4172:
4173: X_acct_burdened_cost := pa_currency.round_currency_amt1(
4174: X_acct_raw_cost * (1 + G_compiled_multiplier));
4175:
4176: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4177: X_project_raw_cost * (1 + g_compiled_multiplier),

Line 4176: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

4172:
4173: X_acct_burdened_cost := pa_currency.round_currency_amt1(
4174: X_acct_raw_cost * (1 + G_compiled_multiplier));
4175:
4176: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4177: X_project_raw_cost * (1 + g_compiled_multiplier),
4178: X_projfunc_currency_code);
4179:
4180: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

Line 4180: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

4176: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4177: X_project_raw_cost * (1 + g_compiled_multiplier),
4178: X_projfunc_currency_code);
4179:
4180: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4181: X_actual_project_raw_cost * (1 + g_compiled_multiplier),
4182: X_project_currency_code);
4183: --Commented code for Bug 2798971 ends*/
4184:

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

4377: -- acct_burdened_cost is derived by multiplying the acct_raw_cost with
4378: -- denom_cost_ratio.
4379:
4380: IF PG_DEBUG = 'Y' THEN
4381: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
4382: log_message('log_message: ' || pa_debug.G_err_Stage);
4383: END IF;
4384:
4385: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

Line 4385: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(

4381: pa_debug.G_err_stage := 'Calling pa_currency.round_trans_currency_amt';
4382: log_message('log_message: ' || pa_debug.G_err_Stage);
4383: END IF;
4384:
4385: X_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4386: X_project_raw_cost *
4387: (X_denom_burdened_cost/X_denom_raw_cost),
4388: X_projfunc_currency_code);
4389:

Line 4390: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(

4386: X_project_raw_cost *
4387: (X_denom_burdened_cost/X_denom_raw_cost),
4388: X_projfunc_currency_code);
4389:
4390: X_actual_project_burdened_cost := pa_currency.round_trans_currency_amt1(
4391: X_actual_project_raw_cost *
4392: (X_denom_burdened_cost/X_denom_raw_cost),
4393: X_project_currency_code);
4394:

Line 4396: X_acct_burdened_cost := pa_currency.round_currency_amt1(

4392: (X_denom_burdened_cost/X_denom_raw_cost),
4393: X_project_currency_code);
4394:
4395: IF ( nvl( X_acct_burdened_cost ,0 ) = 0 ) THEN
4396: X_acct_burdened_cost := pa_currency.round_currency_amt1(
4397: X_acct_raw_cost * (X_denom_burdened_cost/X_denom_raw_cost));
4398: END IF; -- end acct_burdened_cost = 0
4399: END IF; -- End denom_raw_cost = 0
4400: END IF; -- end G_burdened_flag = N

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

6308: , denom_burdened_cost
6309: , trunc(acct_rate_date) acct_rate_date --7535550
6310: , acct_rate_type
6311: , acct_exchange_rate
6312: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080
6313: , acct_raw_cost
6314: , acct_burdened_cost
6315: , acct_exchange_rounding_limit
6316: , project_currency_code

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

6478: , denom_burdened_cost
6479: , trunc(acct_rate_date) acct_rate_date --7535550
6480: , acct_rate_type
6481: , acct_exchange_rate
6482: -- , pa_currency.round_currency_amt1(acct_raw_cost) acct_raw_cost -- Bug 7522080
6483: , acct_raw_cost
6484: , acct_burdened_cost
6485: , acct_exchange_rounding_limit
6486: , project_currency_code

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

9037: pa_debug.G_err_stage := 'rounding transaction raw cost';
9038: log_message('log_message: ' || pa_debug.G_err_stage);
9039: END IF;
9040:
9041: l_DenomRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomRawCostTab(j),l_DenomCurrCodeTab(j));
9042:
9043: /* Added the call to round off denom_burdened_cost for bug 2871273 */
9044:
9045: IF PG_DEBUG = 'Y' THEN

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

9046: pa_debug.G_err_stage := 'rounding transaction burden cost';
9047: log_message('log_message: ' || pa_debug.G_err_stage);
9048: END IF;
9049:
9050: l_DenomBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_DenomBdCostTab(j),l_DenomCurrCodeTab(j));
9051:
9052: END IF;
9053:
9054: /* REL12-AP Lines uptake START */

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

9266: /* Added the ELSE section to round off the acct raw and burden costs for gl costed transactions for bug 2871273 */
9267:
9268: ELSE
9269:
9270: l_AcctRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctRawCostTab(j),G_accounting_currency_code);
9271: l_AcctBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctBdCostTab(j),G_accounting_currency_code);
9272:
9273: END IF; -- end G_gl_accted_flag = N
9274:

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

9267:
9268: ELSE
9269:
9270: l_AcctRawCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctRawCostTab(j),G_accounting_currency_code);
9271: l_AcctBdCostTab(j) := pa_currency.round_trans_currency_amt1(l_AcctBdCostTab(j),G_accounting_currency_code);
9272:
9273: END IF; -- end G_gl_accted_flag = N
9274:
9275: IF (l_DenomCurrCodeTab(j) = G_accounting_currency_code) THEN

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

14274: ,bcc.Document_Type
14275: ,bcc.Document_Header_Id
14276: ,bcc.Document_Distribution_Id
14277: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14278: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14279: ,0
14280: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14281: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14282: ,0

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

14277: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14278: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14279: ,0
14280: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14281: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14282: ,0
14283: ,g_Request_Id
14284: ,G_Program_Id
14285: ,G_PROG_APPL_ID

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

14391: ,bcc.Document_Type
14392: ,bcc.Document_Header_Id
14393: ,bcc.Document_Distribution_Id
14394: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14395: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14396: ,0
14397: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14398: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14399: ,0

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

14394: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14395: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14396: ,0
14397: ,DECODE(bcc.Parent_Bc_Packet_Id,NULL,p_cash_pay_to_relieve
14398: ,pa_currency.round_trans_currency_amt1((p_cash_pay_to_relieve * bcc.compiled_multiplier),G_accounting_currency_code))
14399: ,0
14400: ,g_Request_Id
14401: ,G_Program_Id
14402: ,G_PROG_APPL_ID

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

15194: ,bcc.Document_Header_Id
15195: ,bcc.Document_Distribution_Id
15196: ,DECODE(bcc.parent_bc_packet_id,NULL,
15197: (-1 * p_cmt_raw_cost), --rshaik
15198: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/
15199: decode((nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0)),
15200: 0,1,(nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0))))
15201: *p_cmt_raw_cost), G_accounting_currency_code))))
15202: ,0

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

15201: *p_cmt_raw_cost), G_accounting_currency_code))))
15202: ,0
15203: ,DECODE(bcc.parent_bc_packet_id,NULL,
15204: (-1 * p_cmt_raw_cost)
15205: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/
15206: decode((nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))
15207: ,0,1,(nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))))
15208: *p_cmt_raw_cost), G_accounting_currency_code))))
15209: ,0

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

15325: ,bcc.Document_Header_Id
15326: ,bcc.Document_Distribution_Id
15327: ,DECODE(bcc.parent_bc_packet_id,NULL,
15328: -1 * p_cmt_raw_cost,
15329: (0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Entered_dr,0)-nvl(bcc.Entered_Cr,0))/
15330: decode((nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i),0)),
15331: 0,1,(nvl(g_Entered_Dr_tbl(i),0)-nvl(g_Entered_Cr_tbl(i) ,0))))
15332: *p_cmt_raw_cost), G_accounting_currency_code))))
15333: ,0

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

15332: *p_cmt_raw_cost), G_accounting_currency_code))))
15333: ,0
15334: ,DECODE(bcc.parent_bc_packet_id,NULL,
15335: -1 * p_cmt_raw_cost
15336: ,(0 - (pa_currency.round_trans_currency_amt1((((nvl(bcc.Accounted_dr,0)-nvl(bcc.Accounted_cr,0))/
15337: decode((nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))
15338: ,0,1,(nvl(g_acct_Dr_tbl(i),0)-nvl(g_acct_Cr_tbl(i),0))))
15339: *p_cmt_raw_cost), G_accounting_currency_code))))
15340: ,0