APPS.CZ_PUB_MGR dependencies on CZ_RP_ENTRIES

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

75: CURSOR cDeletedPublication IS
76: SELECT devl_project_id
77: FROM cz_devl_projects
78: WHERE deleted_flag = '0'
79: AND devl_project_id NOT IN (SELECT object_id FROM cz_rp_entries
80: WHERE object_type = 'PRJ'
81: AND deleted_flag = '0');
82:
83: begin

Line 153: FOR i IN (SELECT object_id FROM CZ_RP_ENTRIES

149: PROCEDURE collect_Folders(p_folder_id IN NUMBER) IS
150: l_folders_exist BOOLEAN := FALSE;
151: BEGIN
152:
153: FOR i IN (SELECT object_id FROM CZ_RP_ENTRIES
154: WHERE enclosing_folder=p_folder_id AND object_type='FLD')
155: LOOP
156: l_folders_exist := TRUE;
157: collect_Folders(i.object_id);

Line 175: FROM CZ_RP_ENTRIES

171: BEGIN
172:
173: SELECT object_id, object_type
174: BULK COLLECT INTO l_object_id_tbl, l_object_type_tbl
175: FROM CZ_RP_ENTRIES
176: WHERE enclosing_folder=p_folder_id;
177:
178: IF l_object_id_tbl.COUNT>0 THEN
179: FORALL i IN l_object_id_tbl.First..l_object_id_tbl.Last

Line 180: DELETE FROM CZ_RP_ENTRIES

176: WHERE enclosing_folder=p_folder_id;
177:
178: IF l_object_id_tbl.COUNT>0 THEN
179: FORALL i IN l_object_id_tbl.First..l_object_id_tbl.Last
180: DELETE FROM CZ_RP_ENTRIES
181: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i);
182: END IF;
183:
184: DELETE FROM CZ_RP_ENTRIES

Line 184: DELETE FROM CZ_RP_ENTRIES

180: DELETE FROM CZ_RP_ENTRIES
181: WHERE object_id=l_object_id_tbl(i) AND object_type=l_object_type_tbl(i);
182: END IF;
183:
184: DELETE FROM CZ_RP_ENTRIES
185: WHERE object_id=p_folder_id AND object_type='FLD'
186: RETURNING enclosing_folder INTO x_enclosing_folder;
187:
188: END update_Objects_In_Folder;

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

192: BEGIN
193:
194: update_Objects_In_Folder(p_folder_id, l_enclosing_folder);
195:
196: FOR i IN (SELECT object_id, enclosing_folder FROM CZ_RP_ENTRIES
197: WHERE object_id=l_enclosing_folder AND object_type='FLD')
198: LOOP
199: -- we should stop on this folder
200: IF i.object_id=p_subroot_folder_id THEN

Line 212: FOR i IN(SELECT object_id FROM CZ_RP_ENTRIES

208: END goto_Folder;
209:
210: BEGIN
211:
212: FOR i IN(SELECT object_id FROM CZ_RP_ENTRIES
213: WHERE object_type='FLD' AND deleted_flag='1')
214: LOOP
215: --
216: -- array l_end_folder_ids_tbl will contain all subfolders

Line 232: -- and update CZ_RP_ENTRIES level by level

228: END IF;
229:
230: --
231: -- go up from folders which have no subfolders ( array l_end_folder_ids_tbl )
232: -- and update CZ_RP_ENTRIES level by level
233: --
234: FOR k IN l_end_folder_ids_tbl.First..l_end_folder_ids_tbl.Last
235: LOOP
236: IF l_end_folder_ids_tbl(k) <> i.object_id THEN

Line 241: DELETE FROM CZ_RP_ENTRIES

237: goto_Folder(l_end_folder_ids_tbl(k), i.object_id);
238: END IF;
239: END LOOP;
240:
241: DELETE FROM CZ_RP_ENTRIES
242: WHERE enclosing_folder=i.object_id;
243:
244: DELETE FROM CZ_RP_ENTRIES
245: WHERE object_id=i.object_id AND object_type='FLD';

Line 244: DELETE FROM CZ_RP_ENTRIES

240:
241: DELETE FROM CZ_RP_ENTRIES
242: WHERE enclosing_folder=i.object_id;
243:
244: DELETE FROM CZ_RP_ENTRIES
245: WHERE object_id=i.object_id AND object_type='FLD';
246:
247: END LOOP;
248: