APPS.HXC_UPGRADE_PKG dependencies on HXC_UPGRADE_STATUS

Line 160: DELETE FROM HXC_UPGRADE_STATUS;

156: BEGIN
157: hr_general.g_data_migrator_mode := 'Y';
158: l_start_time := SYSDATE;
159:
160: DELETE FROM HXC_UPGRADE_STATUS;
161:
162: hr_utility.trace('p_type = '||p_type);
163:
164: -- Added if -endif

Line 259: INSERT INTO hxc_upgrade_status

255: ,argument4 => l_stop_after
256: ,argument2 => l_reqtab(l_ind).start_id ,
257: argument3 => l_reqtab(l_ind).end_id);
258: COMMIT;
259: INSERT INTO hxc_upgrade_status
260: (parent_id,
261: child_id,
262: child_status)
263: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 342: INSERT INTO hxc_upgrade_status

338: ,argument4 => l_stop_after
339: ,argument2 => l_reqtab(l_ind).start_id ,
340: argument3 => l_reqtab(l_ind).end_id);
341: COMMIT;
342: INSERT INTO hxc_upgrade_status
343: (parent_id,
344: child_id,
345: child_status)
346: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 425: INSERT INTO hxc_upgrade_status

421: ,argument4 => l_stop_after
422: ,argument2 => l_reqtab(l_ind).start_id ,
423: argument3 => l_reqtab(l_ind).end_id);
424: COMMIT;
425: INSERT INTO hxc_upgrade_status
426: (parent_id,
427: child_id,
428: child_status)
429: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 501: INSERT INTO hxc_upgrade_status

497: argument3 => l_reqtab(l_ind).end_id);
498: COMMIT;
499:
500:
501: INSERT INTO hxc_upgrade_status
502: (parent_id,
503: child_id,
504: child_status)
505: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 600: INSERT INTO hxc_upgrade_status

596:
597:
598: COMMIT;
599:
600: INSERT INTO hxc_upgrade_status
601: (parent_id,
602: child_id,
603: child_status)
604: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 674: INSERT INTO hxc_upgrade_status

670: ,argument4 => l_stop_after
671: ,argument2 => l_reqtab(l_ind).start_id ,
672: argument3 => l_reqtab(l_ind).end_id);
673: COMMIT;
674: INSERT INTO hxc_upgrade_status
675: (parent_id,
676: child_id,
677: child_status)
678: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 722: INSERT INTO hxc_upgrade_status

718: argument3 => l_reqtab(l_reqtab.LAST).end_id);
719:
720: COMMIT;
721: l_ind := l_reqtab.LAST;
722: INSERT INTO hxc_upgrade_status
723: (parent_id,
724: child_id,
725: child_status)
726: VALUES ( FND_GLOBAL.CONC_REQUEST_ID,

Line 778: FROM hxc_upgrade_status

774:
775: BEGIN
776: SELECT 1
777: INTO l_exists
778: FROM hxc_upgrade_status
779: WHERE child_status = 'INCOMPLETE'
780: AND ROWNUM < 2 ;
781:
782: IF l_exists =1

Line 1183: UPDATE hxc_upgrade_status

1179:
1180:
1181: IF l_complete = TRUE
1182: THEN
1183: UPDATE hxc_upgrade_status
1184: SET child_status = 'COMPLETE'
1185: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1186:
1187: COMMIT;

Line 1274: UPDATE hxc_upgrade_status

1270:
1271:
1272: IF l_complete = TRUE
1273: THEN
1274: UPDATE hxc_upgrade_status
1275: SET child_status = 'COMPLETE'
1276: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1277:
1278: COMMIT;

Line 1365: UPDATE hxc_upgrade_status

1361:
1362:
1363: IF l_complete = TRUE
1364: THEN
1365: UPDATE hxc_upgrade_status
1366: SET child_status = 'COMPLETE'
1367: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1368:
1369: COMMIT;

Line 1495: UPDATE hxc_upgrade_status

1491:
1492:
1493: IF l_complete = TRUE
1494: THEN
1495: UPDATE hxc_upgrade_status
1496: SET child_status = 'COMPLETE'
1497: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1498:
1499: COMMIT;

Line 1679: UPDATE hxc_upgrade_status

1675: CLOSE get_all_timecards;
1676:
1677: IF l_complete = TRUE
1678: THEN
1679: UPDATE hxc_upgrade_status
1680: SET child_status = 'COMPLETE'
1681: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1682:
1683: COMMIT;

Line 1793: UPDATE hxc_upgrade_status

1789: put_log('Upgrade Worker Process Completed');
1790:
1791: IF l_complete = TRUE
1792: THEN
1793: UPDATE hxc_upgrade_status
1794: SET child_status = 'COMPLETE'
1795: WHERE child_id = FND_GLOBAL.CONC_REQUEST_ID;
1796:
1797: COMMIT;