APPS.AP_PURGE_PKG dependencies on CHV_HISTORY_SCHEDULES

Line 2363: chv_history_schedules chs

2359: from sys.dual
2360: where exists (select null
2361: from chv_schedule_items csi,
2362: chv_schedule_headers csh,
2363: chv_history_schedules chs
2364: where csi.item_id = chs.item_id
2365: and csi.schedule_id = chs.schedule_id
2366: and csh.schedule_id = chs.schedule_id
2367: and csh.vendor_id = chs.vendor_id

Line 2383: insert into chv_history_schedules

2379: Print('(Schedule_Org_Summary)'||debug_info);
2380: END IF;
2381:
2382: -- summarize_schedules_by_org
2383: insert into chv_history_schedules
2384: (schedule_id,
2385: vendor_id,
2386: vendor_site_id,
2387: schedule_type,

Line 6619: delete from chv_history_schedules

6615:
6616: *==========================================================================*/
6617: FUNCTION CLEAR_CHV_CUM_HISTORY RETURN BOOLEAN IS
6618: BEGIN
6619: delete from chv_history_schedules
6620: where purge_name = g_purge_name;
6621:
6622: delete from chv_history_cum_periods
6623: where purge_name = g_purge_name;

Line 6662: delete from chv_history_schedules

6658: *==========================================================================*/
6659: FUNCTION CLEAR_CHV_SCHED_HISTORY RETURN BOOLEAN IS
6660: BEGIN
6661:
6662: delete from chv_history_schedules
6663: where purge_name = g_purge_name;
6664:
6665: RETURN (TRUE);
6666: