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_CUM_PERIODS

Line 359: from chv_cum_periods ccp,

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,
362: chv_org_options coo
363: where ccp.organization_id = g_organization_id

Line 1456: from chv_cum_periods ccp

1452: double_check_flag)
1453: select ccp.cum_period_id,
1454: p_purge_name,
1455: 'Y'
1456: from chv_cum_periods ccp
1457: where ccp.organization_id = g_organization_id
1458: and NVL(ccp.cum_period_end_date, sysdate + 1) <= g_activity_date
1459: and NVL(ccp.cum_period_end_date,sysdate + 1) < sysdate;
1460:

Line 1476: chv_cum_periods ccp

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
1479: and ccp.cum_period_end_date
1480: and ccp.cum_period_id = cpcl.cum_period_id

Line 2694: from chv_cum_periods ccp,

2690: select MAX('Y')
2691: into range_inserted
2692: from sys.dual
2693: where exists (select null
2694: from chv_cum_periods ccp,
2695: chv_history_cum_periods chcp
2696: where ccp.cum_period_id = chcp.cum_period_id
2697: and chcp.purge_name = p_purge_name);
2698:

Line 2719: chv_cum_periods ccp

2715: ccp.cum_period_end_date,
2716: ccp.creation_date,
2717: p_purge_name
2718: from chv_purge_cum_list cpcl,
2719: chv_cum_periods ccp
2720: where cpcl.cum_period_id = ccp.cum_period_id
2721: and cpcl.double_check_flag = 'Y';
2722: COMMIT;
2723: end if;

Line 4225: and not exists (select null from chv_cum_periods ccp

4221:
4222: update chv_purge_cum_list cpcl
4223: set double_check_flag = 'N'
4224: where cpcl.double_check_flag = 'Y'
4225: and not exists (select null from chv_cum_periods ccp
4226: where ccp.organization_id = g_organization_id
4227: and NVL(ccp.cum_period_end_date, sysdate + 1) <= g_activity_date
4228: and NVL(ccp.cum_period_end_date,sysdate + 1) < sysdate
4229: and ccp.cum_period_id = cpcl.cum_period_id);

Line 4243: chv_cum_periods ccp,

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
4247: and ccp.cum_period_end_date

Line 4291: from chv_cum_periods ccp,

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,
4292: chv_schedule_items csi,
4293: chv_schedule_headers csh,
4294: chv_org_options coo
4295: where ccp.organization_id = g_organization_id

Line 4423: FROM chv_cum_periods;

4419:
4420: --
4421: SELECT count(*)
4422: INTO chv_cum_rows
4423: FROM chv_cum_periods;
4424: --
4425:
4426: debug_info := 'chv_hor';
4427: IF g_debug_switch in ('y','Y') THEN

Line 4543: chv_cum_periods = fp_chv_cum_rows,

4539: po_asl_attributes = fp_po_asl_attr_rows,
4540: po_asl_documents = fp_po_asl_doc_rows,
4541: chv_authorizations = fp_chv_auth_rows,
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,

Line 6264: debug_info := 'chv_cum_periods';

6260: from chv_purge_cum_list cpcl
6261: where cpcl.cum_period_id = cca.cum_period_id
6262: and cpcl.double_check_flag = 'Y');
6263:
6264: debug_info := 'chv_cum_periods';
6265: IF g_debug_switch in ('y','Y') THEN
6266: Print('(Purge_Schedules_by_Cum)'||debug_info);
6267: END IF;
6268:

Line 6269: -- delete_chv_cum_periods

6265: IF g_debug_switch in ('y','Y') THEN
6266: Print('(Purge_Schedules_by_Cum)'||debug_info);
6267: END IF;
6268:
6269: -- delete_chv_cum_periods
6270:
6271: delete from chv_cum_periods ccp
6272: where exists
6273: (select null

Line 6271: delete from chv_cum_periods ccp

6267: END IF;
6268:
6269: -- delete_chv_cum_periods
6270:
6271: delete from chv_cum_periods ccp
6272: where exists
6273: (select null
6274: from chv_purge_cum_list cpcl
6275: where cpcl.cum_period_id = ccp.cum_period_id

Line 7206: chv_cum_periods = nvl(chv_cum_periods,0) - chv_cum_rows,

7202: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_rows,
7203: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
7204: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
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,