[Home] [Help]
75: l_target cn_srp_quota_rules.target%TYPE;
76: l_payment_amount cn_srp_quota_rules.payment_amount%TYPE;
77: l_performance_goal cn_srp_quota_rules.performance_goal%TYPE;
78:
79: l_srp_quota_assign_id cn_srp_quota_assigns.srp_quota_assign_id%TYPE;
80: l_addup_flag cn_quotas.ADDUP_FROM_REV_CLASS_FLAG%TYPE;
81: BEGIN
82:
83: IF x_quota_rule_id IS NOT NULL AND x_srp_quota_rule_id IS NOT NULL THEN
88: r.performance_goal = x_performance_goal
89: WHERE r.quota_rule_id = x_quota_rule_id
90: AND r.srp_quota_rule_id = x_srp_quota_rule_id
91: AND EXISTS (SELECT 'quota rule belongs to a customized quota'
92: FROM cn_srp_quota_assigns_all q
93: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
94: AND q.customized_flag = 'Y')
95: ;
96:
102: r.payment_amount = x_payment_amount,
103: r.performance_goal = x_performance_goal
104: WHERE r.srp_quota_rule_id = x_srp_quota_rule_id
105: AND EXISTS (SELECT 'quota rule belongs to a customized quota'
106: FROM cn_srp_quota_assigns_all q
107: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
108: AND q.customized_flag = 'Y')
109: ;
110:
115: r.payment_amount = x_payment_amount,
116: r.performance_goal = x_performance_goal
117: WHERE r.quota_rule_id = x_quota_rule_id
118: AND EXISTS (SELECT 'quota rule belongs to a uncustomized quota'
119: FROM cn_srp_quota_assigns_all q
120: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
121: AND q.customized_flag = 'N')
122: ;
123: END IF;
125: IF x_srp_quota_rule_id IS NOT NULL THEN
126:
127: SELECT q.srp_quota_assign_id, q.ADDUP_REV_CLASS_FLAG
128: INTO l_srp_quota_assign_id, l_addup_flag
129: FROM cn_srp_quota_assigns_v q,
130: cn_srp_quota_rules_all r
131: WHERE q.srp_quota_assign_id = r.srp_quota_assign_id
132: AND r.srp_quota_rule_id = x_srp_quota_rule_id
133: ;
142: l_performance_goal
143: FROM cn_srp_quota_rules_all
144: WHERE srp_quota_assign_id = l_srp_quota_assign_id;
145:
146: UPDATE cn_srp_quota_assigns_all
147: SET target = l_target,
148: payment_amount = l_payment_amount,
149: performance_goal = l_performance_goal
150: WHERE srp_quota_assign_id = l_srp_quota_assign_id
207: ,fnd_global.user_id
208: ,Sysdate
209: ,fnd_global.login_id
210: ,sqa.org_id
211: FROM cn_srp_quota_assigns_all sqa
212: ,cn_quota_rules_all qr
213: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
214: AND sqa.quota_id = x_quota_id
215: AND qr.quota_id = sqa.quota_id
248: ,fnd_global.user_id
249: ,Sysdate
250: ,fnd_global.login_id
251: ,sqa.org_id
252: FROM cn_srp_quota_assigns_all sqa
253: ,cn_quota_rules_all qr
254: WHERE sqa.srp_plan_assign_id = x_srp_plan_assign_id
255: AND sqa.quota_id = qr.quota_id
256: AND sqa.quota_type_code IN ('FORMULA','EXTERNAL')
291: ,fnd_global.user_id
292: ,Sysdate
293: ,fnd_global.login_id
294: ,sqa.org_id
295: FROM cn_srp_quota_assigns_all sqa
296: ,cn_quota_rules_all qr
297: WHERE sqa.quota_id = x_quota_id
298: AND qr.quota_id = sqa.quota_id
299: AND qr.quota_rule_id = x_quota_rule_id
333: ,fnd_global.user_id
334: ,Sysdate
335: ,fnd_global.login_id
336: ,sqa.org_id
337: FROM cn_srp_quota_assigns_all sqa
338: ,cn_quota_rules_all qr
339: WHERE sqa.quota_id = x_quota_id
340: AND qr.quota_id = sqa.quota_id
341: AND sqa.quota_type_code IN ('FORMULA', 'EXTERNAL')
394: DELETE FROM cn_srp_quota_rules_all qr
395: WHERE qr.srp_plan_assign_id = x_srp_plan_assign_id
396: AND qr.srp_quota_assign_id IN
397: (SELECT sqa.srp_quota_assign_id
398: FROM cn_srp_quota_assigns sqa
399: WHERE sqa.quota_id = x_quota_id
400: AND sqa.srp_plan_assign_id = x_srp_plan_assign_id)
401: ;
402: