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_ARCHIVE dependencies on HXC_ARCHIVE_TEMP

Line 519: FROM hxc_archive_temp

515:
516: CURSOR get_dup_trans
517: IS SELECT master_id,
518: MAX(ROWID)
519: FROM hxc_archive_temp
520: WHERE thread_id = p_thread_id
521: GROUP BY master_id ;
522:
523:

Line 705: -- hxc_archive_temp.

701: -- * Delete the above records from hxc_time_building_blocks.
702: -- * Loop to process transaction records.
703: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.

Line 709: -- Delete duplicate transaction ids from hxc_archive_temp.

705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.
710: -- Select all deposit transaction records from hxc_transactions table and
711: -- insert into hxc_transactions_ar table.
712: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
713: -- table for the parent thread to process.

Line 715: -- id is present in hxc_archive_temp.

711: -- insert into hxc_transactions_ar table.
712: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
713: -- table for the parent thread to process.
714: -- Delete all transaction records from hxc_transactions table, if the transaction
715: -- id is present in hxc_archive_temp.
716: -- Delete from hxc_archive temp for the the next iteration of this loop.
717: -- * Loop to process attribute records.
718: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks
719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into

Line 716: -- Delete from hxc_archive temp for the the next iteration of this loop.

712: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
713: -- table for the parent thread to process.
714: -- Delete all transaction records from hxc_transactions table, if the transaction
715: -- id is present in hxc_archive_temp.
716: -- Delete from hxc_archive temp for the the next iteration of this loop.
717: -- * Loop to process attribute records.
718: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks
719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
720: -- hxc_archive_temp.

Line 720: -- hxc_archive_temp.

716: -- Delete from hxc_archive temp for the the next iteration of this loop.
717: -- * Loop to process attribute records.
718: -- Pick up attribute usage records for the records in hxc_temp_timecard_chunks
719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
720: -- hxc_archive_temp.
721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is

Line 724: -- Delete all records from hxc_archive_temp if attribute_id is

720: -- hxc_archive_temp.
721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute

Line 729: -- id is present in hxc_archive_temp.

725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.

Line 730: -- Delete from hxc_archive temp for the the next iteration of this loop.

726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
728: -- Delete all attribute records from hxc_time_attributes table, if the attribute
729: -- id is present in hxc_archive_temp.
730: -- Delete from hxc_archive temp for the the next iteration of this loop.
731: -- * Delete all other scopes except DETAIL from hxc_temp_timecard_chunks.
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.

Line 1196: INSERT INTO hxc_archive_temp

1192:
1193: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1194:
1195: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1196: INSERT INTO hxc_archive_temp
1197: ( detail_id,
1198: master_id,
1199: ref_rowid,
1200: thread_id )

Line 1214: FROM hxc_archive_temp temp,

1210: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1211: p_data_set_id,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1212: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1213: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1214: FROM hxc_archive_temp temp,
1215: hxc_transaction_details bkuptxnd
1216: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1217: AND thread_id = p_thread_id ;
1218:

Line 1240: DELETE FROM hxc_archive_temp

1236:
1237: EXIT WHEN trans_id_tab.COUNT = 0;
1238:
1239: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1240: DELETE FROM hxc_archive_temp
1241: WHERE master_id = trans_id_tab(i)
1242: AND ROWID <> uniq_rowid_tab(i)
1243: AND thread_id = p_thread_id ;
1244: END LOOP;

Line 1252: DELETE FROM hxc_archive_temp

