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.HXC_RESTORE dependencies on HXC_ARCHIVE

Line 116: -- THE ARCHIVE PROCESS IN HXC_ARCHIVE PACKAGE. PLS REFER THAT PACKAGE

112: BEGIN
113:
114:
115: -- POST RE-ARCHITECTURE THIS PROCESS FOLLOWS THE SAME ALGORITHM OF
116: -- THE ARCHIVE PROCESS IN HXC_ARCHIVE PACKAGE. PLS REFER THAT PACKAGE
117: -- FOR DETAILED COMMENTS.
118:
119: hr_general.g_data_migrator_mode := 'Y';
120:

Line 121: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);

117: -- FOR DETAILED COMMENTS.
118:
119: hr_general.g_data_migrator_mode := 'Y';
120:
121: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
122:
123: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);
124:
125: -- Update hxc_data_sets as RESTORE_IN_PROGRESS because the process is going to take some time.

Line 498: FROM hxc_archive_temp

494:
495: CURSOR get_dup_trans
496: IS SELECT master_id,
497: MAX(ROWID)
498: FROM hxc_archive_temp
499: WHERE thread_id = p_thread_id
500: GROUP BY master_id ;
501:
502: CURSOR get_latest_details

Line 676: -- To have an idea of the detailed Algorithm/approach, pls refer to hxc_archive

672:
673: -- BUG 7358756
674: -- After rewrite of Archive/Restore process, this new proceduce supports the new
675: -- multithreaded design.
676: -- To have an idea of the detailed Algorithm/approach, pls refer to hxc_archive
677: -- ( hxcarchive.pkb ).
678:
679:
680: hr_general.g_data_migrator_mode := 'Y';

Line 682: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);

678:
679:
680: hr_general.g_data_migrator_mode := 'Y';
681:
682: l_chunk_size := nvl(fnd_profile.value('HXC_ARCHIVE_RESTORE_CHUNK_SIZE'),50);
683:
684: fnd_file.put_line(fnd_file.log,'--- > Chunk Size is: '||l_chunk_size);
685:
686:

Line 1118: INSERT INTO hxc_archive_temp

1114:
1115: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1116:
1117: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1118: INSERT INTO hxc_archive_temp
1119: ( detail_id,
1120: master_id,
1121: ref_rowid,
1122: thread_id )

Line 1136: FROM hxc_archive_temp temp,

1132: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1133: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1134: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1135: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1136: FROM hxc_archive_temp temp,
1137: hxc_transaction_details_ar bkuptxnd
1138: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1139: AND thread_id = p_thread_id
1140: AND bkuptxnd.data_set_id = p_data_set_id;

Line 1167: DELETE FROM hxc_archive_temp

1163:
1164: EXIT WHEN trans_id_tab.COUNT = 0;
1165:
1166: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1167: DELETE FROM hxc_archive_temp
1168: WHERE master_id = trans_id_tab(i)
1169: AND ROWID <> uniq_rowid_tab(i)
1170: AND thread_id = p_thread_id ;
1171: END LOOP;

Line 1179: DELETE FROM hxc_archive_temp

