APPS.AP_PURGE_PKG dependencies on CHV_HISTORY_SCHEDULES

Line 2618: chv_history_schedules chs

2614: from sys.dual
2615: where exists (select null
2616: from chv_schedule_items csi,
2617: chv_schedule_headers csh,
2618: chv_history_schedules chs
2619: where csi.item_id = chs.item_id
2620: and csi.schedule_id = chs.schedule_id
2621: and csh.schedule_id = chs.schedule_id
2622: and csh.vendor_id = chs.vendor_id

Line 2638: insert into chv_history_schedules

2634: Print('(Schedule_Org_Summary)'||debug_info);
2635: END IF;
2636:
2637: -- summarize_schedules_by_org
2638: insert into chv_history_schedules
2639: (schedule_id,
2640: vendor_id,
2641: vendor_site_id,
2642: schedule_type,

Line 7326: delete from chv_history_schedules

7322:
7323: *==========================================================================*/
7324: FUNCTION CLEAR_CHV_CUM_HISTORY RETURN BOOLEAN IS
7325: BEGIN
7326: delete from chv_history_schedules
7327: where purge_name = g_purge_name;
7328:
7329: delete from chv_history_cum_periods
7330: where purge_name = g_purge_name;

Line 7369: delete from chv_history_schedules

7365: *==========================================================================*/
7366: FUNCTION CLEAR_CHV_SCHED_HISTORY RETURN BOOLEAN IS
7367: BEGIN
7368:
7369: delete from chv_history_schedules
7370: where purge_name = g_purge_name;
7371:
7372: RETURN (TRUE);
7373: