APPS.HZ_AUTOMERGE_PKG dependencies on HZ_DUP_SET_PARTIES

Line 80: from hz_dup_set_parties

76: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
77: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
78: END IF;
79: select count(*) into l_count
80: from hz_dup_set_parties
81: where dup_set_id = P_DUP_SET_ID
82: and merge_flag = 'N' ;
83: RETURN l_count;
84: END chk_for_rem_batch;

Line 97: from hz_dup_set_parties

93: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
94: fnd_log.string(fnd_log.LEVEL_STATEMENT,G_PKG_NAME||l_procedure_name,'Enter');
95: END IF;
96: select count(*) into l_count
97: from hz_dup_set_parties
98: where dup_set_id = P_DUP_SET_ID
99: and dup_party_id <> p_winner_party_id;
100: RETURN l_count;
101: END chk_count;

Line 126: from hz_dup_set_parties

122: l_merge_type VARCHAR2(30);
123:
124: CURSOR c1(l_dup_set_id NUMBER, l_winner_party_id NUMBER) is
125: select score
126: from hz_dup_set_parties
127: where dup_set_id = l_dup_set_id
128: and dup_party_id = l_winner_party_id;
129:
130: CURSOR c2(l_dup_set_id NUMBER, l_winner_party_id NUMBER, p_state VARCHAR2) is

Line 132: from hz_dup_set_parties

128: and dup_party_id = l_winner_party_id;
129:
130: CURSOR c2(l_dup_set_id NUMBER, l_winner_party_id NUMBER, p_state VARCHAR2) is
131: select dup_party_id, score
132: from hz_dup_set_parties
133: where dup_set_id = l_dup_set_id
134: and decode(p_state, 'S', merge_flag, 'E', 'N') = 'N'
135: and dup_party_id <> l_winner_party_id;
136:

Line 160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,

156: HZ_UTILITY_V2PUB.LAST_UPDATED_BY);
157: OPEN c1(p_DUP_SET_ID, p_winner_party_id);
158: FETCH c1 into l_w_score;
159: -- insert row for the dup set and winner party id.
160: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
161: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
162: values (p_winner_party_id, l_new_dup_set_id, 'N', l_w_score, HZ_UTILITY_V2PUB.CREATED_BY,
163: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
164: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529

Line 176: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,

172: -- log (' l_score('||I||') = ' || l_score(I));
173:
174: -- insert row for a particualr dup set and all its parties which are not being
175: -- merged by automerge.
176: insert into hz_dup_set_parties(dup_party_id, dup_set_id, merge_flag, score, created_by,
177: creation_date, last_update_login, last_update_date, last_updated_by,dup_set_batch_id) --Bug No: 4244529
178: values (l_dup_party_id(I), l_new_dup_set_id, 'N', l_score(I), HZ_UTILITY_V2PUB.CREATED_BY,
179: HZ_UTILITY_V2PUB.CREATION_DATE, HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
180: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE, HZ_UTILITY_V2PUB.LAST_UPDATED_BY,p_new_dup_batch_id) ; --Bug No: 4244529

Line 202: delete from hz_dup_set_parties

198: then
199: DELETE FROM HZ_DUP_SETS
200: where DUP_SET_ID = p_DUP_SET_ID;
201:
202: delete from hz_dup_set_parties
203: where dup_set_id = p_dup_set_id;
204: end if;
205:
206: end;

Line 265: from hz_parties p, hz_dup_set_parties mp

261: WHERE dup_set_id = cp_dup_set_id;
262:
263: cursor get_active_party_count_csr(cp_dup_set_id number) is
264: select count(*)
265: from hz_parties p, hz_dup_set_parties mp
266: where p.party_id = mp.dup_party_id
267: and mp.dup_set_id = cp_dup_set_id
268: and p.status = 'A'
269: and nvl(mp.merge_flag,'Y') = 'Y';

Line 334: from hz_dup_set_parties a, hz_parties b

330: log (' l_prof_value' || l_prof_value);
331: log (' ');
332: IF l_prof_value = 'KEEP_EARLIEST_CREATED' THEN
333: l_sql_stmt1 := 'select dup_party_id
334: from hz_dup_set_parties a, hz_parties b
335: where a.dup_set_id = :1
336: and a.dup_party_id = b.party_id
337: and nvl(merge_flag, ''Y'') = ''Y''
338: and rownum = 1

Line 342: from hz_dup_set_parties a, hz_parties b

338: and rownum = 1
339: order by b.creation_date asc ' ;
340: ELSIF l_prof_value = 'KEEP_LATEST_CREATED' THEN
341: l_sql_stmt1 := 'select dup_party_id
342: from hz_dup_set_parties a, hz_parties b
343: where a.dup_set_id = :1
344: and a.dup_party_id = b.party_id
345: and nvl(merge_flag, ''Y'') = ''Y''
346: and rownum = 1

Line 414: update hz_dup_set_parties

410: set c.winner_party_id = l_winner_party_id(I)
411: where c.dup_set_id = A_DUP_SET_ID(I);
412:
413: -- update the winner party id to have merge_flag = 'Y'
414: update hz_dup_set_parties
415: set merge_flag = 'Y'
416: where dup_set_id = A_DUP_SET_ID(I)
417: and dup_party_id = l_winner_party_id(I); */
418: END IF;