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_RT_QUOTA_ASGNS_PKG dependencies on CN_RT_QUOTA_ASGNS

Line 1: PACKAGE BODY cn_rt_quota_asgns_pkg AS

1: PACKAGE BODY cn_rt_quota_asgns_pkg AS
2: -- $Header: cnplirqab.pls 120.3 2006/01/10 04:27:22 rarajara ship $
3:
4: -- Date Name Description
5: --------------------------------------------------------------------------------+

Line 8: -- Name : CN_RT_QUOTA_ASGNS_PKG

4: -- Date Name Description
5: --------------------------------------------------------------------------------+
6: -- 10-MAR-99 Kumar Sivasankaran Created
7:
8: -- Name : CN_RT_QUOTA_ASGNS_PKG
9: -- Purpose : Holds all server side packages used to insert a
10: -- rate quota asngs
11: -- Desc : Begin Record is called at the start of the commit cycle.
12: --------------------------------------------------------------------------------+

Line 41: SELECT cn_rt_quota_asgns_s.NEXTVAL

37: x_rt_quota_asgn_id IN OUT NOCOPY NUMBER
38: )
39: IS
40: BEGIN
41: SELECT cn_rt_quota_asgns_s.NEXTVAL
42: INTO x_rt_quota_asgn_id
43: FROM SYS.DUAL;
44: END get_uid;
45:

Line 89: INSERT INTO cn_rt_quota_asgns

85: -- Get Sequence Number
86: get_uid (x_rt_quota_asgn_id);
87: x_object_version_number := 1;
88:
89: INSERT INTO cn_rt_quota_asgns
90: (org_id,
91: rt_quota_asgn_id,
92: calc_formula_id,
93: quota_id,

Line 188: FROM cn_rt_quota_asgns

184: IS
185: CURSOR c
186: IS
187: SELECT *
188: FROM cn_rt_quota_asgns
189: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id
190: FOR UPDATE OF rt_quota_asgn_id NOWAIT;
191:
192: recinfo c%ROWTYPE;

Line 265: FROM cn_rt_quota_asgns_all

261: IS
262: CURSOR c
263: IS
264: SELECT *
265: FROM cn_rt_quota_asgns_all
266: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id
267: FOR UPDATE OF rt_quota_asgn_id NOWAIT;
268:
269: recinfo c%ROWTYPE;

Line 280: UPDATE cn_rt_quota_asgns

276: CLOSE c;
277:
278: x_object_version_number := NVL (recinfo.object_version_number, 1) + 1;
279:
280: UPDATE cn_rt_quota_asgns
281: SET start_date = x_start_date,
282: end_date = x_end_date,
283: rate_schedule_id = x_rate_schedule_id,
284: calc_formula_id = x_calc_formula_id,

Line 389: FROM cn_rt_quota_asgns

385: l_quota_id NUMBER
386: )
387: IS
388: SELECT rt_quota_asgn_id
389: FROM cn_rt_quota_asgns
390: WHERE quota_id = l_quota_id AND calc_formula_id = l_calc_formula_id;
391:
392: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
393: BEGIN

Line 392: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;

388: SELECT rt_quota_asgn_id
389: FROM cn_rt_quota_asgns
390: WHERE quota_id = l_quota_id AND calc_formula_id = l_calc_formula_id;
391:
392: l_rt_quota_asgn_id cn_rt_quota_asgns.rt_quota_asgn_id%TYPE;
393: BEGIN
394: l_stack := stack_type (x_calc_formula_id);
395:
396: WHILE (l_stack.COUNT > 0)

Line 453: FROM cn_rt_quota_asgns_all

449: IS
450: SELECT quota_id,
451: rate_schedule_id,
452: rt_quota_asgn_id
453: FROM cn_rt_quota_asgns_all
454: WHERE quota_id = x_quota_id AND calc_formula_id = x_calc_formula_id;
455:
456: recinfo srp_rate_insert_curs%ROWTYPE;
457:

Line 546: INSERT INTO cn_rt_quota_asgns_all

542: -- we only insert if there are overlap
543: -- clku, fix the date not overlap issue
544: IF ((l_start_date IS NOT NULL) AND (TRUNC (l_start_date) <= TRUNC (NVL (l_end_date, l_start_date))))
545: THEN
546: INSERT INTO cn_rt_quota_asgns_all
547: (rt_quota_asgn_id,
548: calc_formula_id,
549: quota_id,
550: start_date,

Line 555: SELECT cn_rt_quota_asgns_s.NEXTVAL,

551: end_date,
552: rate_schedule_id,
553: org_id
554: )
555: SELECT cn_rt_quota_asgns_s.NEXTVAL,
556: x_calc_formula_id,
557: x_quota_id,
558: l_start_date,
559: l_end_date,

Line 609: -- FROM cn_rt_quota_asgns

605: -- CURSOR srp_rate_assigns_delete IS
606: -- SELECT quota_id,
607: -- rate_schedule_id,
608: -- calc_formula_id
609: -- FROM cn_rt_quota_asgns
610: -- WHERE rt_quota_asgn_id = NVL (x_rt_quota_asgn_id, rt_quota_asgn_id)
611: -- AND quota_id = NVL (x_quota_id, quota_id);
612:
613:

Line 619: FROM cn_rt_quota_asgns

615: IS
616: SELECT quota_id,
617: rate_schedule_id,
618: calc_formula_id
619: FROM cn_rt_quota_asgns
620: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id AND quota_id = quota_id;
621:
622: CURSOR srp_rate_assigns_delete1
623: IS

Line 627: FROM cn_rt_quota_asgns

623: IS
624: SELECT quota_id,
625: rate_schedule_id,
626: calc_formula_id
627: FROM cn_rt_quota_asgns
628: WHERE rt_quota_asgn_id = rt_quota_asgn_id AND quota_id = x_quota_id;
629:
630: recinfo srp_rate_assigns_delete%ROWTYPE;
631: BEGIN

Line 653: DELETE FROM cn_rt_quota_asgns

649: END LOOP;
650:
651: CLOSE srp_rate_assigns_delete;
652:
653: DELETE FROM cn_rt_quota_asgns
654: WHERE rt_quota_asgn_id = x_rt_quota_asgn_id;
655:
656: cn_comp_plans_pkg.set_status (x_comp_plan_id => NULL,
657: x_quota_id => x_quota_id,

Line 683: DELETE FROM cn_rt_quota_asgns

679:
680: CLOSE srp_rate_assigns_delete1;
681:
682: -- drp rt Quota Asgns
683: DELETE FROM cn_rt_quota_asgns
684: WHERE quota_id = x_quota_id;
685: END IF;
686: END DELETE_RECORD;
687:

Line 805: END cn_rt_quota_asgns_pkg;

801: THEN
802: LOCK_RECORD (x_rowid, x_rt_quota_asgn_id, x_rate_schedule_id, x_start_date, x_end_date);
803: END IF;
804: END begin_record;
805: END cn_rt_quota_asgns_pkg;