APPS.IBC_DIRECTORY_NODE_RELS_PKG dependencies on IBC_DIRECTORY_NODE_RELS

Line 1: PACKAGE BODY Ibc_Directory_Node_Rels_Pkg AS

1: PACKAGE BODY Ibc_Directory_Node_Rels_Pkg AS
2: /* $Header: ibctdrlb.pls 120.2 2005/08/08 14:10:52 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Directory_Node_Rels table.
5:

Line 4: -- Purpose: Table Handler for Ibc_Directory_Node_Rels table.

1: PACKAGE BODY Ibc_Directory_Node_Rels_Pkg AS
2: /* $Header: ibctdrlb.pls 120.2 2005/08/08 14:10:52 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Directory_Node_Rels table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 24: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODE_RELS

20: p_LAST_UPDATE_DATE IN DATE,
21: p_LAST_UPDATED_BY IN NUMBER,
22: p_LAST_UPDATE_LOGIN IN NUMBER
23: ) IS
24: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODE_RELS
25: WHERE Directory_Node_Rel_ID = px_Directory_Node_Rel_ID;
26:
27: CURSOR c2 IS SELECT ibc_Directory_Node_Rels_s1.NEXTVAL FROM dual;
28:

Line 27: CURSOR c2 IS SELECT ibc_Directory_Node_Rels_s1.NEXTVAL FROM dual;

23: ) IS
24: CURSOR C IS SELECT ROWID FROM IBC_DIRECTORY_NODE_RELS
25: WHERE Directory_Node_Rel_ID = px_Directory_Node_Rel_ID;
26:
27: CURSOR c2 IS SELECT ibc_Directory_Node_Rels_s1.NEXTVAL FROM dual;
28:
29: CURSOR c_dirnode(p_dir_node_id NUMBER) IS
30: SELECT directory_node_code
31: FROM ibc_directory_nodes_b

Line 65: INSERT INTO IBC_DIRECTORY_NODE_RELS (

61: FETCH c2 INTO px_Directory_Node_Rel_ID;
62: CLOSE c2;
63: END IF;
64:
65: INSERT INTO IBC_DIRECTORY_NODE_RELS (
66: Directory_Node_Rel_ID,
67: CHILD_DIR_NODE_ID,
68: PARENT_DIR_NODE_ID,
69: OBJECT_VERSION_NUMBER,

Line 108: FROM IBC_DIRECTORY_NODE_RELS

104: p_OBJECT_VERSION_NUMBER IN NUMBER
105: ) IS
106: CURSOR c IS SELECT
107: OBJECT_VERSION_NUMBER
108: FROM IBC_DIRECTORY_NODE_RELS
109: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
110: FOR UPDATE OF CHILD_DIR_NODE_ID NOWAIT;
111: recinfo c%ROWTYPE;
112:

Line 168: UPDATE IBC_DIRECTORY_NODE_RELS SET

164: RAISE Fnd_Api.G_EXC_ERROR;
165: END IF;
166: END LOOP;
167:
168: UPDATE IBC_DIRECTORY_NODE_RELS SET
169: CHILD_DIR_NODE_ID = DECODE(p_CHILD_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,CHILD_DIR_NODE_ID,p_CHILD_DIR_NODE_ID),
170: PARENT_DIR_NODE_ID = DECODE(p_PARENT_DIR_NODE_ID,FND_API.G_MISS_NUM,NULL,NULL,PARENT_DIR_NODE_ID,p_PARENT_DIR_NODE_ID),
171: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
172: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,

Line 197: DELETE FROM IBC_DIRECTORY_NODE_RELS

193: p_Directory_Node_Rel_ID IN NUMBER
194: ) IS
195: BEGIN
196:
197: DELETE FROM IBC_DIRECTORY_NODE_RELS
198: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID;
199:
200: IF (SQL%NOTFOUND) THEN
201: RAISE NO_DATA_FOUND;

Line 257: FROM IBC_DIRECTORY_NODE_RELS

253: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
254:
255: -- get updatedby and update_date values if existing in db
256: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
257: FROM IBC_DIRECTORY_NODE_RELS
258: WHERE Directory_Node_Rel_ID = p_Directory_Node_Rel_ID
259: AND object_version_number = DECODE(object_version_number,
260: FND_API.G_MISS_NUM,object_version_number,
261: NULL,object_version_number,

Line 267: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (

263:
264: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
265: db_user_id, db_last_update_date, p_upload_mode )) THEN
266:
267: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (
268: p_DIRECTORY_NODE_REL_ID => p_DIRECTORY_NODE_REL_ID ,
269: p_CHILD_DIR_NODE_ID => nvl(p_child_dir_NODE_ID,FND_API.G_MISS_NUM),
270: p_PARENT_DIR_NODE_ID => nvl(p_pARENT_dir_NODE_ID,FND_API.G_MISS_NUM),
271: p_LAST_UPDATED_BY => l_user_id,

Line 279: Ibc_Directory_Node_Rels_Pkg.INSERT_ROW (

275:
276: END IF;
277: EXCEPTION
278: WHEN NO_DATA_FOUND THEN
279: Ibc_Directory_Node_Rels_Pkg.INSERT_ROW (
280: x_ROWID => l_row_id,
281: px_DIRECTORY_NODE_REL_ID => lx_DIRECTORY_NODE_REL_ID ,
282: p_CHILD_DIR_NODE_ID => p_child_dir_node_id,
283: p_PARENT_DIR_NODE_ID => p_PARENT_DIR_NODE_ID ,

Line 331: Ibc_Directory_Node_Rels_Pkg.LOAD_ROW (

327: BEGIN
328: IF (p_UPLOAD_MODE = 'NLS') THEN
329: NULL;
330: ELSE
331: Ibc_Directory_Node_Rels_Pkg.LOAD_ROW (
332: p_UPLOAD_MODE => p_UPLOAD_MODE,
333: p_DIRECTORY_NODE_REL_ID => p_DIRECTORY_NODE_REL_ID,
334: p_CHILD_DIR_NODE_ID => p_CHILD_DIR_NODE_ID,
335: p_PARENT_DIR_NODE_ID => p_PARENT_DIR_NODE_ID,

Line 341: END Ibc_Directory_Node_Rels_Pkg;

337: p_last_update_date => p_LAST_UPDATE_DATE);
338: END IF;
339: END LOAD_SEED_ROW;
340:
341: END Ibc_Directory_Node_Rels_Pkg;