[Home] [Help]
345: delete from chv_purge_schedule_list cpsl
346: where exists (select null
347: from chv_cum_periods ccp,
348: chv_schedule_items csi,
349: chv_schedule_headers csh,
350: chv_org_options coo
351: where ccp.organization_id = g_organization_id
352: and sysdate between ccp.cum_period_start_date and
353: NVL(ccp.cum_period_end_date,sysdate + 1)
1306: select csi.schedule_item_id,
1307: p_purge_name,
1308: 'Y'
1309: from chv_schedule_items csi,
1310: chv_schedule_headers csh,
1311: chv_purge_cum_list cpcl,
1312: chv_cum_periods ccp
1313: where csh.schedule_id = csi.schedule_id
1314: and csh.schedule_horizon_start between ccp.cum_period_start_date
1359: select csi.schedule_item_id,
1360: p_purge_name,
1361: 'Y'
1362: from chv_schedule_items csi,
1363: chv_schedule_headers csh
1364: where csh.schedule_id = csi.schedule_id
1365: and csh.last_update_date <= g_activity_date
1366: and NVL(csi.item_purge_status,'N') <> 'PURGED'
1367: and csi.organization_id = g_organization_id;
1681: END IF;
1682:
1683: delete from po_purge_vendor_list pvl
1684: where exists (select null
1685: from chv_schedule_headers csh
1686: where csh.vendor_id = pvl.vendor_id);
1687: end if;
1688:
1689: -- check_vendors_in_edi
2358: into range_inserted
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
2410: csi.item_id,
2411: csi.organization_id,
2412: p_purge_name
2413: from chv_purge_schedule_list cpsl,
2414: chv_schedule_headers csh,
2415: chv_schedule_items csi
2416: where cpsl.schedule_item_id = csi.schedule_item_id
2417: and csi.schedule_id = csh.schedule_id
2418: and cpsl.double_check_flag = 'Y'
3572: update po_purge_vendor_list pvl
3573: set double_check_flag = 'N'
3574: where pvl.double_check_flag = 'Y'
3575: and (exists (select null
3576: from chv_schedule_headers csh
3577: where csh.vendor_id = pvl.vendor_id));
3578:
3579: end if;
3580:
3673: update chv_purge_schedule_list cpsl
3674: set double_check_flag = 'N'
3675: where cpsl.double_check_flag = 'Y'
3676: and not exists (select 'schedule not purgeable' from chv_schedule_items csi,
3677: chv_schedule_headers csh
3678: where csh.schedule_id = csi.schedule_id
3679: and csh.last_update_date <= g_activity_date
3680: and csi.organization_id = g_organization_id
3681: and csi.schedule_item_id = cpsl.schedule_item_id);
3734: update chv_purge_schedule_list cpsl
3735: set double_check_flag = 'N'
3736: where cpsl.double_check_flag = 'Y'
3737: and not exists (select null from chv_schedule_items csi,
3738: chv_schedule_headers csh,
3739: chv_cum_periods ccp,
3740: chv_purge_cum_list cpcl
3741: where csh.schedule_id = csi.schedule_id
3742: and csh.schedule_horizon_start between ccp.cum_period_start_date
3785: where cpsl.double_check_flag = 'Y'
3786: and exists (select null
3787: from chv_cum_periods ccp,
3788: chv_schedule_items csi,
3789: chv_schedule_headers csh,
3790: chv_org_options coo
3791: where ccp.organization_id = g_organization_id
3792: and sysdate between ccp.cum_period_start_date and
3793: NVL(ccp.cum_period_end_date,sysdate + 1)
3948:
3949: --
3950: SELECT count(*)
3951: INTO chv_head_rows
3952: FROM chv_schedule_headers;
3953: --
3954:
3955: debug_info := 'chv_item';
3956: IF g_debug_switch in ('y','Y') THEN
4038: chv_cum_adjustments = fp_chv_cum_adj_rows,
4039: chv_cum_periods = fp_chv_cum_rows,
4040: chv_horizontal_schedules = fp_chv_hor_rows,
4041: chv_item_orders = fp_chv_ord_rows,
4042: chv_schedule_headers = fp_chv_head_rows,
4043: chv_schedule_items = fp_chv_item_rows,
4044: ap_ae_lines = fp_ae_line_rows,
4045: ap_ae_headers = fp_ae_header_rows,
4046: ap_accounting_events = fp_accounting_event_rows,
5729: from chv_schedule_items cs
5730: where csi.schedule_id = cs.schedule_id
5731: and nvl(cs.item_purge_status,'ACTIVE') <> 'PURGED');
5732:
5733: debug_info := 'chv_schedule_headers';
5734: IF g_debug_switch in ('y','Y') THEN
5735: Print('(Purge_Schedules_by_Cum)'||debug_info);
5736: END IF;
5737:
5734: IF g_debug_switch in ('y','Y') THEN
5735: Print('(Purge_Schedules_by_Cum)'||debug_info);
5736: END IF;
5737:
5738: -- delete_chv_schedule_headers
5739:
5740: /* bug2067536 Performance Bug
5741: */
5742: delete from chv_schedule_headers csh
5738: -- delete_chv_schedule_headers
5739:
5740: /* bug2067536 Performance Bug
5741: */
5742: delete from chv_schedule_headers csh
5743: where not exists (select null
5744: from chv_schedule_items csi
5745: where csh.schedule_id = csi.schedule_id );
5746:
5924:
5925: /* bug2067536 Performance Bug
5926: */
5927:
5928: delete from chv_schedule_headers csh
5929: where not exists (select null
5930: from chv_schedule_items csi
5931: where csh.schedule_id = csi.schedule_id );
5932:
6515: chv_cum_adjustments = nvl(chv_cum_adjustments,0) - chv_cum_adj_rows,
6516: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,
6517: chv_horizontal_Schedules = nvl(chv_horizontal_schedules,0) - chv_hor_rows,
6518: chv_item_orders = nvl(chv_item_orders,0) - chv_ord_rows,
6519: chv_schedule_headers = nvl(chv_schedule_headers,0) - chv_head_rows,
6520: chv_schedule_items = nvl(chv_schedule_items,0) - chv_item_rows,
6521: ap_ae_lines = nvl(ap_ae_lines,0) - ae_line_rows,
6522: ap_ae_headers = nvl(ap_ae_headers,0) - ae_header_rows,
6523: ap_accounting_events = nvl(ap_accounting_events,0) - accounting_event_rows