1175: -- No longer required since this should be handled by the Parent
1176: -- process.
1177: /*
1178:
1179: DELETE FROM hxc_archive_temp
1180: WHERE EXISTS ( SELECT 1
1181: FROM hxc_transactions
1182: WHERE transaction_id = master_id )
1183: AND thread_id = p_thread_id ;

Line 1202: hxc_archive_temp temp

1198: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1199: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1200: TRANSACTION_CODE
1201: FROM hxc_transactions_ar bkuptxn,
1202: hxc_archive_temp temp
1203: WHERE transaction_id = master_id
1204: AND thread_id = p_thread_id
1205: AND transaction_id NOT IN ( SELECT transaction_id
1206: FROM hxc_transactions hxc

Line 1218: FROM hxc_archive_temp temp

1214:
1215: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) *
1216: FROM hxc_transactions_ar bkuptxn
1217: WHERE transaction_id IN ( SELECT master_id
1218: FROM hxc_archive_temp temp
1219: WHERE thread_id = p_thread_id)
1220: AND type <> 'RETRIEVAL'
1221: AND data_set_id = p_data_set_id ;
1222:

Line 1238: hxc_archive_temp temp

1234: p_data_set_id,
1235: p_thread_id,
1236: ROWIDTOCHAR(bkuptxn.ROWID)
1237: FROM hxc_transactions_ar bkuptxn,
1238: hxc_archive_temp temp
1239: WHERE transaction_id = master_id
1240: AND thread_id = p_thread_id
1241: AND type = 'RETRIEVAL';
1242:

Line 1245: DELETE FROM hxc_archive_temp

1241: AND type = 'RETRIEVAL';
1242:
1243:
1244:
1245: DELETE FROM hxc_archive_temp
1246: WHERE thread_id = p_thread_id ;
1247:
1248: END LOOP;
1249:

Line 1290: INSERT INTO hxc_archive_temp

1286:
1287: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1288:
1289: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1290: INSERT INTO hxc_archive_temp
1291: ( detail_id,
1292: master_id,
1293: ref_rowid,
1294: thread_id )

Line 1308: FROM hxc_archive_temp temp,

1304: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1305: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1306: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1307: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1308: FROM hxc_archive_temp temp,
1309: hxc_transaction_details_ar bkuptxnd
1310: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1311: AND thread_id = p_thread_id
1312: AND bkuptxnd.data_set_id = p_data_set_id;

Line 1339: DELETE FROM hxc_archive_temp

1335:
1336: EXIT WHEN trans_id_tab.COUNT = 0;
1337:
1338: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1339: DELETE FROM hxc_archive_temp
1340: WHERE master_id = trans_id_tab(i)
1341: AND ROWID <> uniq_rowid_tab(i)
1342: AND thread_id = p_thread_id ;
1343: END LOOP;

Line 1346: DELETE FROM hxc_archive_temp

1342: AND thread_id = p_thread_id ;
1343: END LOOP;
1344: CLOSE get_dup_trans;
1345:
1346: DELETE FROM hxc_archive_temp
1347: WHERE EXISTS ( SELECT 1
1348: FROM hxc_transactions
1349: WHERE transaction_id = master_id )
1350: AND thread_id = p_thread_id ;

Line 1362: hxc_archive_temp temp

1358: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1359: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1360: TRANSACTION_CODE
1361: FROM hxc_transactions_ar bkuptxn,
1362: hxc_archive_temp temp
1363: WHERE transaction_id = master_id
1364: AND thread_id = p_thread_id
1365: AND transaction_id NOT IN ( SELECT transaction_id
1366: FROM hxc_dep_transactions hxc

Line 1377: FROM hxc_archive_temp temp

1373:
1374: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1375: FROM hxc_transactions_ar bkuptxn
1376: WHERE transaction_id IN ( SELECT master_id
1377: FROM hxc_archive_temp temp
1378: WHERE thread_id = p_thread_id)
1379: AND type = 'DEPOSIT'
1380: AND data_set_id = p_data_set_id ;
1381:

Line 1385: DELETE FROM hxc_archive_temp

1381:
1382: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;
1383:
1384:
1385: DELETE FROM hxc_archive_temp
1386: WHERE thread_id = p_thread_id ;
1387:
1388: END LOOP;
1389:

Line 1407: INSERT INTO hxc_archive_temp

1403:
1404: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1405:
1406: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1407: INSERT INTO hxc_archive_temp
1408: ( detail_id,
1409: master_id,
1410: ref_rowid,
1411: thread_id )

Line 1425: FROM hxc_archive_temp temp,

1421: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1422: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1423: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1424: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1425: FROM hxc_archive_temp temp,
1426: hxc_dep_txn_details_ar bkuptxnd
1427: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1428: AND thread_id = p_thread_id
1429: AND bkuptxnd.data_set_id = p_data_set_id;

Line 1456: DELETE FROM hxc_archive_temp

1452:
1453: EXIT WHEN trans_id_tab.COUNT = 0;
1454:
1455: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1456: DELETE FROM hxc_archive_temp
1457: WHERE master_id = trans_id_tab(i)
1458: AND ROWID <> uniq_rowid_tab(i)
1459: AND thread_id = p_thread_id ;
1460: END LOOP;

Line 1463: DELETE FROM hxc_archive_temp

1459: AND thread_id = p_thread_id ;
1460: END LOOP;
1461: CLOSE get_dup_trans;
1462:
1463: DELETE FROM hxc_archive_temp
1464: WHERE EXISTS ( SELECT 1
1465: FROM hxc_transactions
1466: WHERE transaction_id = master_id )
1467: AND thread_id = p_thread_id ;

Line 1480: hxc_archive_temp temp

1476: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1477: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1478: TRANSACTION_CODE
1479: FROM hxc_dep_transactions_ar bkuptxn,
1480: hxc_archive_temp temp
1481: WHERE transaction_id = master_id
1482: AND thread_id = p_thread_id
1483: AND transaction_id NOT IN ( SELECT transaction_id
1484: FROM hxc_dep_transactions hxc

Line 1495: FROM hxc_archive_temp temp

1491:
1492: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1493: FROM hxc_dep_transactions_ar bkuptxn
1494: WHERE transaction_id IN ( SELECT master_id
1495: FROM hxc_archive_temp temp
1496: WHERE thread_id = p_thread_id)
1497: AND data_set_id = p_data_set_id ;
1498:
1499: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;

Line 1501: DELETE FROM hxc_archive_temp

1497: AND data_set_id = p_data_set_id ;
1498:
1499: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;
1500:
1501: DELETE FROM hxc_archive_temp
1502: WHERE thread_id = p_thread_id ;
1503:
1504: END LOOP;
1505:

Line 1553: INSERT INTO hxc_archive_temp

1549: EXIT WHEN usage_tab.COUNT = 0;
1550:
1551:
1552: FORALL i IN usage_tab.FIRST..usage_tab.LAST
1553: INSERT INTO hxc_archive_temp
1554: ( detail_id,
1555: master_id,
1556: ref_rowid,
1557: thread_id)

Line 1572: FROM hxc_archive_temp temp,

1568: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */
1569: bkuptau.DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1570: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1571: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1572: FROM hxc_archive_temp temp,
1573: hxc_time_attribute_usages_ar bkuptau
1574: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1575: AND thread_id = p_thread_id
1576: AND bkuptau.data_set_id = p_data_set_id;

