[Home] [Help]
384:
385: -- o Called once for each new srp plan assignment. x_srp_plan_assign_id
386: -- o Called one insert of new quota assignment x_srp_plan_assign_id,
387: -- quota_id
388: -- o calling Place 1.cn_srp_quota_assigns_pkg.insert record
389: ---------------------------------------------------------------------------+
390: -- PROCEDURE INSERT_RECORD
391: -- Description:
392: -- CASE 1: Quota period has changed like end date changed from NOT NULL to
413: -- Get the itd_flag for each quota
414:
415: CURSOR ytd_flag IS
416: SELECT q.quota_id quota_id, q.org_id
417: FROM cn_srp_quota_assigns_all qa
418: ,cn_quotas_all q
419: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
420: -- do not need itd and formula id anymore, bug 2462767,AND q.calc_formula_id = cf.calc_formula_id(+)
421: AND qa.quota_id = q.quota_id;
478: l_login_id := fnd_global.login_id;
479:
480: IF x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NULL THEN
481: -- A new plan is assigned to a salesrep
482: -- case 1: callled from cn_srp_quota_assigns_pkg
483:
484: FOR itd_p_rec IN ytd_flag LOOP
485:
486: -- enhancement, clku, 2431086,we do not check if the PE is ITD or not.
525: ,sysdate
526: ,l_user_id
527: ,l_login_id
528: ,qa.org_id
529: FROM cn_srp_quota_assigns_all qa
530: ,cn_period_quotas_all pq
531: ,cn_srp_plan_assigns_all pa
532: ,cn_period_statuses p
533: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
592: ELSIF (x_srp_plan_assign_id IS NOT NULL AND x_quota_id IS NOT NULL) THEN
593:
594: -- A new quota has been assigned to a compensation plan
595: -- Check whether itd_flag for this quota is checked
596: -- case 1: called from cn_srp_quota_assigns_pkg.
597:
598: -- enhancement, clku, 2431086, we do not check if the PE is ITD or not.
599: --IF x_itd_flag_checked = 'Y' THEN
600:
637: ,sysdate
638: ,l_user_id
639: ,l_login_id
640: ,qa.org_id
641: FROM cn_srp_quota_assigns_all qa
642: ,cn_period_quotas_all pq
643: ,cn_srp_plan_assigns_all pa
644: ,cn_period_statuses p
645: WHERE qa.srp_plan_assign_id = x_srp_plan_assign_id
728: ,sysdate
729: ,l_user_id
730: ,l_login_id
731: ,qa.org_id
732: FROM cn_srp_quota_assigns_all qa
733: ,cn_quotas_all q
734: ,cn_srp_plan_assigns_all pa
735: ,cn_acc_period_statuses_v p
736: -- bug fix 4042235
1119: -- Delete will be called from cn_srp_plan_assigns if start_date
1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1121: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1122: --
1123: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1124: -- cn_srp_quota_assigns make a call here
1125: -- srp_plan_assign_id and/or quota_id
1126: ---------------------------------------------------------------------------+
1127: PROCEDURE Delete_Record
1120: -- <> old_start_dt called from cn_srp_plan_assigns_pkg
1121: -- Values Passed : x_srp_plan_assign_id, x_start_date, x_end_date
1122: --
1123: -- Case 4 Delete srp_plan_assigns Called cn_srp_quota_assigns and
1124: -- cn_srp_quota_assigns make a call here
1125: -- srp_plan_assign_id and/or quota_id
1126: ---------------------------------------------------------------------------+
1127: PROCEDURE Delete_Record
1128: ( x_srp_plan_assign_id NUMBER
1177: and cq.calc_formula_id = ccf.calc_formula_id;
1178: l_number_dim NUMBER;
1179:
1180: CURSOR get_quotas IS
1181: SELECT quota_id FROM cn_srp_quota_assigns_all
1182: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
1183:
1184: l_last_period_id number := -1;
1185: l_last_salesrep_id number := -1;
1597:
1598: -- get precision
1599: select c.extended_precision INTO g_ext_precision
1600: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,
1601: cn_srp_quota_assigns sqa
1602: where r.org_id = sqa.org_id
1603: and r.set_of_books_id = b.set_of_books_id
1604: and b.currency_code = c.currency_code
1605: AND sqa.srp_quota_assign_id = x_srp_quota_assign_id;
1616: ,l_quota_payment
1617: ,l_performance_goal
1618: ,l_dist_rule_code
1619: ,l_period_type_code
1620: FROM cn_srp_quota_assigns_all qa,
1621: cn_quotas_all q
1622: WHERE qa.srp_quota_assign_id = x_srp_quota_assign_id
1623: AND q.quota_id = qa.quota_id
1624: AND qa.period_target_dist_rule_code <> 'USER_DEFINED'