APPS.HXC_UPGRADE_PKG dependencies on HXC_UPG_MASTER_TEMP

Line 208: DELETE FROM hxc_upg_master_temp;

204: put_log('Data Volume size for Worker :'||l_chunk_size);
205:
206:
207: DELETE FROM hxc_upg_details_temp;
208: DELETE FROM hxc_upg_master_temp;
209: COMMIT;
210:
211: IF (p_type = 'LATEST_DETAILS') THEN
212: OPEN get_id;

Line 559: INSERT INTO hxc_upg_master_temp

555:
556: l_count := l_count + l_id_tab.COUNT;
557: l_reqtab(l_ind).end_id := 0;
558: FORALL i IN l_id_tab.FIRST..l_id_tab.LAST
559: INSERT INTO hxc_upg_master_temp
560: (master_id,
561: master_ovn,
562: thread_id)
563: VALUES

Line 981: FROM hxc_upg_master_temp temp

977: -- below cursor.
978: -- To pick up all timecards.
979: CURSOR get_all_timecards(p_start IN NUMBER)
980: IS SELECT master_id
981: FROM hxc_upg_master_temp temp
982: WHERE thread_id = p_start
983: ORDER BY master_id ;
984:
985: -- To pick up details pertaining to each recipient application for each timecard.

Line 1002: FROM hxc_upg_master_temp temp,

998: hld.object_version_number,
999: DECODE(hrp.NAME, 'HR Retrieval Process', p_bee_id,
1000: hrp.retrieval_process_id),
1001: DECODE(detail.date_to, hr_general.end_of_time,NULL,'D')
1002: FROM hxc_upg_master_temp temp,
1003: hxc_time_building_blocks day,
1004: hxc_time_building_blocks detail,
1005: hxc_latest_details hld,
1006: hxc_application_set_comps_v hasc,