APPS.CN_SRP_QUOTA_RATES_PKG dependencies on CN_SRP_QUOTA_RATES

Line 1: PACKAGE body cn_srp_quota_rates_pkg AS

1: PACKAGE body cn_srp_quota_rates_pkg AS
2: /*$Header: cntsrqrb.pls 115.3 2002/01/28 20:06:13 pkm ship $*/
3:
4: -------------------------------------------------------------------------------+
5: -- Procedure Name : Insert_Row --+

Line 6: -- Purpose : Insert given fields into the cn_srp_quota_rates table; --+

2: /*$Header: cntsrqrb.pls 115.3 2002/01/28 20:06:13 pkm ship $*/
3:
4: -------------------------------------------------------------------------------+
5: -- Procedure Name : Insert_Row --+
6: -- Purpose : Insert given fields into the cn_srp_quota_rates table; --+
7: -- also do a cascade insert into cn_srp_quota_rates if --+
8: -- required --+
9: -- History --+
10: -- 06-JUN-2000 mblum Created --+

Line 7: -- also do a cascade insert into cn_srp_quota_rates if --+

3:
4: -------------------------------------------------------------------------------+
5: -- Procedure Name : Insert_Row --+
6: -- Purpose : Insert given fields into the cn_srp_quota_rates table; --+
7: -- also do a cascade insert into cn_srp_quota_rates if --+
8: -- required --+
9: -- History --+
10: -- 06-JUN-2000 mblum Created --+
11: -------------------------------------------------------------------------------+

Line 40: SELECT cn_srp_quota_rates_s.nextval

36: l_srp_quota_rate_id number;
37:
38: BEGIN
39: -- Get the next value in sequence
40: SELECT cn_srp_quota_rates_s.nextval
41: INTO l_srp_quota_rate_id
42: FROM dual;
43:
44: -- Now insert row

Line 45: INSERT INTO cn_srp_quota_rates

41: INTO l_srp_quota_rate_id
42: FROM dual;
43:
44: -- Now insert row
45: INSERT INTO cn_srp_quota_rates
46: (srp_quota_rate_id, srp_quota_cate_id, role_quota_rate_id, srp_id,
47: quota_category_id, rate_tier_id, comm_rate, attribute_category,
48: attribute1, attribute2, attribute3, attribute4, attribute5,
49: attribute6, attribute7, attribute8, attribute9, attribute10,

Line 64: -- Purpose : Update given fields in the cn_srp_quota_rates table; --+

60: END Insert_Row;
61:
62: -------------------------------------------------------------------------------+
63: -- Procedure Name : Update_Row --+
64: -- Purpose : Update given fields in the cn_srp_quota_rates table; --+
65: -- also do a cascade update into cn_srp_quota_rates if --+
66: -- required --+
67: -- History --+
68: -- 06-JUN-2000 mblum Created --+

Line 65: -- also do a cascade update into cn_srp_quota_rates if --+

61:
62: -------------------------------------------------------------------------------+
63: -- Procedure Name : Update_Row --+
64: -- Purpose : Update given fields in the cn_srp_quota_rates table; --+
65: -- also do a cascade update into cn_srp_quota_rates if --+
66: -- required --+
67: -- History --+
68: -- 06-JUN-2000 mblum Created --+
69: -------------------------------------------------------------------------------+

Line 126: FROM cn_srp_quota_rates r

122: rate_tier_id, comm_rate, attribute_category, attribute1, attribute2,
123: attribute3, attribute4, attribute5, attribute6, attribute7,
124: attribute8, attribute9, attribute10, attribute11, attribute12,
125: attribute13, attribute14, attribute15, object_version_number
126: FROM cn_srp_quota_rates r
127: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
128:
129: MN NUMBER := FND_API.G_MISS_NUM;
130: MC VARCHAR2(150) := FND_API.G_MISS_CHAR;

Line 166: UPDATE cn_srp_quota_rates r SET

162: IF (attribute13 <> MC) THEN l_attribute13 := attribute13; END IF;
163: IF (attribute14 <> MC) THEN l_attribute14 := attribute14; END IF;
164: IF (attribute15 <> MC) THEN l_attribute15 := attribute15; END IF;
165:
166: UPDATE cn_srp_quota_rates r SET
167: srp_quota_cate_id = l_srp_quota_cate_id,
168: role_quota_rate_id = l_role_quota_rate_id,
169: quota_category_id = l_quota_category_id, srp_id = l_srp_id,
170: rate_tier_id = l_rate_tier_id, comm_rate = l_comm_rate,

Line 189: -- Purpose : Delete the specified row in the cn_srp_quota_rates table;--+

185: END Update_Row;
186:
187: -------------------------------------------------------------------------------+
188: -- Procedure Name : Delete_Row --+
189: -- Purpose : Delete the specified row in the cn_srp_quota_rates table;--+
190: -- also cascade delete in cn_srp_quota_rates if required --+
191: -- History --+
192: -- 06-JUN-2000 mblum Created --+
193: -------------------------------------------------------------------------------+

Line 190: -- also cascade delete in cn_srp_quota_rates if required --+

186:
187: -------------------------------------------------------------------------------+
188: -- Procedure Name : Delete_Row --+
189: -- Purpose : Delete the specified row in the cn_srp_quota_rates table;--+
190: -- also cascade delete in cn_srp_quota_rates if required --+
191: -- History --+
192: -- 06-JUN-2000 mblum Created --+
193: -------------------------------------------------------------------------------+
194: PROCEDURE delete_row

Line 198: DELETE FROM cn_srp_quota_rates r

194: PROCEDURE delete_row
195: (SRP_QUOTA_RATE_ID IN NUMBER) IS
196: l_srp_quota_rate_id number := srp_quota_rate_id;
197: BEGIN
198: DELETE FROM cn_srp_quota_rates r
199: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
200: END Delete_Row;
201:
202: END cn_srp_quota_rates_pkg;

Line 202: END cn_srp_quota_rates_pkg;

198: DELETE FROM cn_srp_quota_rates r
199: WHERE r.srp_quota_rate_id = l_srp_quota_rate_id;
200: END Delete_Row;
201:
202: END cn_srp_quota_rates_pkg;