1248: -- This is no longer required because the fix should be
1249: -- handled by the Parent process.
1250: /*
1251:
1252: DELETE FROM hxc_archive_temp
1253: WHERE EXISTS ( SELECT 1
1254: FROM hxc_transactions_ar
1255: WHERE transaction_id = master_id )
1256: AND thread_id = p_thread_id ;

Line 1276: hxc_archive_temp temp

1272: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1273: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1274: TRANSACTION_CODE
1275: FROM hxc_transactions bkuptxn,
1276: hxc_archive_temp temp
1277: WHERE transaction_id = master_id
1278: AND thread_id = p_thread_id
1279: AND transaction_id NOT IN ( SELECT transaction_id
1280: FROM hxc_transactions_ar hxc

Line 1290: FROM hxc_archive_temp temp

1286:
1287: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1288: FROM hxc_transactions bkuptxn
1289: WHERE transaction_id IN ( SELECT master_id
1290: FROM hxc_archive_temp temp
1291: WHERE thread_id = p_thread_id)
1292: AND type <> 'RETRIEVAL';
1293:
1294: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;

Line 1305: hxc_archive_temp temp

1301: p_data_set_id,
1302: p_thread_id,
1303: ROWIDTOCHAR(bkuptxn.ROWID)
1304: FROM hxc_transactions bkuptxn,
1305: hxc_archive_temp temp
1306: WHERE transaction_id = master_id
1307: AND thread_id = p_thread_id
1308: AND type = 'RETRIEVAL';
1309:

Line 1310: DELETE FROM hxc_archive_temp

1306: WHERE transaction_id = master_id
1307: AND thread_id = p_thread_id
1308: AND type = 'RETRIEVAL';
1309:
1310: DELETE FROM hxc_archive_temp
1311: WHERE thread_id = p_thread_id ;
1312:
1313: END LOOP;
1314: CLOSE get_transactions;

Line 1374: INSERT INTO hxc_archive_temp

1370:
1371: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1372:
1373: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1374: INSERT INTO hxc_archive_temp
1375: ( detail_id,
1376: master_id,
1377: ref_rowid,
1378: thread_id )

Line 1392: FROM hxc_archive_temp temp,

1388: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1389: p_data_set_id,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1390: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1391: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1392: FROM hxc_archive_temp temp,
1393: hxc_dep_transaction_details bkuptxnd
1394: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1395: AND thread_id = p_thread_id ;
1396:

Line 1418: DELETE FROM hxc_archive_temp

1414:
1415: EXIT WHEN trans_id_tab.COUNT = 0;
1416:
1417: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1418: DELETE FROM hxc_archive_temp
1419: WHERE master_id = trans_id_tab(i)
1420: AND ROWID <> uniq_rowid_tab(i)
1421: AND thread_id = p_thread_id ;
1422: END LOOP;

Line 1425: DELETE FROM hxc_archive_temp

1421: AND thread_id = p_thread_id ;
1422: END LOOP;
1423: CLOSE get_dup_trans;
1424:
1425: DELETE FROM hxc_archive_temp
1426: WHERE EXISTS ( SELECT 1
1427: FROM hxc_dep_transactions_ar
1428: WHERE transaction_id = master_id )
1429: AND thread_id = p_thread_id ;

Line 1441: hxc_archive_temp temp

1437: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1438: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1439: TRANSACTION_CODE
1440: FROM hxc_dep_transactions bkuptxn,
1441: hxc_archive_temp temp
1442: WHERE transaction_id = master_id
1443: AND thread_id = p_thread_id
1444: AND transaction_id NOT IN ( SELECT transaction_id
1445: FROM hxc_dep_transactions_ar hxc

Line 1454: FROM hxc_archive_temp temp

1450:
1451: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1452: FROM hxc_dep_transactions bkuptxn
1453: WHERE transaction_id IN ( SELECT master_id
1454: FROM hxc_archive_temp temp
1455: WHERE thread_id = p_thread_id) ;
1456:
1457: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;
1458:

Line 1459: DELETE FROM hxc_archive_temp

1455: WHERE thread_id = p_thread_id) ;
1456:
1457: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;
1458:
1459: DELETE FROM hxc_archive_temp
1460: WHERE thread_id = p_thread_id ;
1461:
1462: END LOOP;
1463: CLOSE get_dep_transactions;

Line 1514: INSERT INTO hxc_archive_temp

1510: EXIT WHEN usage_tab.COUNT = 0;
1511:
1512:
1513: FORALL i IN usage_tab.FIRST..usage_tab.LAST
1514: INSERT INTO hxc_archive_temp
1515: ( detail_id,
1516: master_id,
1517: ref_rowid,
1518: thread_id)

Line 1533: FROM hxc_archive_temp temp,

1529: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */
1530: p_data_set_id,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1531: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1532: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1533: FROM hxc_archive_temp temp,
1534: hxc_time_attribute_usages bkuptau
1535: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1536: AND thread_id = p_thread_id ;
1537:

