[Home] [Help]
10: cnt number DEFAULT 0;
11: BEGIN
12:
13: SELECT COUNT(*) INTO cnt
14: FROM az_archive aap
15: where aap.node_id = p_node_id;
16:
17: if(cnt = 0) then
18: return TRUE;
31: IS
32: cnt number DEFAULT 0;
33: BEGIN
34: select count(*) into cnt
35: from az_archive_steps aas
36: where aas.item_key = p_item_key
37: and aas.activity_type = p_activity_type
38: and aas.step = p_step
39: and aas.begin_date = p_begin_date;
134: AND fl.lookup_type = 'AZ_PROCESS_STATUS';
135: BEGIN
136: FOR each_group IN all_groups_cursor LOOP
137: if (is_process_notfound(each_group.node_id)) then
138: INSERT INTO az_archive
139: (node_id, node_type
140: ,parent_node_id, node_name
141: ,context_type, context_type_name
142: ,context_id, context_name
157: END LOOP;
158:
159: FOR each_proc IN all_processes_cursor LOOP
160: if (is_process_notfound(each_proc.node_id)) then
161: INSERT INTO az_archive
162: (node_id, node_type
163: ,parent_node_id, node_name
164: ,context_type, context_type_name
165: ,context_id, context_name
182: END LOOP;
183:
184: FOR each_task in all_tasks_cursor LOOP
185: if (is_process_notfound(each_task.node_id)) then
186: INSERT into az_archive
187: (node_id, node_type
188: ,parent_node_id, node_name
189: ,context_type, context_type_name
190: ,context_id, context_name
224: result boolean;
225: BEGIN
226: result :=fnd_release.get_release(rel,rel_info);
227: --DBMS_OUTPUT.PUT_LINE(rel);
228: fnd_profile.put('AZ_ARCHIVE_RELEASE', rel);
229: COMMIT;
230:
231: processes;
232: task_steps;
239: /*------------------------------------------------------------------------
240: * Task_Steps
241: *
242: * Private procedure. To be called by Run to copy the task steps information
243: * into the archive table, az_archive_task_steps.
244: *-----------------------------------------------------------------------*/
245: PROCEDURE Task_Steps IS
246: l_item_type az_tasks_v.item_type%TYPE;
247: l_item_key az_tasks_v.item_key%TYPE;
314: l_item_key := each_task.item_key;
315: FOR each_step in all_steps_cursor LOOP
316: if(is_step_notfound(each_task.item_key, each_step.type
317: ,each_step.name, each_step.begin_date)) then
318: INSERT into az_archive_steps
319: (item_key
320: ,activity_type
321: ,step, step_name
322: ,assigned_user, assigned_user_name