DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_IMP_DQM_STAGE

Line 909: l_owner := HZ_IMP_DQM_STAGE.get_owner_name('HZ_DUP_WORKER_CHUNK_GT', 'TABLE');

905: values (-1,-1,-1,-1,chunk_limit,cnt,sysdate);
906: */
907:
908: -- truncate chunk table before inserting into it
909: l_owner := HZ_IMP_DQM_STAGE.get_owner_name('HZ_DUP_WORKER_CHUNK_GT', 'TABLE');
910: execute immediate ' truncate table ' || l_owner || '.HZ_DUP_WORKER_CHUNK_GT';
911:
912: FORALL I in start_idx..end_idx
913: INSERT INTO hz_dup_worker_chunk_gt values (pid_list(I));

Line 956: l_owner := HZ_IMP_DQM_STAGE.get_owner_name('HZ_DUP_WORKER_CHUNK_GT', 'TABLE');

952: insert into hz_dup_results(fid, tid, ord_fid, ord_tid, score,chunk_num,chunk_stime)
953: values (-1,-1,-1,-1,chunk_limit,cnt,sysdate);
954: */
955: -- truncate chunk table before inserting into it
956: l_owner := HZ_IMP_DQM_STAGE.get_owner_name('HZ_DUP_WORKER_CHUNK_GT', 'TABLE');
957: execute immediate ' truncate table ' || l_owner || '.HZ_DUP_WORKER_CHUNK_GT';
958:
959: -- insert all the parties in the chunk to the temp table
960: FORALL I in 1..pid_list.COUNT

Line 1499: HZ_IMP_DQM_STAGE.pop_int_tca_search_tab( p_batch_id, p_match_rule_id,p_from_osr, p_to_osr,p_batch_mode_flag,

1495: -- initialize API return status to success.
1496: x_return_status := FND_API.G_RET_STS_SUCCESS;
1497:
1498: -- stage data into interface tables
1499: HZ_IMP_DQM_STAGE.pop_int_tca_search_tab( p_batch_id, p_match_rule_id,p_from_osr, p_to_osr,p_batch_mode_flag,
1500: x_return_status,x_msg_count,x_msg_data);
1501:
1502: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1503: THEN