[Home] [Help]
249: --
250:
251: SELECT start_date, end_date, payment_group_code
252: INTO l_pp_start_date, l_pp_end_date, l_payment_group_code
253: FROM cn_pmt_plans_all
254: WHERE pmt_plan_id = p_pmt_plan_id;
255: IF ( (
256: ( l_pp_start_date IS NOT NULL) AND ( l_pp_end_date IS NOT NULL)
257: AND(
282: -- Ensure pmt plan assignments do not overlap each other in same role
283: -- only 1 payment plan is active at each date
284: -- Returns an error message and raises an exception if overlap occurs.
285: SELECT COUNT(1) INTO l_dummy
286: FROM cn_srp_pmt_plans_all cspp, cn_pmt_plans_all cpp
287: WHERE (((cspp.end_date IS NULL)
288: AND (p_end_date IS NULL))
289: OR
290: ((cspp.end_date IS NULL) AND
411:
412: CURSOR get_paid_del_payruns IS
413: SELECT 'ERROR' as estatus
414: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
415: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
416: WHERE w.salesrep_id = spp.salesrep_id
417: AND w.quota_id is null
418: AND prun.pay_period_id = prd.period_id
419: AND prun.org_id = prd.org_id
431:
432: CURSOR get_adj_del_payruns IS
433: SELECT 'ERROR' as estatus
434: FROM cn_payment_worksheets_all W, cn_period_statuses_all prd,
435: cn_payruns_all prun, cn_srp_pmt_plans_all spp,cn_pmt_plans_all pp
436: -- cn_payment_transactions pt
437: WHERE w.salesrep_id = spp.salesrep_id
438: AND w.quota_id is null
439: AND prun.pay_period_id = prd.period_id
957: END IF;
958:
959: -- inherit credit type of pmt plan
960: select credit_type_id, name into l_credit_type_id, l_name
961: from cn_pmt_plans_all
962: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
963:
964:
965: cn_srp_pmt_plans_pkg.insert_row
1187: x_loading_status => x_loading_status);
1188:
1189: -- inherit credit type of pmt plan
1190: select credit_type_id into l_credit_type_id
1191: from cn_pmt_plans_all
1192: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1193:
1194: -- if the lock_flag is being set, then blow away role_pmt_plan_id
1195: IF p_pmt_plan_assign_rec.lock_flag = 'Y' THEN
1326: l_notemsg := NULL;
1327:
1328: -- raise notes
1329: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1330: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1331: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1332: SELECT name INTO l_newname FROM cn_pmt_plans_all
1333: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1334: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);
1328: -- raise notes
1329: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1330: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1331: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1332: SELECT name INTO l_newname FROM cn_pmt_plans_all
1333: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1334: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);
1335: END IF;
1336:
1535: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1536:
1537: CURSOR spp_info_cur IS
1538: select p.name, r.name role_name, spp.start_date, spp.end_date, spp.minimum_amount, spp.maximum_amount, spp.lock_flag, spp.salesrep_id
1539: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1540: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1541: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1542: and spp.pmt_plan_id = p.pmt_plan_id
1543: and rpp.role_id = r.role_id(+);
1966: select spp.start_date, spp.end_date, spp.salesrep_id,
1967: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
1968: into l_start_date_old, l_end_date_old, l_salesrep_id_old,
1969: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
1970: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp
1971: where spp.srp_role_id = p_srp_role_id
1972: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
1973: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
1974: AND cpp.pmt_plan_id = spp.pmt_plan_id;