eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_WF dependencies on ZPB_EXCP_RESULTS

Line 1179: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance

1175: -- This will purge out any ad hoc roles or users I've generated based on the expiration_date
1176: -- set in wf_directory.CreateAdHocRole. This is a standard WF API.
1177: wf_purge.adhocdirectory;
1178:
1179: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
1180:
1181: if ACIDType = 'I' then
1182: delete from zpb_excp_results re
1183: where re.task_id in (select pd.task_id from zpb_process_details_v pd

Line 1182: delete from zpb_excp_results re

1178:
1179: -- Delete task rows from zpb_excp_results, zpb_exp_explanations by instance
1180:
1181: if ACIDType = 'I' then
1182: delete from zpb_excp_results re
1183: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1184: where analysis_cycle_id = inACID);
1185: delete from zpb_excp_explanations ex
1186: where ex.task_id in (select pd.task_id from zpb_process_details_v pd

Line 1192: delete from zpb_excp_results re

1188: else
1189:
1190: for v_instance in c_instances loop
1191: thisInst := v_instance.instance_ac_id;
1192: delete from zpb_excp_results re
1193: where re.task_id in (select pd.task_id from zpb_process_details_v pd
1194: where analysis_cycle_id = thisInst);
1195: delete from zpb_excp_explanations ex
1196: where ex.task_id in (select pd.task_id from zpb_process_details_v pd