APPS.OKC_FOLDERS_PVT dependencies on OKC_FOLDERS_ALL_B

Line 35: CURSOR C IS SELECT ROWID FROM OKC_FOLDERS_ALL_B

31: X_LAST_UPDATE_DATE IN DATE,
32: X_LAST_UPDATED_BY IN NUMBER,
33: X_LAST_UPDATE_LOGIN IN NUMBER
34: ) IS
35: CURSOR C IS SELECT ROWID FROM OKC_FOLDERS_ALL_B
36: WHERE FOLDER_ID = X_FOLDER_ID
37: ;
38: BEGIN
39: INSERT INTO OKC_FOLDERS_ALL_B (

Line 39: INSERT INTO OKC_FOLDERS_ALL_B (

35: CURSOR C IS SELECT ROWID FROM OKC_FOLDERS_ALL_B
36: WHERE FOLDER_ID = X_FOLDER_ID
37: ;
38: BEGIN
39: INSERT INTO OKC_FOLDERS_ALL_B (
40: FOLDER_ID,
41: OBJECT_VERSION_NUMBER,
42: ORG_ID,
43: SAT_CODE,

Line 177: FROM OKC_FOLDERS_ALL_B

173: ATTRIBUTE13,
174: ATTRIBUTE14,
175: ATTRIBUTE15,
176: ORG_ID
177: FROM OKC_FOLDERS_ALL_B
178: WHERE FOLDER_ID = X_FOLDER_ID
179: FOR UPDATE OF FOLDER_ID NOWAIT;
180: recinfo c%ROWTYPE;
181:

Line 286: UPDATE OKC_FOLDERS_ALL_B SET

282: X_LAST_UPDATED_BY IN NUMBER,
283: X_LAST_UPDATE_LOGIN IN NUMBER
284: ) IS
285: BEGIN
286: UPDATE OKC_FOLDERS_ALL_B SET
287: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
288: SAT_CODE = X_SAT_CODE,
289: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
290: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 340: DELETE FROM OKC_FOLDERS_ALL_B

336: IF (SQL%NOTFOUND) THEN
337: RAISE NO_DATA_FOUND;
338: END IF;
339:
340: DELETE FROM OKC_FOLDERS_ALL_B
341: WHERE FOLDER_ID = X_FOLDER_ID;
342:
343: IF (SQL%NOTFOUND) THEN
344: RAISE NO_DATA_FOUND;

Line 354: FROM OKC_FOLDERS_ALL_B B

350: BEGIN
351: DELETE FROM OKC_FOLDERS_ALL_TL T
352: WHERE NOT EXISTS
353: (SELECT NULL
354: FROM OKC_FOLDERS_ALL_B B
355: WHERE B.FOLDER_ID = T.FOLDER_ID
356: );
357:
358: UPDATE OKC_FOLDERS_ALL_TL T SET (