Line 1588: DELETE FROM hxc_archive_temp

1584: AND data_set_id = p_data_set_id;
1585:
1586: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1587:
1588: DELETE FROM hxc_archive_temp
1589: WHERE EXISTS ( SELECT 1
1590: FROM hxc_time_attributes
1591: WHERE time_attribute_id = master_id )
1592: AND thread_id = p_thread_id ;

Line 1611: FROM hxc_archive_temp temp

1607: ATTRIBUTE14,null,DATA_SET_ID
1608: FROM hxc_time_attributes_ar bkupta
1609: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1610: master_id
1611: FROM hxc_archive_temp temp
1612: WHERE thread_id = p_thread_id )
1613: AND bkupta.data_set_id = p_data_set_id;
1614:
1615:

Line 1622: FROM hxc_archive_temp temp

1618: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1619: FROM hxc_time_attributes_ar bkupta
1620: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1621: master_id
1622: FROM hxc_archive_temp temp
1623: WHERE thread_id = p_thread_id )
1624: AND data_set_id = p_data_set_id ;
1625:
1626: l_ta_del_count := l_ta_del_count + SQL%ROWCOUNT;

Line 1632: DELETE FROM hxc_archive_temp

1628: usage_tab.DELETE;
1629: attribute_tab.DELETE;
1630: usage_rowid_tab.DELETE;
1631:
1632: DELETE FROM hxc_archive_temp
1633: WHERE thread_id = p_thread_id ;
1634:
1635: END LOOP ;
1636: CLOSE get_attributes;

Line 1677: INSERT INTO hxc_archive_temp

1673: EXIT WHEN sum_id_tab.COUNT = 0;
1674:
1675:
1676: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1677: INSERT INTO hxc_archive_temp
1678: ( detail_id,
1679: master_id,
1680: thread_id)
1681: VALUES ( sum_id_tab(i),

Line 1715: hxc_archive_temp temp

1711: attribute28, attribute29, attribute30, object_version_number, time_building_block_id,
1712: time_building_block_ovn, id, line_status, tim_id, date_worked, assignment_id,
1713: hours, time_in, time_out, element_type_id, fcl_earn_reason_code
1714: FROM hxt_sum_hours_worked_f_ar sum,
1715: hxc_archive_temp temp
1716: WHERE temp.detail_id = sum.id
1717: AND temp.thread_id = p_thread_id;
1718:
1719:

Line 1746: FROM hxc_archive_temp temp,

1742: fcl_tax_rule_code, separate_check_flag, seqno, created_by, creation_date, last_updated_by,
1743: last_update_date, last_update_login, actual_time_in, actual_time_out, job_id, earn_pol_id,
1744: effective_start_date, effective_end_date, pbl_line_id, retro_pbl_line_id, project_id,
1745: prev_wage_code, pa_status, pay_status, retro_batch_id, object_version_number
1746: FROM hxc_archive_temp temp,
1747: hxt_det_hours_worked_f_ar det
1748: WHERE temp.detail_id = det.parent_id
1749: AND temp.thread_id = p_thread_id;
1750:

Line 1765: DELETE FROM hxc_archive_temp

1761: UPDATE hxt_timecards_f
1762: SET data_set_id = p_data_set_id
1763: WHERE id = tim_id_tab(i);
1764:
1765: DELETE FROM hxc_archive_temp
1766: WHERE thread_id = p_thread_id;
1767:
1768: END LOOP;
1769: CLOSE get_sum_hrs;

Line 1772: hxc_archive.log_data_mismatch( p_scope => 'OTLR Summary ',

1768: END LOOP;
1769: CLOSE get_sum_hrs;
1770:
1771:
1772: hxc_archive.log_data_mismatch( p_scope => 'OTLR Summary ',
1773: p_insert => l_hxt_sum_count,
1774: p_delete => l_hxt_sum_del_count,
1775: p_mismatch => data_mismatch );
1776: IF data_mismatch

Line 1782: hxc_archive.log_data_mismatch( p_scope => 'OTLR Details',

1778: write_data_mismatch('OTLR Summary ');
1779: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
1780: END IF;
1781:
1782: hxc_archive.log_data_mismatch( p_scope => 'OTLR Details',
1783: p_insert => l_hxt_det_count,
1784: p_delete => l_hxt_det_del_count,
1785: p_mismatch => data_mismatch );
1786: