APPS.HXC_UPGRADE_PKG dependencies on HXC_UPG_DETAILS_TEMP

Line 207: DELETE FROM hxc_upg_details_temp;

203: l_chunk_size := NVL(FND_PROFILE.VALUE('HXC_UPGRADE_WORKER_SIZE'),100000);
204: put_log('Data Volume size for Worker :'||l_chunk_size);
205:
206:
207: DELETE FROM hxc_upg_details_temp;
208: DELETE FROM hxc_upg_master_temp;
209: COMMIT;
210:
211: IF (p_type = 'LATEST_DETAILS') THEN

Line 1026: FROM hxc_upg_details_temp temp

1022:
1023: CURSOR get_deleted_entries(p_thread_id NUMBER,
1024: p_bee_id NUMBER)
1025: IS SELECT ROWIDTOCHAR(temp.rowid)
1026: FROM hxc_upg_details_temp temp
1027: WHERE temp.thread_id = p_thread_id
1028: AND temp.detail_attribute2 = 'D'
1029: AND NOT EXISTS ( SELECT 1
1030: FROM hxc_transaction_details htd,

Line 1047: FROM hxc_upg_details_temp temp

1043: CURSOR get_untransferred_entries(p_thread_id NUMBER,
1044: p_bee_id NUMBER)
1045: IS SELECT temp.master_id,
1046: TO_NUMBER(temp.detail_attribute1)
1047: FROM hxc_upg_details_temp temp
1048: WHERE temp.thread_id = p_thread_id
1049: AND NOT EXISTS ( SELECT 1
1050: FROM hxc_transaction_details htd,
1051: hxc_transactions ht

Line 1069: FROM hxc_upg_details_temp temp,

1065: CURSOR get_timecards_xfer(p_thread_id NUMBER)
1066: IS SELECT DISTINCT master_id,
1067: master_ovn,
1068: htr.name
1069: FROM hxc_upg_details_temp temp,
1070: hxc_retrieval_processes hrp,
1071: hxc_time_recipients htr
1072: WHERE TO_NUMBER(temp.detail_attribute1) = hrp.retrieval_process_id
1073: AND hrp.time_recipient_id = htr.time_recipient_id

Line 1561: INSERT INTO hxc_upg_details_temp

1557:
1558: BEGIN
1559:
1560: FORALL i IN detidtab.FIRST..detidtab.LAST SAVE EXCEPTIONS
1561: INSERT INTO hxc_upg_details_temp
1562: ( master_id,
1563: master_ovn,
1564: detail_id,
1565: detail_ovn,

Line 1615: DELETE FROM hxc_upg_details_temp

1611: FETCH get_deleted_entries BULK COLLECT INTO ROWTAB LIMIT 500;
1612: EXIT WHEN rowtab.COUNT = 0;
1613:
1614: FORALL i IN rowtab.FIRST..rowtab.LAST
1615: DELETE FROM hxc_upg_details_temp
1616: WHERE ROWID = CHARTOROWID(rowtab(i));
1617:
1618: COMMIT;
1619: END LOOP;

Line 1634: DELETE FROM hxc_upg_details_temp

1630: rettab LIMIT 500;
1631: EXIT WHEN rettab.COUNT = 0;
1632:
1633: FORALL i IN msttab.FIRST..msttab.LAST
1634: DELETE FROM hxc_upg_details_temp
1635: WHERE master_id = msttab(i)
1636: AND detail_attribute1 = rettab(i);
1637:
1638: COMMIT;

Line 1669: DELETE FROM hxc_upg_details_temp

1665: END LOOP;
1666:
1667: CLOSE get_all_details;
1668:
1669: DELETE FROM hxc_upg_details_temp
1670: WHERE thread_id = l_thread_id;
1671:
1672: COMMIT;
1673: END LOOP;