APPS.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_DIRECTORY_NODES_B

Line 320: ibc_directory_nodes_b dirnode

316:
317: CURSOR c_directory(p_content_item_id NUMBER) IS
318: SELECT citem.directory_node_id, dirnode.directory_path
319: FROM ibc_content_items citem,
320: ibc_directory_nodes_b dirnode
321: WHERE citem.content_item_id = p_content_item_id
322: AND citem.directory_node_id = dirnode.directory_node_id;
323:
324: -- Cursor to get resource_id and type from current logged-on user.

Line 1064: ibc_directory_nodes_b dirnode

1060:
1061: CURSOR c_directory(p_content_item_id NUMBER) IS
1062: SELECT citem.directory_node_id, dirnode.directory_path
1063: FROM ibc_content_items citem,
1064: ibc_directory_nodes_b dirnode
1065: WHERE citem.content_item_id = p_content_item_id
1066: AND citem.directory_node_id = dirnode.directory_node_id;
1067: --l_directory_node_id NUMBER;
1068: l_directory_path VARCHAR2(4000);

Line 1864: ibc_directory_nodes_b dirnode

1860:
1861: CURSOR c_directory(p_content_item_id NUMBER) IS
1862: SELECT citem.directory_node_id, dirnode.directory_path
1863: FROM ibc_content_items citem,
1864: ibc_directory_nodes_b dirnode
1865: WHERE citem.content_item_id = p_content_item_id
1866: AND citem.directory_node_id = dirnode.directory_node_id;
1867:
1868:

Line 2779: ibc_directory_nodes_b dirnode

2775:
2776: CURSOR c_citem_location(p_content_item_id NUMBER) IS
2777: SELECT dirnode.directory_path
2778: FROM ibc_content_items citem,
2779: ibc_directory_nodes_b dirnode
2780: WHERE citem.content_item_id = p_content_item_id
2781: AND citem.directory_node_id = dirnode.directory_node_id;
2782:
2783: CURSOR c_directory(p_directory_node_id NUMBER) IS

Line 2785: FROM ibc_directory_nodes_b dirnode

2781: AND citem.directory_node_id = dirnode.directory_node_id;
2782:
2783: CURSOR c_directory(p_directory_node_id NUMBER) IS
2784: SELECT dirnode.directory_path
2785: FROM ibc_directory_nodes_b dirnode
2786: WHERE directory_node_id = p_directory_node_id;
2787:
2788: ls_directory_path VARCHAR2(4000);
2789: ld_dirctory_path VARCHAR2(4000);

Line 3002: ibc_directory_nodes_b dirnode

2998:
2999: CURSOR c_citem_location(p_content_item_id NUMBER) IS
3000: SELECT dirnode.directory_path, dirnode.directory_node_id
3001: FROM ibc_content_items citem,
3002: ibc_directory_nodes_b dirnode
3003: WHERE citem.content_item_id = p_content_item_id
3004: AND citem.directory_node_id = dirnode.directory_node_id;
3005:
3006: