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.CN_FORMULA_COMMON_PKG dependencies on CN_GLOBAL_VAR

Line 3448: CN_GLOBAL_VAR.g_ext_precision);

3444: -- do the rounding first
3445: p_trx_rec_new.commission_amount := Round(Nvl(p_trx_rec_new.commission_amount,0),
3446: g_ext_precision);
3447: p_trx_rec_new.commission_rate := Round( Nvl(p_trx_rec_new.commission_rate,0),
3448: CN_GLOBAL_VAR.g_ext_precision);
3449: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3450: CN_GLOBAL_VAR.g_ext_precision);
3451: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3452: CN_GLOBAL_VAR.g_ext_precision);

Line 3450: CN_GLOBAL_VAR.g_ext_precision);

3446: g_ext_precision);
3447: p_trx_rec_new.commission_rate := Round( Nvl(p_trx_rec_new.commission_rate,0),
3448: CN_GLOBAL_VAR.g_ext_precision);
3449: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3450: CN_GLOBAL_VAR.g_ext_precision);
3451: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3452: CN_GLOBAL_VAR.g_ext_precision);
3453: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3454: CN_GLOBAL_VAR.g_ext_precision);

Line 3452: CN_GLOBAL_VAR.g_ext_precision);

3448: CN_GLOBAL_VAR.g_ext_precision);
3449: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3450: CN_GLOBAL_VAR.g_ext_precision);
3451: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3452: CN_GLOBAL_VAR.g_ext_precision);
3453: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3454: CN_GLOBAL_VAR.g_ext_precision);
3455: p_trx_rec_new.rate_tier_id := Nvl( p_trx_rec_new.rate_tier_id,0);
3456: p_trx_rec_new.tier_split := Nvl( p_trx_rec_new.tier_split, 0) ;

Line 3454: CN_GLOBAL_VAR.g_ext_precision);

3450: CN_GLOBAL_VAR.g_ext_precision);
3451: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3452: CN_GLOBAL_VAR.g_ext_precision);
3453: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3454: CN_GLOBAL_VAR.g_ext_precision);
3455: p_trx_rec_new.rate_tier_id := Nvl( p_trx_rec_new.rate_tier_id,0);
3456: p_trx_rec_new.tier_split := Nvl( p_trx_rec_new.tier_split, 0) ;
3457: IF p_trx_rec_old.commission_amount <> p_trx_rec_new.commission_amount
3458: OR p_trx_rec_old.commission_rate <> p_trx_rec_new.commission_rate

Line 3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),

3578: VALUES
3579: (cn_commission_lines_s.NEXTVAL, p_trx_rec.salesrep_id, l_header_id,
3580: p_trx_rec.quota_id, p_trx_rec.credit_type_id, p_trx_rec.srp_plan_assign_id, l_role_id, p_trx_rec.status,
3581: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3583: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3584: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3585: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3586: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),

Line 3584: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),

3580: p_trx_rec.quota_id, p_trx_rec.credit_type_id, p_trx_rec.srp_plan_assign_id, l_role_id, p_trx_rec.status,
3581: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3583: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3584: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3585: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3586: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3587: p_trx_rec.posting_status, p_trx_rec.pending_status,
3588: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,

Line 3585: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),

3581: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3583: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3584: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3585: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3586: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3587: p_trx_rec.posting_status, p_trx_rec.pending_status,
3588: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,
3589: p_trx_rec.trx_type, p_trx_rec.created_during, p_trx_rec.error_reason,

Line 3586: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),

3582: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3583: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3584: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3585: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3586: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3587: p_trx_rec.posting_status, p_trx_rec.pending_status,
3588: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,
3589: p_trx_rec.trx_type, p_trx_rec.created_during, p_trx_rec.error_reason,
3590: sysdate, g_last_updated_by, g_creation_date,