APPS.CZ_PUB_MGR dependencies on CZ_RP_ENTRIES

Line 92: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries

88: AND published IS NULL
89: AND EXISTS (SELECT null FROM cz_model_ref_expls
90: WHERE model_id=cz_devl_projects.devl_project_id
91: AND deleted_flag='0')
92: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries
93: WHERE object_type = 'PRJ'
94: AND deleted_flag = '0');
95:
96: begin

Line 178: FOR i IN (SELECT object_id FROM CZ_RP_ENTRIES

174: PROCEDURE collect_Folders(p_folder_id IN NUMBER) IS
175: l_folders_exist BOOLEAN := FALSE;
176: BEGIN
177:
178: FOR i IN (SELECT object_id FROM CZ_RP_ENTRIES
179: WHERE enclosing_folder=p_folder_id AND object_type='FLD')
180: LOOP
181: l_folders_exist := TRUE;
182: collect_Folders(i.object_id);

Line 200: FROM CZ_RP_ENTRIES

196: BEGIN
197:
198: SELECT object_id, object_type
199: BULK COLLECT INTO l_object_id_tbl, l_object_type_tbl
200: FROM CZ_RP_ENTRIES
201: WHERE enclosing_folder=p_folder_id;
202:
203: IF l_object_id_tbl.COUNT>0 THEN
204: FORALL i IN l_object_id_tbl.First..l_object_id_tbl.Last

Line 205: DELETE FROM CZ_RP_ENTRIES

201: WHERE enclosing_folder=p_folder_id;
202:
203: IF l_object_id_tbl.COUNT>0 THEN
204: FORALL i IN l_object_id_tbl.First..l_object_id_tbl.Last
205: DELETE FROM CZ_RP_ENTRIES
206: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i);
207: END IF;
208:
209: DELETE FROM CZ_RP_ENTRIES

Line 209: DELETE FROM CZ_RP_ENTRIES

205: DELETE FROM CZ_RP_ENTRIES
206: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i);
207: END IF;
208:
209: DELETE FROM CZ_RP_ENTRIES
210: WHERE object_id=p_folder_id AND object_type='FLD'
211: RETURNING enclosing_folder INTO x_enclosing_folder;
212:
213: END update_Objects_In_Folder;

Line 221: FOR i IN (SELECT object_id, enclosing_folder FROM CZ_RP_ENTRIES

217: BEGIN
218:
219: update_Objects_In_Folder(p_folder_id, l_enclosing_folder);
220:
221: FOR i IN (SELECT object_id, enclosing_folder FROM CZ_RP_ENTRIES
222: WHERE object_id=l_enclosing_folder AND object_type='FLD')
223: LOOP
224: -- we should stop on this folder
225: IF i.object_id=p_subroot_folder_id THEN

Line 237: FOR i IN(SELECT object_id FROM CZ_RP_ENTRIES

233: END goto_Folder;
234:
235: BEGIN
236:
237: FOR i IN(SELECT object_id FROM CZ_RP_ENTRIES
238: WHERE object_type='FLD' AND deleted_flag='1')
239: LOOP
240: --
241: -- array l_end_folder_ids_tbl will contain all subfolders

Line 257: -- and update CZ_RP_ENTRIES level by level

253: END IF;
254:
255: --
256: -- go up from folders which have no subfolders ( array l_end_folder_ids_tbl )
257: -- and update CZ_RP_ENTRIES level by level
258: --
259: FOR k IN l_end_folder_ids_tbl.First..l_end_folder_ids_tbl.Last
260: LOOP
261: IF l_end_folder_ids_tbl(k) <> i.object_id THEN

Line 266: DELETE FROM CZ_RP_ENTRIES

262: goto_Folder(l_end_folder_ids_tbl(k), i.object_id);
263: END IF;
264: END LOOP;
265:
266: DELETE FROM CZ_RP_ENTRIES
267: WHERE enclosing_folder=i.object_id;
268:
269: DELETE FROM CZ_RP_ENTRIES
270: WHERE object_id=i.object_id AND object_type='FLD';

Line 269: DELETE FROM CZ_RP_ENTRIES

265:
266: DELETE FROM CZ_RP_ENTRIES
267: WHERE enclosing_folder=i.object_id;
268:
269: DELETE FROM CZ_RP_ENTRIES
270: WHERE object_id=i.object_id AND object_type='FLD';
271:
272: END LOOP;
273: