DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_GLOBAL_VAR

Line 3431: CN_GLOBAL_VAR.g_ext_precision);

3427: -- do the rounding first
3428: p_trx_rec_new.commission_amount := Round(Nvl(p_trx_rec_new.commission_amount,0),
3429: g_ext_precision);
3430: p_trx_rec_new.commission_rate := Round( Nvl(p_trx_rec_new.commission_rate,0),
3431: CN_GLOBAL_VAR.g_ext_precision);
3432: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3433: CN_GLOBAL_VAR.g_ext_precision);
3434: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3435: CN_GLOBAL_VAR.g_ext_precision);

Line 3433: CN_GLOBAL_VAR.g_ext_precision);

3429: g_ext_precision);
3430: p_trx_rec_new.commission_rate := Round( Nvl(p_trx_rec_new.commission_rate,0),
3431: CN_GLOBAL_VAR.g_ext_precision);
3432: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3433: CN_GLOBAL_VAR.g_ext_precision);
3434: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3435: CN_GLOBAL_VAR.g_ext_precision);
3436: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3437: CN_GLOBAL_VAR.g_ext_precision);

Line 3435: CN_GLOBAL_VAR.g_ext_precision);

3431: CN_GLOBAL_VAR.g_ext_precision);
3432: p_trx_rec_new.input_achieved := Round( Nvl(p_trx_rec_new.input_achieved,0),
3433: CN_GLOBAL_VAR.g_ext_precision);
3434: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3435: CN_GLOBAL_VAR.g_ext_precision);
3436: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3437: CN_GLOBAL_VAR.g_ext_precision);
3438: p_trx_rec_new.rate_tier_id := Nvl( p_trx_rec_new.rate_tier_id,0);
3439: p_trx_rec_new.tier_split := Nvl( p_trx_rec_new.tier_split, 0) ;

Line 3437: CN_GLOBAL_VAR.g_ext_precision);

3433: CN_GLOBAL_VAR.g_ext_precision);
3434: p_trx_rec_new.output_achieved := Round( Nvl(p_trx_rec_new.output_achieved,0),
3435: CN_GLOBAL_VAR.g_ext_precision);
3436: p_trx_rec_new.perf_achieved := Round( Nvl(p_trx_rec_new.perf_achieved,0),
3437: CN_GLOBAL_VAR.g_ext_precision);
3438: p_trx_rec_new.rate_tier_id := Nvl( p_trx_rec_new.rate_tier_id,0);
3439: p_trx_rec_new.tier_split := Nvl( p_trx_rec_new.tier_split, 0) ;
3440:
3441: IF p_trx_rec_old.status = 'CALC' AND p_trx_rec_old.posting_status = 'POSTED' THEN

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

3549: VALUES
3550: (cn_commission_lines_s.NEXTVAL, p_trx_rec.salesrep_id, l_header_id,
3551: 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,
3552: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3553: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3554: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3555: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3556: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3557: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),

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

3551: 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,
3552: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3553: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3554: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3555: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3556: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3557: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3558: p_trx_rec.posting_status, p_trx_rec.pending_status,
3559: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,

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

3552: Round(Nvl(p_trx_rec.commission_amount,0), g_ext_precision),
3553: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3554: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3555: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3556: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3557: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3558: p_trx_rec.posting_status, p_trx_rec.pending_status,
3559: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,
3560: p_trx_rec.trx_type, p_trx_rec.created_during, p_trx_rec.error_reason,

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

3553: Round(Nvl(p_trx_rec.commission_rate,0), CN_GLOBAL_VAR.g_ext_precision ),
3554: Nvl(p_trx_rec.rate_tier_id, 0), Nvl(p_trx_rec.tier_split, 0),
3555: Round( Nvl(p_trx_rec.input_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3556: Round( Nvl(p_trx_rec.output_achieved, 0), CN_GLOBAL_VAR.g_ext_precision),
3557: Round( Nvl(p_trx_rec.perf_achieved, 0 ), CN_GLOBAL_VAR.g_ext_precision),
3558: p_trx_rec.posting_status, p_trx_rec.pending_status,
3559: p_trx_rec.processed_date, p_trx_rec.processed_period_id,p_trx_rec.pay_period_id,
3560: p_trx_rec.trx_type, p_trx_rec.created_during, p_trx_rec.error_reason,
3561: sysdate, g_last_updated_by, g_creation_date,