Line 1546: DELETE FROM hxc_archive_temp

1542: WHERE ROWID = CHARTOROWID(usage_rowid_tab(i)) ;
1543:
1544: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1545:
1546: DELETE FROM hxc_archive_temp
1547: WHERE EXISTS ( SELECT 1
1548: FROM hxc_time_attributes_ar
1549: WHERE time_attribute_id = master_id )
1550: AND thread_id = p_thread_id ;

Line 1569: FROM hxc_archive_temp temp

1565: ATTRIBUTE14,null,p_data_set_id
1566: FROM hxc_time_attributes bkupta
1567: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1568: master_id
1569: FROM hxc_archive_temp temp
1570: WHERE thread_id = p_thread_id );
1571:
1572: l_ta_count := l_ta_count + SQL%ROWCOUNT;
1573:

Line 1578: FROM hxc_archive_temp temp

1574: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1575: FROM hxc_time_attributes bkupta
1576: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1577: master_id
1578: FROM hxc_archive_temp temp
1579: WHERE thread_id = p_thread_id ) ;
1580:
1581: l_ta_del_count := l_ta_del_count + SQL%ROWCOUNT;
1582:

Line 1587: DELETE FROM hxc_archive_temp

1583: usage_tab.DELETE;
1584: attribute_tab.DELETE;
1585: usage_rowid_tab.DELETE;
1586:
1587: DELETE FROM hxc_archive_temp
1588: WHERE thread_id = p_thread_id ;
1589:
1590: END LOOP ;
1591: CLOSE get_attributes;

Line 1633: INSERT INTO hxc_archive_temp

1629: EXIT WHEN sum_id_tab.COUNT = 0;
1630:
1631:
1632: FORALL i IN sum_id_tab.FIRST..sum_id_tab.LAST
1633: INSERT INTO hxc_archive_temp
1634: ( detail_id,
1635: master_id,
1636: thread_id)
1637: VALUES ( sum_id_tab(i),

Line 1671: hxc_archive_temp temp

1667: attribute28, attribute29, attribute30, object_version_number, time_building_block_id,
1668: time_building_block_ovn, id, line_status, tim_id, date_worked, assignment_id,
1669: hours, time_in, time_out, element_type_id, fcl_earn_reason_code ,p_data_set_id
1670: FROM hxt_sum_hours_worked_f sum,
1671: hxc_archive_temp temp
1672: WHERE temp.detail_id = sum.id
1673: AND temp.thread_id = p_thread_id;
1674:
1675:

Line 1702: FROM hxc_archive_temp temp,

1698: fcl_tax_rule_code, separate_check_flag, seqno, created_by, creation_date, last_updated_by,
1699: last_update_date, last_update_login, actual_time_in, actual_time_out, job_id, earn_pol_id,
1700: effective_start_date, effective_end_date, pbl_line_id, retro_pbl_line_id, project_id,
1701: prev_wage_code, pa_status, pay_status, retro_batch_id, object_version_number
1702: FROM hxc_archive_temp temp,
1703: hxt_det_hours_worked_f det
1704: WHERE temp.detail_id = det.parent_id
1705: AND temp.thread_id = p_thread_id;
1706:

Line 1721: DELETE FROM hxc_archive_temp

1717: UPDATE hxt_timecards_f
1718: SET data_set_id = p_data_set_id
1719: WHERE id = tim_id_tab(i);
1720:
1721: DELETE FROM hxc_archive_temp
1722: WHERE thread_id = p_thread_id;
1723:
1724:
1725: END LOOP;