APPS.HZ_MATCH_RULE_51 dependencies on HZ_SRCH_PARTIES

Line 961: FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage

957: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
958: IF p_search_ctx_id IS NULL THEN
959: OPEN x_cursor FOR
960: SELECT /*+ ORDERED */ stage.PARTY_ID , stage.TX2, stage.TX59, stage.TX45
961: FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage
962: WHERE
963: srch.batch_id = -1
964: AND
965: (

Line 983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch

979: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
980: ELSE
981: OPEN x_cursor FOR
982: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , stage.TX2, stage.TX59, stage.TX45
983: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch
984: WHERE
985: srch.batch_id = -1
986: AND
987: (

Line 1008: ' FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage'||

1004: END IF;
1005: ELSE
1006: IF p_search_ctx_id IS NULL THEN
1007: l_sqlstr := 'SELECT /*+ ORDERED */ stage.PARTY_ID , stage.TX2, stage.TX59, stage.TX45'||
1008: ' FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage'||
1009: ' WHERE'||
1010: 'srch.batch_id = -1'||
1011: 'AND'||
1012: '('||

Line 4122: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

4118: END IF;
4119: CLOSE l_contact_pt_cur;
4120: END IF;
4121: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4122: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4123: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4124: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4125: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4126: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

4128: END IF;
4129: EXCEPTION
4130: WHEN FND_API.G_EXC_ERROR THEN
4131: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4132: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4133: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4134: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;

Line 4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

4135: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4136: RAISE FND_API.G_EXC_ERROR;
4137: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4138: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4139: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4140: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4141: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;

4142: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4144: WHEN OTHERS THEN
4145: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4146: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4147: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4148: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4149: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4150: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

Line 4641: insert into HZ_SRCH_PARTIES(batch_id,party_id, party_osr,party_os,TX45,TX59,TX2,TX36) values(-1,-1,-1,-1,x_stage_rec.TX45,x_stage_rec.TX59,x_stage_rec.TX2,x_stage_rec.TX36);

4637: x_stage_rec.TX36 := '';
4638: END IF;
4639: END IF;
4640: IF p_search_ctx THEN
4641: insert into HZ_SRCH_PARTIES(batch_id,party_id, party_osr,party_os,TX45,TX59,TX2,TX36) values(-1,-1,-1,-1,x_stage_rec.TX45,x_stage_rec.TX59,x_stage_rec.TX2,x_stage_rec.TX36);
4642: END IF;
4643: EXCEPTION
4644: WHEN OTHERS THEN
4645: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');