APPS.AZW_FLOW dependencies on AZ_PRODUCT_FLOWS

Line 47: -- Retrieve all workflow processes and store them in AZ_PRODUCT_FLOWS.

43: --
44: -- POPULATE_PRODUCT_FLOWS
45: --
46: -- Public procedure.
47: -- Retrieve all workflow processes and store them in AZ_PRODUCT_FLOWS.
48: --
49:
50: PROCEDURE populate_product_flows IS
51:

Line 153: FROM az_product_flows;

149:
150: BEGIN
151:
152: DELETE
153: FROM az_product_flows;
154: COMMIT;
155: -- populate defaults of phase 1 for all installed products into
156: -- az_product_phases
157:

Line 208: --DBMS_OUTPUT.PUT_LINE('application id: into az_product_flows ' ||

204: v_application_id :=
205: AZW_PROC.parse_application_ids(v_application_ids, id_count);
206:
207: WHILE (v_application_id > -1) LOOP
208: --DBMS_OUTPUT.PUT_LINE('application id: into az_product_flows ' ||
209: --v_application_id);
210:
211: INSERT INTO az_product_flows(application_id, item_type, process_name,
212: display_order, context_type, parent_id, process_type)

Line 211: INSERT INTO az_product_flows(application_id, item_type, process_name,

207: WHILE (v_application_id > -1) LOOP
208: --DBMS_OUTPUT.PUT_LINE('application id: into az_product_flows ' ||
209: --v_application_id);
210:
211: INSERT INTO az_product_flows(application_id, item_type, process_name,
212: display_order, context_type, parent_id, process_type)
213: VALUES(v_application_id, v_item_type, v_process_name,
214: v_display_number , v_ctxt_type, v_parent_id,
215: NVL(v_process_type,'IMP'));

Line 244: --Do a clean-up of AZ_PROCESSES for processes not in AZ_PRODUCT_FLOWS

240: fnd_message.set_token('AZW_ERROR_STMT','CURSOR processes_cursor');
241: APP_EXCEPTION.RAISE_EXCEPTION;
242: END;
243:
244: --Do a clean-up of AZ_PROCESSES for processes not in AZ_PRODUCT_FLOWS
245:
246: BEGIN
247: DELETE from az_processes ap
248: WHERE not exists

Line 249: (SELECT item_type from AZ_PRODUCT_FLOWS apf

245:
246: BEGIN
247: DELETE from az_processes ap
248: WHERE not exists
249: (SELECT item_type from AZ_PRODUCT_FLOWS apf
250: where apf.item_type = ap.item_type)
251: OR not exists
252: (SELECT process_name from AZ_PRODUCT_FLOWS apf
253: where apf.process_name = ap.process_name);

Line 252: (SELECT process_name from AZ_PRODUCT_FLOWS apf

248: WHERE not exists
249: (SELECT item_type from AZ_PRODUCT_FLOWS apf
250: where apf.item_type = ap.item_type)
251: OR not exists
252: (SELECT process_name from AZ_PRODUCT_FLOWS apf
253: where apf.process_name = ap.process_name);
254: EXCEPTION
255: WHEN app_exception.application_exception THEN
256: RAISE;