APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CALC_SUB_BATCHES_PKG

Line 1708: l_calc_sub_batch_rec cn_calc_sub_batches_pkg.calc_sub_batch_rec_type;

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

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

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

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

3403: l_intel_calc_flag VARCHAR2(30);
3404: l_calc_type VARCHAR2(30);
3405: BEGIN
3406:
3407: l_intel_calc_flag := cn_calc_sub_batches_pkg.get_intel_calc_flag(p_batch_id);
3408: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_batch_id);
3409:
3410: IF l_calc_type = 'COMMISSION' THEN
3411: IF l_intel_calc_flag = 'Y' THEN

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

3404: l_calc_type VARCHAR2(30);
3405: BEGIN
3406:
3407: l_intel_calc_flag := cn_calc_sub_batches_pkg.get_intel_calc_flag(p_batch_id);
3408: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_batch_id);
3409:
3410: IF l_calc_type = 'COMMISSION' THEN
3411: IF l_intel_calc_flag = 'Y' THEN
3412: revert_batch_intel_comm(p_batch_id);

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

3741: WHERE physical_batch_id = p_physical_batch_id;
3742:
3743: l_calc_type VARCHAR2(30);
3744: BEGIN
3745: l_calc_type := cn_calc_sub_batches_pkg.get_calc_type(p_physical_batch_id);
3746:
3747: IF (l_calc_type = 'BONUS') THEN
3748: RETURN;
3749: END IF;