APPS.IBC_UTILITIES_PVT dependencies on IBC_DIRECTORY_NODES_B

Line 97: FROM ibc_directory_nodes_b

93: IS
94:
95: CURSOR c_name(p_directory_node_id NUMBER) IS
96: SELECT directory_node_code
97: FROM ibc_directory_nodes_b
98: WHERE directory_node_id = p_directory_node_id;
99:
100: l_directory_name IBC_DIRECTORY_NODES_B.directory_node_code%TYPE;
101:

Line 100: l_directory_name IBC_DIRECTORY_NODES_B.directory_node_code%TYPE;

96: SELECT directory_node_code
97: FROM ibc_directory_nodes_b
98: WHERE directory_node_id = p_directory_node_id;
99:
100: l_directory_name IBC_DIRECTORY_NODES_B.directory_node_code%TYPE;
101:
102: BEGIN
103:
104: OPEN c_name(p_directory_node_id);

Line 164: FROM ibc_directory_nodes_b

160: RETURN VARCHAR2
161: IS
162: CURSOR c_dirid IS
163: SELECT directory_node_id
164: FROM ibc_directory_nodes_b
165: WHERE directory_path = p_directory_path
166: AND node_type = p_node_type;
167:
168: l_dirid NUMBER;

Line 1437: FROM ibc_directory_nodes_b

1433: l_hidden_flag VARCHAR2(1);
1434:
1435: CURSOR c_dir_info(p_dir_node_id NUMBER) IS
1436: SELECT hidden_flag
1437: FROM ibc_directory_nodes_b
1438: WHERE directory_node_id = p_dir_node_id;
1439:
1440: CURSOR c_chk_name IS
1441: SELECT 'CITEM', civb.content_item_id

Line 1455: FROM ibc_directory_nodes_b dirnodeb,

1451: )
1452: AND UPPER(civtl.content_item_name) = UPPER(p_name)
1453: UNION
1454: SELECT 'DIRNODE', dirnodeb.directory_node_id
1455: FROM ibc_directory_nodes_b dirnodeb,
1456: ibc_directory_node_rels dirrel
1457: WHERE dirnodeb.directory_node_id = dirrel.child_dir_node_id
1458: AND dirrel.parent_dir_node_id = l_dir_node_id
1459: AND dirnodeb.directory_node_id <> NVL(p_chk_dir_node_id, -1)