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_RATE_ASSIGNS_PKG dependencies on CN_SRP_RATE_ASSIGNS_ALL

Line 79: DELETE FROM cn_srp_rate_assigns_all

75:
76: IF x_rate_tier_id IS NOT NULL AND x_rate_schedule_id IS NOT NULL THEN
77:
78: -- cn_rate_tiers record deleted
79: DELETE FROM cn_srp_rate_assigns_all
80: WHERE rate_tier_id = x_rate_tier_id
81: AND rate_schedule_id = x_rate_schedule_id;
82:
83: ELSE

Line 90: DELETE FROM cn_srp_rate_assigns_all

86:
87: IF x_rt_quota_asgn_id IS NOT NULL THEN
88: -- delete the specific rt_quota_asgns_record.
89:
90: DELETE FROM cn_srp_rate_assigns_all
91: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id
92: AND quota_id = x_quota_id;
93:
94: ELSIF x_srp_plan_assign_id IS NOT NULL THEN

Line 97: DELETE FROM cn_srp_rate_assigns_all

93:
94: ELSIF x_srp_plan_assign_id IS NOT NULL THEN
95:
96: -- deleted cn_quota_assign record
97: DELETE FROM cn_srp_rate_assigns_all
98: WHERE srp_plan_assign_id = x_srp_plan_assign_id
99: AND quota_id = x_quota_id;
100:
101: ELSIF x_rate_schedule_id IS NOT NULL THEN

Line 104: DELETE FROM cn_srp_rate_assigns_all

100:
101: ELSIF x_rate_schedule_id IS NOT NULL THEN
102:
103: -- quota has been assigned a different schedule
104: DELETE FROM cn_srp_rate_assigns_all
105: WHERE rate_schedule_id = x_rate_schedule_id
106: AND quota_id = x_quota_id;
107:
108: END IF;

Line 112: DELETE FROM cn_srp_rate_assigns_all

108: END IF;
109:
110: ELSE
111: -- deleting a srp plan assign
112: DELETE FROM cn_srp_rate_assigns_all
113: WHERE srp_plan_assign_id = x_srp_plan_assign_id;
114:
115: END IF;
116:

Line 176: INSERT INTO cn_srp_rate_assigns_all

172: IF x_srp_plan_assign_id IS NOT NULL THEN
173:
174: IF x_quota_id IS NOT NULL THEN
175:
176: INSERT INTO cn_srp_rate_assigns_all
177: (
178: srp_plan_assign_id
179: ,srp_quota_assign_id
180: ,srp_rate_assign_id

Line 227: INSERT INTO cn_srp_rate_assigns_all

223: --- is being assigned to a COmp Plan.
224:
225: ELSE
226: -- New plan assignment
227: INSERT INTO cn_srp_rate_assigns_all
228: (srp_plan_assign_id
229: ,srp_quota_assign_id
230: ,srp_rate_assign_id
231: ,rate_tier_id

Line 275: INSERT INTO cn_srp_rate_assigns_all

271: -- create a new rt_quota_assigns
272: -- 1 called from cn_rt_quota_assigns insert_record
273: IF x_rt_quota_asgn_id IS NOT NULL THEN
274:
275: INSERT INTO cn_srp_rate_assigns_all
276: (srp_plan_assign_id
277: ,srp_quota_assign_id
278: ,srp_rate_assign_id
279: ,rate_tier_id

Line 323: INSERT INTO cn_srp_rate_assigns_all

319: ;
320:
321: ELSE
322:
323: INSERT INTO cn_srp_rate_assigns_all
324: (srp_plan_assign_id
325: ,srp_quota_assign_id
326: ,srp_rate_assign_id
327: ,rate_tier_id

Line 373: INSERT INTO cn_srp_rate_assigns_all

369:
370: ELSIF ( x_quota_id IS NULL AND x_rate_schedule_id IS NOT NULL
371: AND x_rate_tier_id IS NOT NULL) THEN
372:
373: INSERT INTO cn_srp_rate_assigns_all
374: ( srp_plan_assign_id
375: ,srp_quota_assign_id
376: ,srp_rate_assign_id
377: ,rate_tier_id

Line 432: FROM cn_srp_rate_assigns_all

428: X_Commission_Rate NUMBER,
429: x_commission_amount NUMBER ) IS
430: CURSOR C IS
431: SELECT *
432: FROM cn_srp_rate_assigns_all
433: WHERE srp_rate_assign_id = x_srp_rate_assign_id
434: FOR UPDATE OF srp_rate_assign_id NOWAIT;
435: Recinfo C%ROWTYPE;
436:

Line 484: UPDATE cn_srp_rate_assigns_all

480: ,x_last_updated_by NUMBER
481: ,x_last_update_login NUMBER) IS
482: BEGIN
483:
484: UPDATE cn_srp_rate_assigns_all
485: SET commission_amount = x_commission_amount
486: ,last_update_date = x_last_update_date
487: ,last_updated_by = x_last_updated_by
488: ,last_update_login = x_last_update_login