APPS.IBC_DIRECTORY_NODE_GRP dependencies on IBC_DIRECTORY_NODE_RELS

Line 46: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id = P_parent_dir_node_id);

42: Directory_Node_Code
43: FROM ibc_Directory_Nodes_b
44: WHERE Directory_Node_Code = P_Directory_Node_Rec.Directory_Node_Code
45: AND directory_node_id IN (SELECT child_dir_node_id
46: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id = P_parent_dir_node_id);
47:
48: l_temp CHAR(1);
49: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
50:

Line 175: Ibc_Directory_Node_Rels_Pkg.INSERT_ROW (

171:
172: --
173: -- Add the above Node to the Parent
174: --
175: Ibc_Directory_Node_Rels_Pkg.INSERT_ROW (
176: x_ROWID => lx_rowid,
177: px_DIRECTORY_NODE_REL_ID => lx_DIRECTORY_NODE_REL_ID ,
178: p_CHILD_DIR_NODE_ID => l_Directory_Node_rec.DIRECTORY_NODE_ID ,
179: p_PARENT_DIR_NODE_ID => p_PARENT_DIR_NODE_ID ,

Line 298: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_New_parent_node_id);

294: Directory_Node_Code
295: FROM ibc_Directory_Nodes_b
296: WHERE Directory_Node_Code = l_Directory_Node_Rec.Directory_Node_Code
297: AND directory_node_id IN (SELECT child_dir_node_id
298: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_New_parent_node_id);
299:
300: BEGIN
301:
302:

Line 381: FROM IBC_DIRECTORY_NODE_RELS

377: SELECT
378: DIRECTORY_NODE_REL_ID
379: INTO
380: l_DIRECTORY_NODE_REL_ID
381: FROM IBC_DIRECTORY_NODE_RELS
382: WHERE PARENT_DIR_NODE_ID = p_CURRENT_PARENT_NODE_ID
383: AND CHILD_DIR_NODE_ID = p_DIRECTORY_NODE_ID;
384:
385:

Line 386: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (

382: WHERE PARENT_DIR_NODE_ID = p_CURRENT_PARENT_NODE_ID
383: AND CHILD_DIR_NODE_ID = p_DIRECTORY_NODE_ID;
384:
385:
386: Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (
387: p_DIRECTORY_NODE_REL_ID => l_DIRECTORY_NODE_REL_ID ,
388: p_CHILD_DIR_NODE_ID => p_DIRECTORY_NODE_ID ,
389: p_PARENT_DIR_NODE_ID => p_New_PARENT_NODE_ID ,
390: p_LAST_UPDATED_BY => l_Directory_Node_rec.LAST_UPDATED_BY ,

Line 489: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_parent_dir_node_id)

485: Directory_Node_Code
486: FROM ibc_Directory_Nodes_b
487: WHERE Directory_Node_Code = P_Directory_Node_Rec.Directory_Node_Code
488: AND directory_node_id IN (SELECT child_dir_node_id
489: FROM IBC_DIRECTORY_NODE_RELS WHERE parent_dir_node_id= P_parent_dir_node_id)
490: AND Directory_Node_id <> P_Directory_Node_Rec.directory_node_id;
491:
492:
493: l_temp CHAR(1);

Line 583: -- Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (

579: p_LAST_UPDATE_LOGIN => l_Directory_Node_rec.LAST_UPDATE_LOGIN,
580: p_OBJECT_VERSION_NUMBER => l_Directory_Node_rec.OBJECT_VERSION_NUMBER);
581:
582:
583: -- Ibc_Directory_Node_Rels_Pkg.UPDATE_ROW (
584: -- p_DIRECTORY_NODE_REL_ID => lx_DIRECTORY_NODE_REL_ID ,
585: -- p_CHILD_DIR_NODE_ID => l_Directory_Node_rec.DIRECTORY_NODE_ID ,
586: -- p_PARENT_DIR_NODE_ID => p_PARENT_DIR_NODE_ID ,
587: -- p_LAST_UPDATED_BY => l_Directory_Node_rec.LAST_UPDATED_BY ,

Line 687: FROM ibc_directory_node_rels

683: WHERE Directory_Node_id = p_Directory_Node_id;
684:
685: CURSOR C_Child_Nodes IS
686: SELECT LPAD(' ',3*(LEVEL-1)) || parent_dir_node_id,child_dir_node_id,directory_node_rel_id
687: FROM ibc_directory_node_rels
688: START WITH parent_dir_node_id = p_Directory_Node_id
689: CONNECT BY PRIOR child_dir_node_id = parent_dir_node_id;
690:
691: CURSOR C_Content_Item(p_ci_dir_node_id IN NUMBER) IS

Line 786: Ibc_Directory_Node_Rels_Pkg.delete_row(

782:
783:
784: Ibc_Directory_Nodes_Pkg.DELETE_ROW (
785: p_Directory_Node_ID =>i_rec.child_dir_Node_id);
786: Ibc_Directory_Node_Rels_Pkg.delete_row(
787: p_directory_node_rel_id =>i_rec.directory_node_rel_id);
788: END LOOP;
789:
790: