APPS.AZW_FLOW dependencies on AZ_PROCESSES

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 247: DELETE from az_processes ap

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
249: (SELECT item_type from AZ_PRODUCT_FLOWS apf
250: where apf.item_type = ap.item_type)
251: OR not exists

Line 262: fnd_message.set_token('AZW_ERROR_STMT','delete from az_processes');

258: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
259: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
260: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
261: fnd_message.set_token('AZW_ERROR_PROC','azw_flow.populate_product_flows');
262: fnd_message.set_token('AZW_ERROR_STMT','delete from az_processes');
263: APP_EXCEPTION.RAISE_EXCEPTION;
264: END;
265:
266: COMMIT;