APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_TEMP_TIMECARDS

Line 903: insert into hxc_temp_timecards

899:
900: BEGIN
901:
902: forall x in l_tbb_id_tab.first .. l_tbb_id_tab.last
903: insert into hxc_temp_timecards
904: (time_building_block_id
905: ,object_version_number
906: ,scope
907: ,worker_id)

Line 949: insert into hxc_temp_timecards

945: fnd_file.put_line(fnd_file.LOG,'Total Number of templates processed : ' ||l_timecard_count);
946:
947:
948:
949: insert into hxc_temp_timecards
950: (TIME_BUILDING_BLOCK_ID
951: ,scope
952: ,object_version_number
953: ,worker_id

Line 1172: insert into hxc_temp_timecards

1168: l_timecard_count := l_timecard_count + l_tbb_id_tab.count;
1169: BEGIN
1170:
1171: forall x in l_tbb_id_tab.first .. l_tbb_id_tab.last
1172: insert into hxc_temp_timecards
1173: (time_building_block_id
1174: ,object_version_number
1175: ,scope
1176: ,worker_id)

Line 1265: insert into hxc_temp_timecards

1261: l_app_period_count := l_app_period_count + l_app_bb_id_tab.count;
1262:
1263: BEGIN
1264: forall x in l_app_bb_id_tab.first .. l_app_bb_id_tab.last
1265: insert into hxc_temp_timecards
1266: (time_building_block_id
1267: ,scope
1268: ,worker_id)
1269: values

Line 1305: insert into hxc_temp_timecards

1301: END IF;
1302:
1303: fnd_file.put_line(fnd_file.LOG,'Total Number of application period blocks processed : ' ||l_app_period_count);
1304:
1305: insert into hxc_temp_timecards
1306: (TIME_BUILDING_BLOCK_ID
1307: ,scope
1308: ,object_version_number
1309: ,worker_id

Line 1475: from hxc_temp_timecards

1471:
1472: cursor c_temp_resources(p_worker_id number, p_scope varchar2) is
1473: select time_building_block_id
1474: ,object_version_number
1475: from hxc_temp_timecards
1476: where worker_id = p_worker_id and
1477: scope = p_scope and
1478: processed = 'Y';
1479:

Line 1482: from hxc_temp_timecards

1478: processed = 'Y';
1479:
1480: cursor c_check_completion(p_worker_id number) is
1481: select 'Y'
1482: from hxc_temp_timecards
1483: where worker_id = p_worker_id and
1484: scope = 'COMPLETED';
1485:
1486:

Line 1525: delete from hxc_temp_timecards where worker_id = l_worker_id;

1521: fnd_file.put_line(fnd_file.LOG,'Number of Application Summary Records Processed :' ||l_app_per_summary_count);
1522: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1523: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1524: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1525: delete from hxc_temp_timecards where worker_id = l_worker_id;
1526: commit;
1527: return;
1528: end if;
1529:

Line 1530: update hxc_temp_timecards

1526: commit;
1527: return;
1528: end if;
1529:
1530: update hxc_temp_timecards
1531: set processed = 'Y'
1532: where worker_id = l_worker_id and
1533: scope in ('TIMECARD', 'APPLICATION_PERIOD');
1534:

Line 1557: delete from hxc_temp_timecards

1553: ,hxc_timecard_summary_pkg.c_migration_mode);
1554: l_app_per_summary_count := l_app_per_summary_count + 1;
1555: end loop;
1556:
1557: delete from hxc_temp_timecards
1558: where worker_id = l_worker_id and
1559: scope in ('TIMECARD', 'APPLICATION_PERIOD') and
1560: processed = 'Y';
1561:

Line 1612: delete from hxc_temp_timecards where worker_id = l_worker_id;

1608: l_time_summary_count);
1609: fnd_file.put_line(fnd_file.LOG,'---------------------------------------------------');
1610: fnd_file.put_line(fnd_file.LOG, 'Leaving Worker Migration');
1611: fnd_file.put_line(fnd_file.LOG,'Ending Time :' ||to_char(sysdate, 'DD/MM/RRRR HH:MI:SS'));
1612: delete from hxc_temp_timecards where worker_id = l_worker_id;
1613: commit;
1614: return;
1615: end if;
1616:

Line 1617: update hxc_temp_timecards

1613: commit;
1614: return;
1615: end if;
1616:
1617: update hxc_temp_timecards
1618: set processed = 'Y'
1619: where worker_id = l_worker_id and
1620: scope in ('TIMECARD_TEMPLATE');
1621:

Line 1632: delete from hxc_temp_timecards

1628: );
1629: l_time_summary_count := l_time_summary_count + 1;
1630: end loop;
1631:
1632: delete from hxc_temp_timecards
1633: where worker_id = l_worker_id and
1634: scope in ('TIMECARD_TEMPLATE') and
1635: processed = 'Y';
1636: