APPS.HZ_MATCH_RULE_52 dependencies on HZ_SRCH_PARTIES

Line 1172: FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage

1168: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1169: IF p_search_ctx_id IS NULL THEN
1170: OPEN x_cursor FOR
1171: SELECT /*+ ORDERED */ stage.PARTY_ID , stage.TX2, stage.TX59, lpad(rtrim(stage.TX41),9,chr(48)), stage.TX45
1172: FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage
1173: WHERE
1174: srch.batch_id = -1
1175: AND
1176: (

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

1195: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1196: ELSE
1197: OPEN x_cursor FOR
1198: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_PARTIES_U1) */ stage.PARTY_ID , stage.TX2, stage.TX59, lpad(rtrim(stage.TX41),9,chr(48)), stage.TX45
1199: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTIES stage, HZ_SRCH_PARTIES srch
1200: WHERE
1201: srch.batch_id = -1
1202: AND
1203: (

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

1225: END IF;
1226: ELSE
1227: IF p_search_ctx_id IS NULL THEN
1228: l_sqlstr := 'SELECT /*+ ORDERED */ stage.PARTY_ID , stage.TX2, stage.TX59, lpad(rtrim(stage.TX41),9,chr(48)), stage.TX45'||
1229: ' FROM HZ_SRCH_PARTIES srch, HZ_STAGED_PARTIES stage'||
1230: ' WHERE'||
1231: 'srch.batch_id = -1'||
1232: 'AND'||
1233: '('||

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

4530: END IF;
4531: CLOSE l_contact_pt_cur;
4532: END IF;
4533: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4534: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4535: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4536: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4537: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4538: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

4540: END IF;
4541: EXCEPTION
4542: WHEN FND_API.G_EXC_ERROR THEN
4543: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4544: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4545: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4546: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4547: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4548: RAISE FND_API.G_EXC_ERROR;

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

4547: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4548: RAISE FND_API.G_EXC_ERROR;
4549: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4551: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4552: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4553: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4554: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4554: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: WHEN OTHERS THEN
4557: --------------- DELETE FROM ALL SRCH TABLES ---------------------
4558: DELETE FROM HZ_SRCH_PARTIES WHERE batch_id = -1 ;
4559: DELETE FROM HZ_SRCH_PSITES WHERE batch_id = -1 ;
4560: DELETE FROM HZ_SRCH_CONTACTS WHERE batch_id = -1 ;
4561: DELETE FROM HZ_SRCH_CPTS WHERE batch_id = -1 ;
4562: FND_MESSAGE.SET_NAME('AR', 'HZ_DQM_API_ERROR');

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

5102: x_stage_rec.TX46 := '';
5103: END IF;
5104: END IF;
5105: IF p_search_ctx THEN
5106: insert into HZ_SRCH_PARTIES(batch_id,party_id, party_osr,party_os,TX41,TX45,TX59,TX2,TX36,TX46) values(-1,-1,-1,-1,x_stage_rec.TX41,x_stage_rec.TX45,x_stage_rec.TX59,x_stage_rec.TX2,x_stage_rec.TX36,x_stage_rec.TX46);
5107: END IF;
5108: EXCEPTION
5109: WHEN OTHERS THEN
5110: FND_MESSAGE.SET_NAME('AR', 'HZ_TRANSFORM_PROC_ERROR');