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 357: delete from chv_purge_schedule_list cpsl

353:
354: --
355: -- test_chv_in_cum
356:
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,

Line 408: delete from chv_purge_schedule_list cpsl

404:
405: --
406: -- test_chv_in_edi
407:
408: delete from chv_purge_schedule_list cpsl
409: where exists (select null
410: from chv_schedule_items csi,
411: ece_spso_items esi
412: where csi.schedule_item_id = cpsl.schedule_item_id

Line 1466: insert into chv_purge_schedule_list

1462: IF g_debug_switch in ('y','Y') THEN
1463: Print('(seed_chv_by_cum)' ||debug_info);
1464: END IF;
1465:
1466: insert into chv_purge_schedule_list
1467: (schedule_item_id,
1468: purge_name,
1469: double_check_flag)
1470: select csi.schedule_item_id,

Line 1519: insert into chv_purge_schedule_list

1515: Print('(seed_chv_by_org)' ||debug_info);
1516: END IF;
1517:
1518: --
1519: insert into chv_purge_schedule_list
1520: (schedule_item_id,
1521: purge_name,
1522: double_check_flag)
1523: select csi.schedule_item_id,

Line 2668: from chv_purge_schedule_list cpsl,

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

Line 2794: from chv_purge_schedule_list

2790: -- get_chv_range
2791: select nvl(min(schedule_item_id),-1),
2792: nvl(max(schedule_item_id),-1)
2793: into p_chv_lower_limit, p_chv_upper_limit
2794: from chv_purge_schedule_list
2795: where double_check_flag = 'Y';
2796:
2797: --
2798: debug_info := 'End Get_Ranges';

Line 4177: update chv_purge_schedule_list cpsl

4173: END IF;
4174:
4175: --
4176:
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

Line 4238: update chv_purge_schedule_list cpsl

4234: END IF;
4235:
4236: --
4237:
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,

Line 4287: update chv_purge_schedule_list cpsl

4283: Print('(Retest_Chv_in_Cum)'||debug_info);
4284: END IF;
4285:
4286: --
4287: update chv_purge_schedule_list cpsl
4288: set double_check_flag = 'N'
4289: where cpsl.double_check_flag = 'Y'
4290: and exists (select null
4291: from chv_cum_periods ccp,

Line 4339: update chv_purge_schedule_list cpsl

4335: Print('(Retest_Chv_in_edi)'||debug_info);
4336: END IF;
4337:
4338: --
4339: update chv_purge_schedule_list cpsl
4340: set double_check_flag = 'N'
4341: where cpsl.double_check_flag = 'Y'
4342: and exists (select null
4343: from chv_schedule_items csi,

Line 6102: FROM chv_purge_schedule_list

6098: l_count number := 0;
6099:
6100: CURSOR range (low_chv_id IN NUMBER) IS
6101: SELECT schedule_item_id
6102: FROM chv_purge_schedule_list
6103: WHERE double_check_flag = 'Y'
6104: and schedule_item_id > low_chv_id
6105: ORDER BY schedule_item_id asc;
6106:

Line 6136: from chv_purge_schedule_list

6132:
6133: select nvl(min(schedule_item_id),-1)
6134: , nvl(max(schedule_item_id),-1)
6135: into range_low, range_high
6136: from chv_purge_schedule_list
6137: where double_check_flag = 'Y';
6138:
6139:
6140: OPEN range(range_low); --Bug2711759

Line 6163: from chv_purge_schedule_list cpsl

6159: update chv_schedule_items csi
6160: set csi.item_purge_status = 'PURGED'
6161: where exists
6162: (select null
6163: from chv_purge_schedule_list cpsl
6164: where cpsl.schedule_item_id = csi.schedule_item_id
6165: and cpsl.double_check_flag = 'Y'
6166: and cpsl.schedule_item_id between range_low and range_high);
6167:

Line 6178: from chv_purge_schedule_list cpsl

6174:
6175: delete from chv_item_orders cio
6176: where exists
6177: (select null
6178: from chv_purge_schedule_list cpsl
6179: where cpsl.schedule_item_id = cio.schedule_item_id
6180: and cpsl.double_check_flag = 'Y'
6181: and cpsl.schedule_item_id between range_low and range_high);
6182:

Line 6193: from chv_purge_schedule_list cpsl

6189:
6190: delete from chv_horizontal_Schedules chs
6191: where exists
6192: (select null
6193: from chv_purge_schedule_list cpsl
6194: where cpsl.schedule_item_id = chs.schedule_item_id
6195: and cpsl.double_check_flag = 'Y'
6196: and cpsl.schedule_item_id between range_low and range_high);
6197:

Line 6208: from chv_purge_schedule_list cpsl

6204:
6205: delete from chv_authorizations ca
6206: where exists
6207: (select null
6208: from chv_purge_schedule_list cpsl
6209: where cpsl.schedule_item_id = ca.reference_id
6210: and ca.reference_type = 'SCHEDULE_ITEMS'
6211: and cpsl.double_check_flag = 'Y'
6212: and cpsl.schedule_item_id between range_low and range_high);

Line 6344: FROM chv_purge_schedule_list

6340: l_count number := 0;
6341:
6342: CURSOR range (low_chv_id IN NUMBER) IS
6343: SELECT schedule_item_id
6344: FROM chv_purge_schedule_list
6345: WHERE double_check_flag = 'Y'
6346: and schedule_item_id > low_chv_id
6347: ORDER BY schedule_item_id asc;
6348:

Line 6378: from chv_purge_schedule_list

6374:
6375: select nvl(min(schedule_item_id),-1)
6376: , nvl(max(schedule_item_id),-1)
6377: into range_low, range_high
6378: from chv_purge_schedule_list
6379: where double_check_flag = 'Y';
6380:
6381: OPEN range(range_low); --Bug2711759
6382: WHILE l_count < g_range_size

Line 6402: from chv_purge_schedule_list cpsl

6398: update chv_schedule_items csi
6399: set csi.item_purge_status = 'PURGED'
6400: where exists
6401: (select null
6402: from chv_purge_schedule_list cpsl
6403: where cpsl.schedule_item_id = csi.schedule_item_id
6404: and cpsl.double_check_flag = 'Y'
6405: and cpsl.schedule_item_id between range_low and range_high);
6406:

Line 6417: from chv_purge_schedule_list cpsl

6413:
6414: delete from chv_item_orders cio
6415: where exists
6416: (select null
6417: from chv_purge_schedule_list cpsl
6418: where cpsl.schedule_item_id = cio.schedule_item_id
6419: and cpsl.double_check_flag = 'Y'
6420: and cpsl.schedule_item_id between range_low and range_high);
6421:

Line 6432: from chv_purge_schedule_list cpsl

6428:
6429: delete from chv_horizontal_Schedules chs
6430: where exists
6431: (select null
6432: from chv_purge_schedule_list cpsl
6433: where cpsl.schedule_item_id = chs.schedule_item_id
6434: and cpsl.double_check_flag = 'Y'
6435: and cpsl.schedule_item_id between range_low and range_high);
6436:

Line 6447: from chv_purge_schedule_list cpsl

6443:
6444: delete from chv_authorizations ca
6445: where exists
6446: (select null
6447: from chv_purge_schedule_list cpsl
6448: where cpsl.schedule_item_id = ca.reference_id
6449: and ca.reference_type = 'SCHEDULE_ITEMS'
6450: and cpsl.double_check_flag = 'Y'
6451: and cpsl.schedule_item_id between range_low and range_high);

Line 7270: delete from chv_purge_schedule_list;

7266: -- clear_vendor_purge_list
7267: delete from po_purge_vendor_list;
7268:
7269: -- clear_schedule_list
7270: delete from chv_purge_schedule_list;
7271:
7272: -- clear_cum_list
7273: delete from chv_purge_cum_list;
7274:

Line 7349: delete from chv_purge_schedule_list;

7345: *==========================================================================*/
7346: FUNCTION CLEAR_CHV_CUM_LIST RETURN BOOLEAN IS
7347: BEGIN
7348:
7349: delete from chv_purge_schedule_list;
7350: delete from chv_purge_cum_list;
7351:
7352: RETURN (TRUE);
7353:

Line 7390: delete from chv_purge_schedule_list;

7386: FUNCTION clear_chv_sched_list RETURN BOOLEAN IS
7387:
7388: BEGIN
7389:
7390: delete from chv_purge_schedule_list;
7391:
7392: RETURN (TRUE);
7393:
7394: RETURN NULL; EXCEPTION