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 347: from chv_cum_periods ccp,

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

Line 1292: from chv_cum_periods ccp

1288: double_check_flag)
1289: select ccp.cum_period_id,
1290: p_purge_name,
1291: 'Y'
1292: from chv_cum_periods ccp
1293: where ccp.organization_id = g_organization_id
1294: and NVL(ccp.cum_period_end_date, sysdate + 1) <= g_activity_date
1295: and NVL(ccp.cum_period_end_date,sysdate + 1) < sysdate;
1296:

Line 1312: chv_cum_periods ccp

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

Line 2439: from chv_cum_periods ccp,

2435: select MAX('Y')
2436: into range_inserted
2437: from sys.dual
2438: where exists (select null
2439: from chv_cum_periods ccp,
2440: chv_history_cum_periods chcp
2441: where ccp.cum_period_id = chcp.cum_period_id
2442: and chcp.purge_name = p_purge_name);
2443:

Line 2464: chv_cum_periods ccp

2460: ccp.cum_period_end_date,
2461: ccp.creation_date,
2462: p_purge_name
2463: from chv_purge_cum_list cpcl,
2464: chv_cum_periods ccp
2465: where cpcl.cum_period_id = ccp.cum_period_id
2466: and cpcl.double_check_flag = 'Y';
2467: COMMIT;
2468: end if;

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

3717:
3718: update chv_purge_cum_list cpcl
3719: set double_check_flag = 'N'
3720: where cpcl.double_check_flag = 'Y'
3721: and not exists (select null from chv_cum_periods ccp
3722: where ccp.organization_id = g_organization_id
3723: and NVL(ccp.cum_period_end_date, sysdate + 1) <= g_activity_date
3724: and NVL(ccp.cum_period_end_date,sysdate + 1) < sysdate
3725: and ccp.cum_period_id = cpcl.cum_period_id);

Line 3739: chv_cum_periods ccp,

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

Line 3787: from chv_cum_periods ccp,

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,
3788: chv_schedule_items csi,
3789: chv_schedule_headers csh,
3790: chv_org_options coo
3791: where ccp.organization_id = g_organization_id

Line 3919: FROM chv_cum_periods;

3915:
3916: --
3917: SELECT count(*)
3918: INTO chv_cum_rows
3919: FROM chv_cum_periods;
3920: --
3921:
3922: debug_info := 'chv_hor';
3923: IF g_debug_switch in ('y','Y') THEN

Line 4039: chv_cum_periods = fp_chv_cum_rows,

4035: po_asl_attributes = fp_po_asl_attr_rows,
4036: po_asl_documents = fp_po_asl_doc_rows,
4037: chv_authorizations = fp_chv_auth_rows,
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,

Line 5704: debug_info := 'chv_cum_periods';

5700: from chv_purge_cum_list cpcl
5701: where cpcl.cum_period_id = cca.cum_period_id
5702: and cpcl.double_check_flag = 'Y');
5703:
5704: debug_info := 'chv_cum_periods';
5705: IF g_debug_switch in ('y','Y') THEN
5706: Print('(Purge_Schedules_by_Cum)'||debug_info);
5707: END IF;
5708:

Line 5709: -- delete_chv_cum_periods

5705: IF g_debug_switch in ('y','Y') THEN
5706: Print('(Purge_Schedules_by_Cum)'||debug_info);
5707: END IF;
5708:
5709: -- delete_chv_cum_periods
5710:
5711: delete from chv_cum_periods ccp
5712: where exists
5713: (select null

Line 5711: delete from chv_cum_periods ccp

5707: END IF;
5708:
5709: -- delete_chv_cum_periods
5710:
5711: delete from chv_cum_periods ccp
5712: where exists
5713: (select null
5714: from chv_purge_cum_list cpcl
5715: where cpcl.cum_period_id = ccp.cum_period_id

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

6512: po_asl_attributes = nvl(po_asl_attributes,0) - po_asl_attr_rows,
6513: po_asl_documents = nvl(po_asl_documents,0) - po_asl_doc_rows,
6514: chv_authorizations = nvl(chv_authorizations,0) - chv_auth_rows,
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,