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_TEMP

Line 451: FROM hxc_archive_temp

447:
448: CURSOR get_dup_trans
449: IS SELECT master_id,
450: MAX(ROWID)
451: FROM hxc_archive_temp
452: WHERE thread_id = p_thread_id
453: GROUP BY master_id ;
454:
455: CURSOR get_latest_details

Line 1023: INSERT INTO hxc_archive_temp

1019:
1020: EXIT WHEN trans_detail_tab.COUNT = 0 ;
1021:
1022: FORALL i IN trans_detail_tab.FIRST..trans_detail_tab.LAST
1023: INSERT INTO hxc_archive_temp
1024: ( detail_id,
1025: master_id,
1026: ref_rowid,
1027: thread_id )

Line 1041: FROM hxc_archive_temp temp,

1037: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1038: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1039: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1040: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1041: FROM hxc_archive_temp temp,
1042: hxc_transaction_details_ar bkuptxnd
1043: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1044: AND thread_id = p_thread_id
1045: AND bkuptxnd.data_set_id = p_data_set_id;

Line 1072: DELETE FROM hxc_archive_temp

1068:
1069: EXIT WHEN trans_id_tab.COUNT = 0;
1070:
1071: FORALL i IN trans_id_tab.FIRST..trans_id_tab.LAST
1072: DELETE FROM hxc_archive_temp
1073: WHERE master_id = trans_id_tab(i)
1074: AND ROWID <> uniq_rowid_tab(i)
1075: AND thread_id = p_thread_id ;
1076: END LOOP;

Line 1079: DELETE FROM hxc_archive_temp

1075: AND thread_id = p_thread_id ;
1076: END LOOP;
1077: CLOSE get_dup_trans;
1078:
1079: DELETE FROM hxc_archive_temp
1080: WHERE EXISTS ( SELECT 1
1081: FROM hxc_transactions
1082: WHERE transaction_id = master_id )
1083: AND thread_id = p_thread_id ;

Line 1095: hxc_archive_temp temp

1091: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1092: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1093: TRANSACTION_CODE
1094: FROM hxc_transactions_ar bkuptxn,
1095: hxc_archive_temp temp
1096: WHERE transaction_id = master_id
1097: AND thread_id = p_thread_id
1098: AND transaction_id NOT IN ( SELECT transaction_id
1099: FROM hxc_transactions hxc

Line 1110: FROM hxc_archive_temp temp

1106:
1107: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1108: FROM hxc_transactions_ar bkuptxn
1109: WHERE transaction_id IN ( SELECT master_id
1110: FROM hxc_archive_temp temp
1111: WHERE thread_id = p_thread_id)
1112: AND type <> 'RETRIEVAL'
1113: AND data_set_id = p_data_set_id ;
1114:

Line 1124: hxc_archive_temp temp

1120: p_data_set_id,
1121: p_thread_id,
1122: ROWIDTOCHAR(bkuptxn.ROWID)
1123: FROM hxc_transactions_ar bkuptxn,
1124: hxc_archive_temp temp
1125: WHERE transaction_id = master_id
1126: AND thread_id = p_thread_id
1127: AND type = 'RETRIEVAL'
1128: AND data_set_id = p_data_set_id ;

Line 1132: DELETE FROM hxc_archive_temp

1128: AND data_set_id = p_data_set_id ;
1129:
1130:
1131:
1132: DELETE FROM hxc_archive_temp
1133: WHERE thread_id = p_thread_id ;
1134:
1135: END LOOP;
1136:

Line 1184: INSERT INTO hxc_archive_temp

1180: EXIT WHEN usage_tab.COUNT = 0;
1181:
1182:
1183: FORALL i IN usage_tab.FIRST..usage_tab.LAST
1184: INSERT INTO hxc_archive_temp
1185: ( detail_id,
1186: master_id,
1187: ref_rowid,
1188: thread_id)

Line 1203: FROM hxc_archive_temp temp,

1199: SELECT /*+ LEADING(temp) USE_NL(bkuptau) */
1200: bkuptau.DATA_SET_ID,TIME_ATTRIBUTE_USAGE_ID,TIME_ATTRIBUTE_ID,TIME_BUILDING_BLOCK_ID,
1201: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1202: OBJECT_VERSION_NUMBER,TIME_BUILDING_BLOCK_OVN
1203: FROM hxc_archive_temp temp,
1204: hxc_time_attribute_usages_ar bkuptau
1205: WHERE bkuptau.ROWID = CHARTOROWID(temp.ref_rowid)
1206: AND thread_id = p_thread_id
1207: AND bkuptau.data_set_id = p_data_set_id;

Line 1219: DELETE FROM hxc_archive_temp

1215: AND data_set_id = p_data_set_id;
1216:
1217: l_tau_del_count := l_tau_del_count + SQL%ROWCOUNT;
1218:
1219: DELETE FROM hxc_archive_temp
1220: WHERE EXISTS ( SELECT 1
1221: FROM hxc_time_attributes
1222: WHERE time_attribute_id = master_id )
1223: AND thread_id = p_thread_id ;

Line 1242: FROM hxc_archive_temp temp

1238: ATTRIBUTE14,null,DATA_SET_ID
1239: FROM hxc_time_attributes_ar bkupta
1240: WHERE bkupta.time_attribute_id in ( SELECT /*+ NO_INDEX(temp) */
1241: master_id
1242: FROM hxc_archive_temp temp
1243: WHERE thread_id = p_thread_id )
1244: AND bkupta.data_set_id = p_data_set_id;
1245:
1246:

Line 1253: FROM hxc_archive_temp temp

1249: DELETE /*+ LEADING(temp) USE_NL(bkupta) */
1250: FROM hxc_time_attributes_ar bkupta
1251: WHERE time_attribute_id IN ( SELECT /*+ NO_INDEX(temp) */
1252: master_id
1253: FROM hxc_archive_temp temp
1254: WHERE thread_id = p_thread_id )
1255: AND data_set_id = p_data_set_id ;
1256:
1257: l_ta_del_count := l_ta_del_count + SQL%ROWCOUNT;

Line 1263: DELETE FROM hxc_archive_temp

1259: usage_tab.DELETE;
1260: attribute_tab.DELETE;
1261: usage_rowid_tab.DELETE;
1262:
1263: DELETE FROM hxc_archive_temp
1264: WHERE thread_id = p_thread_id ;
1265:
1266: END LOOP ;
1267: CLOSE get_attributes;