eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PER_QUOTA_RC_PKG dependencies on CN_SRP_PER_QUOTA_RC_ALL

Line 49: DELETE FROM cn_srp_per_quota_rc_all

45:
46: IF x_srp_plan_assign_id IS NOT NULL THEN
47: IF x_quota_id IS NOT NULL THEN
48: -- deleting a plan's quota assignment or quota rule
49: DELETE FROM cn_srp_per_quota_rc_all
50: WHERE quota_id = x_quota_id
51: AND srp_plan_assign_id = x_srp_plan_assign_id
52: ;
53: ELSE

Line 56: DELETE FROM cn_srp_per_quota_rc_all

52: ;
53: ELSE
54: IF x_start_date IS NULL THEN
55: -- deleting an entire srp_plan_assign or changing the date range
56: DELETE FROM cn_srp_per_quota_rc_all
57: WHERE srp_plan_assign_id = x_srp_plan_assign_id
58: ;
59: ELSE
60: -- Delete the specific periods

Line 61: DELETE FROM cn_srp_per_quota_rc_all

57: WHERE srp_plan_assign_id = x_srp_plan_assign_id
58: ;
59: ELSE
60: -- Delete the specific periods
61: DELETE FROM cn_srp_per_quota_rc_all
62: WHERE srp_plan_assign_id = x_srp_plan_assign_id
63: AND EXISTS ( select 1 from cn_period_statuses p
64: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
65: AND p.end_date <= Nvl(x_end_date ,p.end_date)

Line 66: AND cn_srp_per_quota_rc_all.org_id = p.org_id

62: WHERE srp_plan_assign_id = x_srp_plan_assign_id
63: AND EXISTS ( select 1 from cn_period_statuses p
64: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
65: AND p.end_date <= Nvl(x_end_date ,p.end_date)
66: AND cn_srp_per_quota_rc_all.org_id = p.org_id
67: AND cn_srp_per_quota_rc_all.period_id = p.period_id
68: AND ( ( p.start_date <> p.end_date)
69: OR (p.start_date = p.end_date AND p.start_date > TRUNC(x_start_date)) ) -- Fix for bug 13583329
70: );

Line 67: AND cn_srp_per_quota_rc_all.period_id = p.period_id

63: AND EXISTS ( select 1 from cn_period_statuses p
64: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
65: AND p.end_date <= Nvl(x_end_date ,p.end_date)
66: AND cn_srp_per_quota_rc_all.org_id = p.org_id
67: AND cn_srp_per_quota_rc_all.period_id = p.period_id
68: AND ( ( p.start_date <> p.end_date)
69: OR (p.start_date = p.end_date AND p.start_date > TRUNC(x_start_date)) ) -- Fix for bug 13583329
70: );
71: END IF; -- start_date is null

Line 83: DELETE FROM cn_srp_per_quota_rc_all

79: -- Deleting a quota rule
80: -- OR the quota type changed to one that doesn not support
81: -- revenue classes
82:
83: DELETE FROM cn_srp_per_quota_rc_all
84: WHERE quota_id = x_quota_id
85: AND revenue_class_id = x_revenue_class_id;
86:
87: ELSE

Line 96: DELETE FROM cn_srp_per_quota_rc_all

92:
93: -- Modified from cn_periods to cn_period_statuses
94: -- Modified the the start_period_id, end_period_id to
95: -- start date and end date
96: DELETE FROM cn_srp_per_quota_rc_all
97: WHERE quota_id = x_quota_id
98: AND EXISTS ( select 1 from cn_period_statuses p
99: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
100: AND p.end_date <= Nvl(x_end_date ,p.end_date)

Line 101: AND cn_srp_per_quota_rc_all.period_id = p.period_id

97: WHERE quota_id = x_quota_id
98: AND EXISTS ( select 1 from cn_period_statuses p
99: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
100: AND p.end_date <= Nvl(x_end_date ,p.end_date)
101: AND cn_srp_per_quota_rc_all.period_id = p.period_id
102: AND cn_srp_per_quota_rc_all.org_id = p.org_id
103: AND ( ( p.start_date <> p.end_date)
104: OR (p.start_date = p.end_date AND p.start_date > TRUNC(x_start_date)) ) -- Fix for bug 13583329
105: );

Line 102: AND cn_srp_per_quota_rc_all.org_id = p.org_id

98: AND EXISTS ( select 1 from cn_period_statuses p
99: WHERE p.start_date >= Nvl(x_start_date,p.start_date)
100: AND p.end_date <= Nvl(x_end_date ,p.end_date)
101: AND cn_srp_per_quota_rc_all.period_id = p.period_id
102: AND cn_srp_per_quota_rc_all.org_id = p.org_id
103: AND ( ( p.start_date <> p.end_date)
104: OR (p.start_date = p.end_date AND p.start_date > TRUNC(x_start_date)) ) -- Fix for bug 13583329
105: );
106:

Line 171: INSERT INTO cn_srp_per_quota_rc_all

167: -- Note the new revenue_class in the select statement.
168:
169: -- clku, fixed for performance bug 2321076
170:
171: INSERT INTO cn_srp_per_quota_rc_all
172: ( srp_per_quota_rc_id
173: ,srp_period_quota_id
174: ,srp_plan_assign_id
175: ,salesrep_id

Line 214: FROM cn_srp_per_quota_rc_all spqr

210: AND q.quota_id = pq.quota_id
211: AND q.quota_type_code IN ('FORMULA','EXTERNAL')
212:
213: AND NOT EXISTS (SELECT 'srp_period_quota_rc already exists'
214: FROM cn_srp_per_quota_rc_all spqr
215: WHERE spqr.srp_period_quota_id = pq.srp_period_quota_id
216: AND spqr.srp_plan_assign_id = pq.srp_plan_assign_id
217: AND spqr.revenue_class_id = x_revenue_class_id)
218: ;

Line 228: INSERT INTO cn_srp_per_quota_rc_all

224: -- Quota's period range changed and having just deleted all the
225: -- period quotas and their rev class records we will now insert the
226: -- records for the new range
227:
228: INSERT INTO cn_srp_per_quota_rc_all
229: ( srp_per_quota_rc_id
230: ,srp_period_quota_id
231: ,srp_plan_assign_id
232: ,salesrep_id

Line 280: FROM cn_srp_per_quota_rc_all spqr

276: AND p.start_date >= nvl(x_start_date, p.start_date)
277: AND p.end_date <= nvl(x_end_date, p.end_date))
278:
279: AND NOT EXISTS (SELECT 'srp_period_quota_rc already exists'
280: FROM cn_srp_per_quota_rc_all spqr
281: WHERE spqr.srp_period_quota_id = pq.srp_period_quota_id
282: AND spqr.srp_plan_assign_id = pq.srp_plan_assign_id
283: AND spqr.revenue_class_id = qr.revenue_class_id)
284: ;

Line 338: FROM cn_srp_per_quota_rc_all spqr

334: AND q.quota_id = x_quota_id
335: AND q.quota_type_code IN ('EXTERNAL','FORMULA')
336:
337: AND NOT EXISTS (SELECT 'srp_period_quota_rc already exists'
338: FROM cn_srp_per_quota_rc_all spqr
339: WHERE spqr.srp_period_quota_id = pq.srp_period_quota_id
340: AND spqr.srp_plan_assign_id = pq.srp_plan_assign_id
341: AND spqr.revenue_class_id = qr.revenue_class_id)
342: ;

Line 407: FROM cn_srp_per_quota_rc_all spqr

403: AND p.start_date >= nvl(x_start_date, p.start_date)
404: AND p.end_date <= nvl(x_end_date, p.end_date))
405:
406: AND NOT EXISTS (SELECT 'srp_period_quota_rc already exists'
407: FROM cn_srp_per_quota_rc_all spqr
408: WHERE spqr.srp_period_quota_id = pq.srp_period_quota_id
409: AND spqr.srp_plan_assign_id = pq.srp_plan_assign_id
410: AND spqr.revenue_class_id = qr.revenue_class_id)
411: ;