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.FLM_PURGE dependencies on WIP_FLOW_SCHEDULES

Line 260: DELETE FROM WIP_FLOW_SCHEDULES

256: delete_exe_tables (arg_wip_entity_id, arg_org_id);
257:
258: l_stmt_num := 485;
259:
260: DELETE FROM WIP_FLOW_SCHEDULES
261: WHERE WIP_ENTITY_ID = arg_wip_entity_id;
262:
263: l_stmt_num := 490;
264:

Line 316: FROM wip_flow_schedules wfs

312: wfs.scheduled_completion_date ,
313: wfs.date_closed,
314: wfs.organization_id,
315: wfs.auto_replenish /* Added for Enhancement #2829204 */
316: FROM wip_flow_schedules wfs
317: WHERE wfs.organization_id = arg_org_id
318: AND wfs.scheduled_completion_date <= p_cutoff_date
319: AND (arg_line is null or wfs.line_id = to_number(arg_line) )
320: AND wfs.primary_item_id = nvl(arg_assembly,wfs.primary_item_id);

Line 322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;

318: AND wfs.scheduled_completion_date <= p_cutoff_date
319: AND (arg_line is null or wfs.line_id = to_number(arg_line) )
320: AND wfs.primary_item_id = nvl(arg_assembly,wfs.primary_item_id);
321:
322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;

Line 323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;

319: AND (arg_line is null or wfs.line_id = to_number(arg_line) )
320: AND wfs.primary_item_id = nvl(arg_assembly,wfs.primary_item_id);
321:
322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;

Line 324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;

320: AND wfs.primary_item_id = nvl(arg_assembly,wfs.primary_item_id);
321:
322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;
328: l_account_close_date DATE;

Line 325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;

321:
322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;
328: l_account_close_date DATE;
329: l_organization_id WIP_FLOW_SCHEDULES.ORGANIZATION_ID%TYPE;

Line 326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;

322: l_wip_entity_id WIP_FLOW_SCHEDULES.WIP_ENTITY_ID%TYPE;
323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;
328: l_account_close_date DATE;
329: l_organization_id WIP_FLOW_SCHEDULES.ORGANIZATION_ID%TYPE;
330: l_table_name VARCHAR2(500);

Line 327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;

323: l_schedule_number WIP_FLOW_SCHEDULES.SCHEDULE_NUMBER%TYPE;
324: l_status WIP_FLOW_SCHEDULES.STATUS%TYPE;
325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;
328: l_account_close_date DATE;
329: l_organization_id WIP_FLOW_SCHEDULES.ORGANIZATION_ID%TYPE;
330: l_table_name VARCHAR2(500);
331: l_tot_rec_purge NUMBER := G_ZERO;

Line 329: l_organization_id WIP_FLOW_SCHEDULES.ORGANIZATION_ID%TYPE;

325: l_primary_item_id WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID%TYPE;
326: l_close_date WIP_FLOW_SCHEDULES.DATE_CLOSED%TYPE;
327: l_completion_date WIP_FLOW_SCHEDULES.SCHEDULED_COMPLETION_DATE%TYPE;
328: l_account_close_date DATE;
329: l_organization_id WIP_FLOW_SCHEDULES.ORGANIZATION_ID%TYPE;
330: l_table_name VARCHAR2(500);
331: l_tot_rec_purge NUMBER := G_ZERO;
332: l_records_deleted NUMBER := G_ZERO;
333: l_flag BOOLEAN ;

Line 336: l_auto_replenish WIP_FLOW_SCHEDULES.AUTO_REPLENISH%TYPE;

332: l_records_deleted NUMBER := G_ZERO;
333: l_flag BOOLEAN ;
334: l_return_value NUMBER := G_ZERO;
335: l_stmt_num NUMBER := G_ZERO;
336: l_auto_replenish WIP_FLOW_SCHEDULES.AUTO_REPLENISH%TYPE;
337: l_cutoff_date DATE;
338: l_line_code VARCHAR2(10);
339:
340: Begin