[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
958: END IF;
959:
960: -- inherit credit type of pmt plan
961: select credit_type_id, name into l_credit_type_id, l_name
962: from cn_pmt_plans_all
963: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
964:
965:
966: cn_srp_pmt_plans_pkg.insert_row
1188: x_loading_status => x_loading_status);
1189:
1190: -- inherit credit type of pmt plan
1191: select credit_type_id into l_credit_type_id
1192: from cn_pmt_plans_all
1193: where pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1194:
1195: -- if the lock_flag is being set, then blow away role_pmt_plan_id
1196: IF p_pmt_plan_assign_rec.lock_flag = 'Y' THEN
1327: l_notemsg := NULL;
1328:
1329: -- raise notes
1330: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1331: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1332: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1333: SELECT name INTO l_newname FROM cn_pmt_plans_all
1334: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1335: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);
1329: -- raise notes
1330: IF l_oldrec.pmt_plan_id <> p_pmt_plan_assign_rec.pmt_plan_id THEN
1331: SELECT name INTO l_oldname FROM cn_pmt_plans_all
1332: WHERE pmt_plan_id = l_oldrec.pmt_plan_id;
1333: SELECT name INTO l_newname FROM cn_pmt_plans_all
1334: WHERE pmt_plan_id = p_pmt_plan_assign_rec.pmt_plan_id;
1335: get_note('PMT_PLAN', l_oldname, l_newname, l_notemsg);
1336: END IF;
1337:
1536: l_pmt_plan_assign_rec pmt_plan_assign_rec;
1537:
1538: CURSOR spp_info_cur IS
1539: 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
1540: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all p, cn_role_pmt_plans_all rpp, cn_roles r
1541: where spp.srp_pmt_plan_id = p_srp_pmt_plan_id
1542: and spp.role_pmt_plan_id = rpp.role_pmt_plan_id(+)
1543: and spp.pmt_plan_id = p.pmt_plan_id
1544: and rpp.role_id = r.role_id(+);
1967: select spp.start_date, spp.end_date, spp.salesrep_id,
1968: crpp.start_date, crpp.end_date, spp.srp_pmt_plan_id
1969: into l_start_date_old, l_end_date_old, l_salesrep_id_old,
1970: l_role_pp_start_date, l_role_pp_end_date, l_srp_pmt_plan_id
1971: from cn_srp_pmt_plans_all spp, cn_pmt_plans_all cpp, cn_role_pmt_plans_all crpp
1972: where spp.srp_role_id = p_srp_role_id
1973: AND spp.role_pmt_plan_id = crpp.role_pmt_plan_id --p_role_pmt_plan_id
1974: AND crpp.role_pmt_plan_id = p_role_pmt_plan_id
1975: AND cpp.pmt_plan_id = spp.pmt_plan_id;