APPS.CN_EVENTS_ALL_PKG dependencies on CN_EVENTS_ALL_B

Line 17: cursor C is select ROWID from CN_EVENTS_ALL_B

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_ORG_ID in NUMBER)
16: is
17: cursor C is select ROWID from CN_EVENTS_ALL_B
18: where EVENT_ID = X_EVENT_ID
19: AND ORG_ID = X_ORG_ID;
20:
21: begin

Line 22: insert into CN_EVENTS_ALL_B (

18: where EVENT_ID = X_EVENT_ID
19: AND ORG_ID = X_ORG_ID;
20:
21: begin
22: insert into CN_EVENTS_ALL_B (
23: EVENT_ID,
24: APPLICATION_REPOSITORY_ID,
25: DESCRIPTION,
26: CREATION_DATE,

Line 96: from CN_EVENTS_ALL_B

92: ) is
93: cursor c is select
94: APPLICATION_REPOSITORY_ID,
95: DESCRIPTION
96: from CN_EVENTS_ALL_B
97: where EVENT_ID = X_EVENT_ID AND
98: ORG_ID = X_ORG_ID
99: for update of EVENT_ID nowait;
100: recinfo c%rowtype;

Line 156: l_object_version_number CN_EVENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;

152: P_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER)
153: IS
154: -- Added For R12
155:
156: l_object_version_number CN_EVENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
157:
158: CURSOR l_ovn_csr IS
159: SELECT object_version_number
160: FROM CN_EVENTS_ALL_B

Line 160: FROM CN_EVENTS_ALL_B

156: l_object_version_number CN_EVENTS_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
157:
158: CURSOR l_ovn_csr IS
159: SELECT object_version_number
160: FROM CN_EVENTS_ALL_B
161: WHERE EVENT_ID = x_event_id
162: AND org_id = x_org_id;
163: -- Added For R12
164:

Line 173: update CN_EVENTS_ALL_B set

169: CLOSE l_ovn_csr;
170:
171: P_OBJECT_VERSION_NUMBER := l_object_version_number;
172:
173: update CN_EVENTS_ALL_B set
174: APPLICATION_REPOSITORY_ID = X_APPLICATION_REPOSITORY_ID,
175: DESCRIPTION = X_DESCRIPTION,
176: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
177: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 214: delete from CN_EVENTS_ALL_B

210: IF (SQL%NOTFOUND) THEN
211: RAISE no_data_found;
212: END IF;
213:
214: delete from CN_EVENTS_ALL_B
215: where EVENT_ID = X_EVENT_ID AND
216: ORG_ID = X_ORG_ID;
217:
218: if (sql%notfound) then

Line 229: from CN_EVENTS_ALL_B B

225: begin
226: delete from CN_EVENTS_ALL_TL T
227: where not exists
228: (select NULL
229: from CN_EVENTS_ALL_B B
230: where B.EVENT_ID = T.event_id
231: and B.ORG_ID = T.ORG_ID);
232:
233: update CN_EVENTS_ALL_TL T set (

Line 317: UPDATE cn_events_all_b SET

313: ELSE
314: user_id := 0;
315: END IF;
316: -- Load The record to _B table
317: UPDATE cn_events_all_b SET
318: description = x_description,
319: application_repository_id = x_application_repository_id,
320: last_update_date = sysdate,
321: last_updated_by = user_id,

Line 328: INSERT INTO cn_events_all_b

324: AND org_id = x_org_id;
325:
326: IF (SQL%NOTFOUND) THEN
327: -- Insert new record to _B table
328: INSERT INTO cn_events_all_b
329: (event_id,
330: description,
331: application_repository_id,
332: creation_date,