APPS.CLN_NOTIFICATION_CODES_PKG dependencies on CLN_NOTIFICATION_CODES_B

Line 16: cursor C is select ROWID from CLN_NOTIFICATION_CODES_B

12: X_LAST_UPDATE_DATE in DATE,
13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: ) is
16: cursor C is select ROWID from CLN_NOTIFICATION_CODES_B
17: where NOTIFICATION_ID = X_NOTIFICATION_ID
18: ;
19: begin
20: insert into CLN_NOTIFICATION_CODES_B (

Line 20: insert into CLN_NOTIFICATION_CODES_B (

16: cursor C is select ROWID from CLN_NOTIFICATION_CODES_B
17: where NOTIFICATION_ID = X_NOTIFICATION_ID
18: ;
19: begin
20: insert into CLN_NOTIFICATION_CODES_B (
21: NOTIFICATION_ID,
22: COLLABORATION_POINT,
23: NOTIFICATION_CODE,
24: CREATION_DATE,

Line 87: from CLN_NOTIFICATION_CODES_B

83: ) is
84: cursor c is select
85: COLLABORATION_POINT,
86: NOTIFICATION_CODE
87: from CLN_NOTIFICATION_CODES_B
88: where NOTIFICATION_ID = X_NOTIFICATION_ID
89: for update of NOTIFICATION_ID nowait;
90: recinfo c%rowtype;
91:

Line 144: update CLN_NOTIFICATION_CODES_B set

140: X_LAST_UPDATED_BY in NUMBER,
141: X_LAST_UPDATE_LOGIN in NUMBER
142: ) is
143: begin
144: update CLN_NOTIFICATION_CODES_B set
145: COLLABORATION_POINT = X_COLLABORATION_POINT,
146: NOTIFICATION_CODE = X_NOTIFICATION_CODE,
147: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
148: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 181: delete from CLN_NOTIFICATION_CODES_B

177: if (sql%notfound) then
178: raise no_data_found;
179: end if;
180:
181: delete from CLN_NOTIFICATION_CODES_B
182: where NOTIFICATION_ID = X_NOTIFICATION_ID;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 195: from CLN_NOTIFICATION_CODES_B B

191: begin
192: delete from CLN_NOTIFICATION_CODES_TL T
193: where not exists
194: (select NULL
195: from CLN_NOTIFICATION_CODES_B B
196: where B.NOTIFICATION_ID = T.NOTIFICATION_ID
197: );
198:
199: update CLN_NOTIFICATION_CODES_TL T set (

Line 299: SELECT NOTIFICATION_ID INTO l_notification_id FROM CLN_NOTIFICATION_CODES_B

295: -- l_notification_id := fnd_number.canonical_to_number(X_NOTIFICATION_ID);
296:
297: BEGIN
298:
299: SELECT NOTIFICATION_ID INTO l_notification_id FROM CLN_NOTIFICATION_CODES_B
300: WHERE NOTIFICATION_CODE = X_NOTIFICATION_CODE
301: AND COLLABORATION_POINT = X_COLLABORATION_POINT;
302:
303: EXCEPTION

Line 308: insert into CLN_NOTIFICATION_CODES_B (

304: WHEN NO_DATA_FOUND then
305:
306: SELECT CLN_NOTIFICATION_CODES_S.NEXTVAL INTO l_notification_id FROM DUAL;
307:
308: insert into CLN_NOTIFICATION_CODES_B (
309: NOTIFICATION_ID,
310: COLLABORATION_POINT,
311: NOTIFICATION_CODE,
312: CREATION_DATE,