APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_BATCHES_PKG

Line 1707: l_calc_sub_batch_rec cn_calc_sub_batches_pkg.calc_sub_batch_rec_type;

1703: l_process_all_flag varchar2(30);
1704: l_salesrep_option VARCHAR2(30);
1705: l_current_processed_date date;
1706: l_next_processed_date date;
1707: l_calc_sub_batch_rec cn_calc_sub_batches_pkg.calc_sub_batch_rec_type;
1708: l_srp_subledger cn_calc_subledger_pvt.srp_subledger_rec_type;
1709: l_msg_data varchar2(3000);
1710: l_return_status VARCHAR2(30);
1711: l_msg_count number(15);

Line 1867: cn_calc_sub_batches_pkg.get_calc_sub_batch( p_physical_batch_id, l_calc_sub_batch_rec);

1863: -- populate uplift factors (payment_factor, quota_factor, event_factor) and payee_assigned first
1864: populate_factors(p_physical_batch_id);
1865: commit;
1866:
1867: cn_calc_sub_batches_pkg.get_calc_sub_batch( p_physical_batch_id, l_calc_sub_batch_rec);
1868:
1869: g_intel_calc_flag := l_calc_sub_batch_rec.intelligent_flag;
1870: l_salesrep_option := l_calc_sub_batch_rec.salesrep_option;
1871: g_calc_type := l_calc_sub_batch_rec.calc_type;

Line 3391: l_intel_calc_flag := cn_calc_sub_batches_pkg.get_intel_calc_flag(p_batch_id);

3387: l_intel_calc_flag VARCHAR2(30);
3388: l_calc_type VARCHAR2(30);
3389: BEGIN
3390:
3391: l_intel_calc_flag := cn_calc_sub_batches_pkg.get_intel_calc_flag(p_batch_id);
3392: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_batch_id);
3393:
3394: IF l_calc_type = 'COMMISSION' THEN
3395: IF l_intel_calc_flag = 'Y' THEN

Line 3392: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_batch_id);

3388: l_calc_type VARCHAR2(30);
3389: BEGIN
3390:
3391: l_intel_calc_flag := cn_calc_sub_batches_pkg.get_intel_calc_flag(p_batch_id);
3392: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_batch_id);
3393:
3394: IF l_calc_type = 'COMMISSION' THEN
3395: IF l_intel_calc_flag = 'Y' THEN
3396: revert_batch_intel_comm(p_batch_id);

Line 3716: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_physical_batch_id);

3712: WHERE physical_batch_id = p_physical_batch_id;
3713:
3714: l_calc_type VARCHAR2(30);
3715: BEGIN
3716: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_physical_batch_id);
3717:
3718: IF (l_calc_type = 'BONUS') THEN
3719: RETURN;
3720: END IF;