APPS.CN_CALC_SUBMISSION_PUB dependencies on CN_CALC_SUB_QUOTAS

Line 1319: -- insert into cn_calc_sub_quotas

1315: );
1316: END LOOP;
1317: END IF;
1318:
1319: -- insert into cn_calc_sub_quotas
1320: IF l_p_calc_submission_rec.calculation_type = 'BONUS' THEN
1321: FOR ctr IN 1 .. l_bonus_pe_id_tbl.COUNT LOOP
1322: cn_calc_sub_quotas_pkg.begin_record
1323: ( p_operation => 'INSERT',

Line 1322: cn_calc_sub_quotas_pkg.begin_record

1318:
1319: -- insert into cn_calc_sub_quotas
1320: IF l_p_calc_submission_rec.calculation_type = 'BONUS' THEN
1321: FOR ctr IN 1 .. l_bonus_pe_id_tbl.COUNT LOOP
1322: cn_calc_sub_quotas_pkg.begin_record
1323: ( p_operation => 'INSERT',
1324: p_calc_sub_batch_id => l_calc_sub_batch_id,
1325: p_quota_id => l_bonus_pe_id_tbl(ctr),
1326: p_org_id => g_org_id,

Line 1659: FROM cn_calc_sub_quotas_all

1655: CURSOR l_bonus_pe_exists_csr ( l_calc_sub_batch_id NUMBER,
1656: l_quota_id NUMBER )
1657: IS
1658: SELECT COUNT(*)
1659: FROM cn_calc_sub_quotas_all
1660: WHERE calc_sub_batch_id = l_calc_sub_batch_id
1661: AND quota_id = l_quota_id;
1662:
1663: CURSOR l_salesrep_exists_csr ( l_calc_sub_batch_id NUMBER,

Line 2198: -- ADD/DELETE into cn_calc_sub_quotas

2194: END ;
2195: END IF;
2196: END IF;
2197:
2198: -- ADD/DELETE into cn_calc_sub_quotas
2199: IF l_p_calc_submission_rec.calculation_type = 'BONUS' THEN
2200: IF p_bonus_pe_tbl_action = 'ADD' THEN
2201: FOR ctr IN 1 .. l_bonus_pe_id_tbl.COUNT LOOP
2202: OPEN l_bonus_pe_exists_csr( l_calc_sub_batch_id,

Line 2208: cn_calc_sub_quotas_pkg.begin_record

2204: FETCH l_bonus_pe_exists_csr INTO l_counter;
2205: CLOSE l_bonus_pe_exists_csr;
2206:
2207: IF l_counter = 0 THEN
2208: cn_calc_sub_quotas_pkg.begin_record
2209: ( p_operation => 'INSERT',
2210: p_calc_sub_batch_id => l_calc_sub_batch_id,
2211: p_quota_id => l_bonus_pe_id_tbl(ctr),
2212: p_org_id => g_org_id,

Line 2238: DELETE cn_calc_sub_quotas

2234: END IF;
2235: END LOOP;
2236: ELSIF p_bonus_pe_tbl_action = 'DELETE' THEN
2237: forall j IN 1 .. l_bonus_pe_id_tbl.COUNT
2238: DELETE cn_calc_sub_quotas
2239: WHERE calc_sub_batch_id = l_calc_sub_batch_id
2240: AND quota_id = l_bonus_pe_id_tbl(j);
2241: END IF;
2242: END IF;