APPS.CN_ROLLOVER_QUOTAS_PKG dependencies on CN_ROLLOVER_QUOTAS

Line 1: PACKAGE BODY CN_ROLLOVER_QUOTAS_PKG as

1: PACKAGE BODY CN_ROLLOVER_QUOTAS_PKG as
2: /* $Header: cnrqpkgb.pls 115.1 2002/12/04 02:13:25 fting noship $ */
3:
4:
5:

Line 43: cursor C is select ROWID from CN_ROLLOVER_QUOTAS

39: X_LAST_UPDATE_DATE IN DATE,
40: X_LAST_UPDATED_BY IN NUMBER,
41: X_LAST_UPDATE_LOGIN IN NUMBER
42: ) is
43: cursor C is select ROWID from CN_ROLLOVER_QUOTAS
44: where ROLLOVER_QUOTA_ID = X_ROLLOVER_QUOTA_ID ;
45:
46: l_rollover_quota_id NUMBER;
47: BEGIN

Line 50: SELECT CN_ROLLOVER_QUOTAS_S.NEXTVAL

46: l_rollover_quota_id NUMBER;
47: BEGIN
48:
49: IF (X_ROLLOVER_QUOTA_ID IS NULL) THEN
50: SELECT CN_ROLLOVER_QUOTAS_S.NEXTVAL
51: INTO l_rollover_quota_id
52: FROM dual;
53: ELSE
54: l_rollover_quota_id := x_rollover_quota_id;

Line 57: insert into CN_ROLLOVER_QUOTAS (

53: ELSE
54: l_rollover_quota_id := x_rollover_quota_id;
55: END IF;
56:
57: insert into CN_ROLLOVER_QUOTAS (
58: ROLLOVER_QUOTA_ID,
59: QUOTA_ID,
60: SOURCE_QUOTA_ID,
61: ROLLOVER,

Line 152: update CN_ROLLOVER_QUOTAS set

148: X_LAST_UPDATED_BY IN NUMBER,
149: X_LAST_UPDATE_LOGIN IN NUMBER
150: ) is
151: begin
152: update CN_ROLLOVER_QUOTAS set
153: SOURCE_QUOTA_ID = X_SOURCE_QUOTA_ID,
154: ROLLOVER = X_ROLLOVER,
155: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
156: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 186: delete from CN_ROLLOVER_QUOTAS

182: procedure DELETE_ROW (
183: X_ROLLOVER_QUOTA_ID IN NUMBER
184: ) is
185: begin
186: delete from CN_ROLLOVER_QUOTAS
187: where ROLLOVER_QUOTA_ID = X_ROLLOVER_QUOTA_ID;
188:
189: if (sql%notfound) then
190: raise no_data_found;

Line 196: END CN_ROLLOVER_QUOTAS_PKG;

192:
193: end DELETE_ROW;
194:
195:
196: END CN_ROLLOVER_QUOTAS_PKG;