[Home] [Help]
357: delete from chv_purge_schedule_list cpsl
358: where exists (select null
359: from chv_cum_periods ccp,
360: chv_schedule_items csi,
361: chv_schedule_headers csh,
362: chv_org_options coo
363: where ccp.organization_id = g_organization_id
364: and sysdate between ccp.cum_period_start_date and
365: NVL(ccp.cum_period_end_date,sysdate + 1)
1470: select csi.schedule_item_id,
1471: p_purge_name,
1472: 'Y'
1473: from chv_schedule_items csi,
1474: chv_schedule_headers csh,
1475: chv_purge_cum_list cpcl,
1476: chv_cum_periods ccp
1477: where csh.schedule_id = csi.schedule_id
1478: and csh.schedule_horizon_start between ccp.cum_period_start_date
1523: select csi.schedule_item_id,
1524: p_purge_name,
1525: 'Y'
1526: from chv_schedule_items csi,
1527: chv_schedule_headers csh
1528: where csh.schedule_id = csi.schedule_id
1529: and csh.last_update_date <= g_activity_date
1530: and NVL(csi.item_purge_status,'N') <> 'PURGED'
1531: and csi.organization_id = g_organization_id;
1923: END IF;
1924:
1925: delete from po_purge_vendor_list pvl
1926: where exists (select null
1927: from chv_schedule_headers csh
1928: where csh.vendor_id = pvl.vendor_id);
1929: end if;
1930:
1931: -- check_vendors_in_edi
2613: into range_inserted
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
2665: csi.item_id,
2666: csi.organization_id,
2667: p_purge_name
2668: from chv_purge_schedule_list cpsl,
2669: chv_schedule_headers csh,
2670: chv_schedule_items csi
2671: where cpsl.schedule_item_id = csi.schedule_item_id
2672: and csi.schedule_id = csh.schedule_id
2673: and cpsl.double_check_flag = 'Y'
4076: update po_purge_vendor_list pvl
4077: set double_check_flag = 'N'
4078: where pvl.double_check_flag = 'Y'
4079: and (exists (select null
4080: from chv_schedule_headers csh
4081: where csh.vendor_id = pvl.vendor_id));
4082:
4083: end if;
4084:
4177: update chv_purge_schedule_list cpsl
4178: set double_check_flag = 'N'
4179: where cpsl.double_check_flag = 'Y'
4180: and not exists (select 'schedule not purgeable' from chv_schedule_items csi,
4181: chv_schedule_headers csh
4182: where csh.schedule_id = csi.schedule_id
4183: and csh.last_update_date <= g_activity_date
4184: and csi.organization_id = g_organization_id
4185: and csi.schedule_item_id = cpsl.schedule_item_id);
4238: update chv_purge_schedule_list cpsl
4239: set double_check_flag = 'N'
4240: where cpsl.double_check_flag = 'Y'
4241: and not exists (select null from chv_schedule_items csi,
4242: chv_schedule_headers csh,
4243: chv_cum_periods ccp,
4244: chv_purge_cum_list cpcl
4245: where csh.schedule_id = csi.schedule_id
4246: and csh.schedule_horizon_start between ccp.cum_period_start_date
4289: where cpsl.double_check_flag = 'Y'
4290: and exists (select null
4291: from chv_cum_periods ccp,
4292: chv_schedule_items csi,
4293: chv_schedule_headers csh,
4294: chv_org_options coo
4295: where ccp.organization_id = g_organization_id
4296: and sysdate between ccp.cum_period_start_date and
4297: NVL(ccp.cum_period_end_date,sysdate + 1)
4452:
4453: --
4454: SELECT count(*)
4455: INTO chv_head_rows
4456: FROM chv_schedule_headers;
4457: --
4458:
4459: debug_info := 'chv_item';
4460: IF g_debug_switch in ('y','Y') THEN
4542: chv_cum_adjustments = fp_chv_cum_adj_rows,
4543: chv_cum_periods = fp_chv_cum_rows,
4544: chv_horizontal_schedules = fp_chv_hor_rows,
4545: chv_item_orders = fp_chv_ord_rows,
4546: chv_schedule_headers = fp_chv_head_rows,
4547: chv_schedule_items = fp_chv_item_rows,
4548: ap_ae_lines = fp_ae_line_rows,
4549: ap_ae_headers = fp_ae_header_rows,
4550: ap_accounting_events = fp_accounting_event_rows,
6289: from chv_schedule_items cs
6290: where csi.schedule_id = cs.schedule_id
6291: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
6292:
6293: debug_info := 'chv_schedule_headers';
6294: IF g_debug_switch in ('y','Y') THEN
6295: Print('(Purge_Schedules_by_Cum)'||debug_info);
6296: END IF;
6297:
6294: IF g_debug_switch in ('y','Y') THEN
6295: Print('(Purge_Schedules_by_Cum)'||debug_info);
6296: END IF;
6297:
6298: -- delete_chv_schedule_headers
6299:
6300: /* bug2067536 Performance Bug
6301: */
6302: delete from chv_schedule_headers csh
6298: -- delete_chv_schedule_headers
6299:
6300: /* bug2067536 Performance Bug
6301: */
6302: delete from chv_schedule_headers csh
6303: where not exists (select null
6304: from chv_schedule_items csi
6305: where csh.schedule_id = csi.schedule_id );
6306:
6484:
6485: /* bug2067536 Performance Bug
6486: */
6487:
6488: delete from chv_schedule_headers csh
6489: where not exists (select null
6490: from chv_schedule_items csi
6491: where csh.schedule_id = csi.schedule_id );
6492:
7205: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
7206: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
7207: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
7208: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
7209: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
7210: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
7211: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,
7212: ap_ae_headers = nvl(ap_ae_headers,0) - ae_header_rows,
7213: ap_accounting_events = nvl(ap_accounting_events,0) - accounting_event_rows