APPS.HXC_RDB_ATT_SNAPSHOT dependencies on HXC_PA_LATEST_DETAILS

Line 101: FROM hxc_pa_latest_details hld,

97: DECODE (TBB.DATE_TO, HR_GENERAL.end_of_time, nvl (tbb.measure,
98: TO_NUMBER (tbb.stop_time - tbb.start_time) * 24 ) ,
99: 0 ) measure,
100: hld.timecard_id
101: FROM hxc_pa_latest_details hld,
102: hxc_time_attribute_usages htau,
103: hxc_time_attributes hta,
104: hxc_bld_blk_info_types bld,
105: hxc_time_building_blocks tbb

Line 387: fnd_file.put_line (fnd_file.LOG,'STARTING WITH HXC_PA_LATEST_DETAILS');

383: if l_pa_upg = 'Y' then
384:
385: if g_debug then
386: fnd_file.put_line (fnd_file.LOG,'******************************');
387: fnd_file.put_line (fnd_file.LOG,'STARTING WITH HXC_PA_LATEST_DETAILS');
388: fnd_file.put_line (fnd_file.LOG,'******************************');
389: end if;
390:
391: OPEN get_pa_attribute_info;

Line 409: fnd_file.put_line (fnd_file.LOG,'Updating hxc_pa_latest_details');

405:
406: TIMECARD_ID_STATUS := get_locked_timecards(TIMECARD_ID_TAB);
407:
408: if g_debug then
409: fnd_file.put_line (fnd_file.LOG,'Updating hxc_pa_latest_details');
410: fnd_file.put_line (fnd_file.LOG,'ROW_ID_TAB.COUNT ='||ROW_ID_TAB.COUNT);
411: end if;
412:
413:

Line 416: UPDATE hxc_pa_latest_details

412:
413:
414: begin
415: FORALL i in ROW_ID_TAB.first .. ROW_ID_TAB.last SAVE EXCEPTIONS
416: UPDATE hxc_pa_latest_details
417: SET ATTRIBUTE_CATEGORY = ATTRIBUTE_CATEGORY_TAB(i),
418: ATTRIBUTE1 = ATTRIBUTE1_TAB(i),
419: ATTRIBUTE2 = ATTRIBUTE2_TAB(i),
420: ATTRIBUTE3 = ATTRIBUTE3_TAB(i),