APPS.IBC_DIRECTORY_NODES_PKG dependencies on IBC_DIRECTORY_NODES_B

Line 42: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODES_B

38: p_LAST_UPDATE_DATE IN DATE,
39: p_LAST_UPDATED_BY IN NUMBER,
40: p_LAST_UPDATE_LOGIN IN NUMBER
41: ) IS
42: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODES_B
43: WHERE DIRECTORY_NODE_ID = px_DIRECTORY_NODE_ID
44: ;
45: CURSOR c2 IS SELECT ibc_directory_nodes_b_s1.NEXTVAL FROM dual;
46:

Line 45: CURSOR c2 IS SELECT ibc_directory_nodes_b_s1.NEXTVAL FROM dual;

41: ) IS
42: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODES_B
43: WHERE DIRECTORY_NODE_ID = px_DIRECTORY_NODE_ID
44: ;
45: CURSOR c2 IS SELECT ibc_directory_nodes_b_s1.NEXTVAL FROM dual;
46:
47: BEGIN
48:
49: -- Primary key validation check

Line 59: INSERT INTO IBC_DIRECTORY_NODES_B (

55: FETCH c2 INTO px_DIRECTORY_NODE_ID;
56: CLOSE c2;
57: END IF;
58:
59: INSERT INTO IBC_DIRECTORY_NODES_B (
60: DIRECTORY_NODE_ID,
61: DIRECTORY_NODE_CODE,
62: NODE_STATUS,
63: DIRECTORY_PATH,

Line 250: FROM IBC_DIRECTORY_NODES_B

246: AVAILABLE_DATE,
247: EXPIRATION_DATE,
248: HIDDEN_FLAG,
249: OBJECT_VERSION_NUMBER
250: FROM IBC_DIRECTORY_NODES_B
251: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID
252: FOR UPDATE OF DIRECTORY_NODE_ID NOWAIT;
253: recinfo c%ROWTYPE;
254:

Line 382: UPDATE IBC_DIRECTORY_NODES_B SET

378: RAISE Fnd_Api.G_EXC_ERROR;
379: END IF;
380: END LOOP;
381:
382: UPDATE IBC_DIRECTORY_NODES_B SET
383: DIRECTORY_NODE_CODE = DECODE(p_DIRECTORY_NODE_CODE,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_NODE_CODE,p_DIRECTORY_NODE_CODE),
384: NODE_STATUS = DECODE(p_NODE_STATUS,FND_API.G_MISS_CHAR,NULL,NULL,NODE_STATUS,p_NODE_STATUS),
385: DIRECTORY_PATH = DECODE(p_DIRECTORY_PATH,FND_API.G_MISS_CHAR,NULL,NULL,DIRECTORY_PATH,p_DIRECTORY_PATH),
386: AVAILABLE_DATE = DECODE(p_AVAILABLE_DATE,FND_API.G_MISS_DATE,NULL,p_AVAILABLE_DATE),

Line 477: DELETE FROM IBC_DIRECTORY_NODES_B

473: IF (SQL%NOTFOUND) THEN
474: RAISE NO_DATA_FOUND;
475: END IF;
476:
477: DELETE FROM IBC_DIRECTORY_NODES_B
478: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
479:
480: IF (SQL%NOTFOUND) THEN
481: RAISE NO_DATA_FOUND;

Line 500: FROM IBC_DIRECTORY_NODES_B B

496: BEGIN
497: DELETE FROM IBC_DIRECTORY_NODES_TL T
498: WHERE NOT EXISTS
499: (SELECT NULL
500: FROM IBC_DIRECTORY_NODES_B B
501: WHERE B.DIRECTORY_NODE_ID = T.DIRECTORY_NODE_ID
502: );
503:
504: UPDATE IBC_DIRECTORY_NODES_TL T SET (

Line 593: FROM IBC_DIRECTORY_NODES_B

589: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
590:
591: -- get updatedby and update_date values if existing in db
592: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
593: FROM IBC_DIRECTORY_NODES_B
594: WHERE DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID;
595:
596: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
597: db_user_id, db_last_update_date, p_upload_mode )) THEN