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.AP_PURGE_PKG dependencies on CHV_PURGE_SCHEDULE_LIST

Line 345: delete from chv_purge_schedule_list cpsl

341:
342: --
343: -- test_chv_in_cum
344:
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,

Line 396: delete from chv_purge_schedule_list cpsl

392:
393: --
394: -- test_chv_in_edi
395:
396: delete from chv_purge_schedule_list cpsl
397: where exists (select null
398: from chv_schedule_items csi,
399: ece_spso_items esi
400: where csi.schedule_item_id = cpsl.schedule_item_id

Line 1302: insert into chv_purge_schedule_list

1298: IF g_debug_switch in ('y','Y') THEN
1299: Print('(seed_chv_by_cum)' ||debug_info);
1300: END IF;
1301:
1302: insert into chv_purge_schedule_list
1303: (schedule_item_id,
1304: purge_name,
1305: double_check_flag)
1306: select csi.schedule_item_id,

Line 1355: insert into chv_purge_schedule_list

1351: Print('(seed_chv_by_org)' ||debug_info);
1352: END IF;
1353:
1354: --
1355: insert into chv_purge_schedule_list
1356: (schedule_item_id,
1357: purge_name,
1358: double_check_flag)
1359: select csi.schedule_item_id,

Line 2413: from chv_purge_schedule_list cpsl,

2409: csh.schedule_status,
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

Line 2539: from chv_purge_schedule_list

2535: -- get_chv_range
2536: select nvl(min(schedule_item_id),-1),
2537: nvl(max(schedule_item_id),-1)
2538: into p_chv_lower_limit, p_chv_upper_limit
2539: from chv_purge_schedule_list
2540: where double_check_flag = 'Y';
2541:
2542: --
2543: debug_info := 'End Get_Ranges';

Line 3673: update chv_purge_schedule_list cpsl

3669: END IF;
3670:
3671: --
3672:
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

Line 3734: update chv_purge_schedule_list cpsl

3730: END IF;
3731:
3732: --
3733:
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,

Line 3783: update chv_purge_schedule_list cpsl

3779: Print('(Retest_Chv_in_Cum)'||debug_info);
3780: END IF;
3781:
3782: --
3783: update chv_purge_schedule_list cpsl
3784: set double_check_flag = 'N'
3785: where cpsl.double_check_flag = 'Y'
3786: and exists (select null
3787: from chv_cum_periods ccp,

Line 3835: update chv_purge_schedule_list cpsl

3831: Print('(Retest_Chv_in_edi)'||debug_info);
3832: END IF;
3833:
3834: --
3835: update chv_purge_schedule_list cpsl
3836: set double_check_flag = 'N'
3837: where cpsl.double_check_flag = 'Y'
3838: and exists (select null
3839: from chv_schedule_items csi,

Line 5542: FROM chv_purge_schedule_list

5538: l_count number := 0;
5539:
5540: CURSOR range (low_chv_id IN NUMBER) IS
5541: SELECT schedule_item_id
5542: FROM chv_purge_schedule_list
5543: WHERE double_check_flag = 'Y'
5544: and schedule_item_id > low_chv_id
5545: ORDER BY schedule_item_id asc;
5546:

Line 5576: from chv_purge_schedule_list

5572:
5573: select nvl(min(schedule_item_id),-1)
5574: , nvl(max(schedule_item_id),-1)
5575: into range_low, range_high
5576: from chv_purge_schedule_list
5577: where double_check_flag = 'Y';
5578:
5579:
5580: OPEN range(range_low); --Bug2711759

Line 5603: from chv_purge_schedule_list cpsl

5599: update chv_schedule_items csi
5600: set csi.item_purge_status = 'PURGED'
5601: where exists
5602: (select null
5603: from chv_purge_schedule_list cpsl
5604: where cpsl.schedule_item_id = csi.schedule_item_id
5605: and cpsl.double_check_flag = 'Y'
5606: and cpsl.schedule_item_id between range_low and range_high);
5607:

Line 5618: from chv_purge_schedule_list cpsl

5614:
5615: delete from chv_item_orders cio
5616: where exists
5617: (select null
5618: from chv_purge_schedule_list cpsl
5619: where cpsl.schedule_item_id = cio.schedule_item_id
5620: and cpsl.double_check_flag = 'Y'
5621: and cpsl.schedule_item_id between range_low and range_high);
5622:

Line 5633: from chv_purge_schedule_list cpsl

5629:
5630: delete from chv_horizontal_Schedules chs
5631: where exists
5632: (select null
5633: from chv_purge_schedule_list cpsl
5634: where cpsl.schedule_item_id = chs.schedule_item_id
5635: and cpsl.double_check_flag = 'Y'
5636: and cpsl.schedule_item_id between range_low and range_high);
5637:

Line 5648: from chv_purge_schedule_list cpsl

5644:
5645: delete from chv_authorizations ca
5646: where exists
5647: (select null
5648: from chv_purge_schedule_list cpsl
5649: where cpsl.schedule_item_id = ca.reference_id
5650: and ca.reference_type = 'SCHEDULE_ITEMS'
5651: and cpsl.double_check_flag = 'Y'
5652: and cpsl.schedule_item_id between range_low and range_high);

Line 5784: FROM chv_purge_schedule_list

5780: l_count number := 0;
5781:
5782: CURSOR range (low_chv_id IN NUMBER) IS
5783: SELECT schedule_item_id
5784: FROM chv_purge_schedule_list
5785: WHERE double_check_flag = 'Y'
5786: and schedule_item_id > low_chv_id
5787: ORDER BY schedule_item_id asc;
5788:

Line 5818: from chv_purge_schedule_list

5814:
5815: select nvl(min(schedule_item_id),-1)
5816: , nvl(max(schedule_item_id),-1)
5817: into range_low, range_high
5818: from chv_purge_schedule_list
5819: where double_check_flag = 'Y';
5820:
5821: OPEN range(range_low); --Bug2711759
5822: WHILE l_count < g_range_size

Line 5842: from chv_purge_schedule_list cpsl

5838: update chv_schedule_items csi
5839: set csi.item_purge_status = 'PURGED'
5840: where exists
5841: (select null
5842: from chv_purge_schedule_list cpsl
5843: where cpsl.schedule_item_id = csi.schedule_item_id
5844: and cpsl.double_check_flag = 'Y'
5845: and cpsl.schedule_item_id between range_low and range_high);
5846:

Line 5857: from chv_purge_schedule_list cpsl

5853:
5854: delete from chv_item_orders cio
5855: where exists
5856: (select null
5857: from chv_purge_schedule_list cpsl
5858: where cpsl.schedule_item_id = cio.schedule_item_id
5859: and cpsl.double_check_flag = 'Y'
5860: and cpsl.schedule_item_id between range_low and range_high);
5861:

Line 5872: from chv_purge_schedule_list cpsl

5868:
5869: delete from chv_horizontal_Schedules chs
5870: where exists
5871: (select null
5872: from chv_purge_schedule_list cpsl
5873: where cpsl.schedule_item_id = chs.schedule_item_id
5874: and cpsl.double_check_flag = 'Y'
5875: and cpsl.schedule_item_id between range_low and range_high);
5876:

Line 5887: from chv_purge_schedule_list cpsl

5883:
5884: delete from chv_authorizations ca
5885: where exists
5886: (select null
5887: from chv_purge_schedule_list cpsl
5888: where cpsl.schedule_item_id = ca.reference_id
5889: and ca.reference_type = 'SCHEDULE_ITEMS'
5890: and cpsl.double_check_flag = 'Y'
5891: and cpsl.schedule_item_id between range_low and range_high);

Line 6563: delete from chv_purge_schedule_list;

6559: -- clear_vendor_purge_list
6560: delete from po_purge_vendor_list;
6561:
6562: -- clear_schedule_list
6563: delete from chv_purge_schedule_list;
6564:
6565: -- clear_cum_list
6566: delete from chv_purge_cum_list;
6567:

Line 6642: delete from chv_purge_schedule_list;

6638: *==========================================================================*/
6639: FUNCTION CLEAR_CHV_CUM_LIST RETURN BOOLEAN IS
6640: BEGIN
6641:
6642: delete from chv_purge_schedule_list;
6643: delete from chv_purge_cum_list;
6644:
6645: RETURN (TRUE);
6646:

Line 6683: delete from chv_purge_schedule_list;

6679: FUNCTION clear_chv_sched_list RETURN BOOLEAN IS
6680:
6681: BEGIN
6682:
6683: delete from chv_purge_schedule_list;
6684:
6685: RETURN (TRUE);
6686:
6687: RETURN NULL; EXCEPTION