eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_MERGE dependencies on HZ_CONTACT_POINTS

Line 344: AND ENTITY_NAME = 'HZ_CONTACT_POINTS'

340: CURSOR c_batch_contact_points(cp_batch_party_id NUMBER) IS
341: SELECT merge_from_entity_id, merge_to_entity_id
342: FROM HZ_MERGE_PARTY_DETAILS
343: WHERE batch_party_id = cp_batch_party_id
344: AND ENTITY_NAME = 'HZ_CONTACT_POINTS'
345: AND merge_from_entity_id <> merge_to_entity_id;
346:
347: -----Cursor for the merge of Relationships/Contacts within the same party-----
348: CURSOR c_batch_relationships(cp_batch_party_id NUMBER) IS

Line 427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

423:
424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
426:
427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
429:
430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

Line 428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;

424: l_from_site_id HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE;
425: l_to_site_id HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE;
426:
427: l_from_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
428: l_to_cp_id HZ_CONTACT_POINTS.CONTACT_POINT_ID%TYPE;
429:
430: l_from_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
431: l_to_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;
432:

Line 818: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');

814: CLOSE c_batch_party_sites;
815:
816: --if the prev. merge was success only then do the next step
817: if l_return_status = FND_API.G_RET_STS_SUCCESS then
818: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
819: FETCH c_dict_id INTO l_dict_id;
820: IF c_dict_id%NOTFOUND THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');

Line 822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');

818: OPEN c_dict_id(l_rule_set_name,'HZ_CONTACT_POINTS');
819: FETCH c_dict_id INTO l_dict_id;
820: IF c_dict_id%NOTFOUND THEN
821: FND_MESSAGE.SET_NAME('AR', 'HZ_INVALID_DICT_ENTRY');
822: FND_MESSAGE.SET_TOKEN('ENTITY' ,'HZ_CONTACT_POINTS');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: END IF;
826: CLOSE c_dict_id;

Line 845: p_entity_name =>'HZ_CONTACT_POINTS',

841:
842: -- Perform the Contact Points merge
843: do_merge(
844: p_batch_party_id =>l_batch_party_id,
845: p_entity_name =>'HZ_CONTACT_POINTS',
846: p_par_entity_name =>NULL,
847: p_from_id =>l_from_cp_id,
848: p_to_id =>l_to_cp_id,
849: p_par_from_id =>l_pre_merge_to_party_id, --5093366 passing party_id to do_merge for history

Line 4108: -- Handle DNB data in HZ_CONTACT_POINTS

4104: END;
4105: END LOOP;
4106:
4107: -- *******************************************
4108: -- Handle DNB data in HZ_CONTACT_POINTS
4109:
4110:
4111: FOR FROM_CP IN (
4112: SELECT contact_point_id, phone_line_type, contact_point_type

Line 4113: FROM HZ_CONTACT_POINTS

4109:
4110:
4111: FOR FROM_CP IN (
4112: SELECT contact_point_id, phone_line_type, contact_point_type
4113: FROM HZ_CONTACT_POINTS
4114: WHERE owner_table_name = 'HZ_PARTIES'
4115: AND actual_content_source = 'DNB'
4116: AND nvl(status, 'A') = 'A'
4117: AND owner_table_id = p_from_id) LOOP

Line 4122: FROM HZ_CONTACT_POINTS

4118: case_new := 'FALSE';
4119: BEGIN
4120: BEGIN
4121: SELECT contact_point_id INTO l_to
4122: FROM HZ_CONTACT_POINTS
4123: WHERE owner_table_name = 'HZ_PARTIES'
4124: AND actual_content_source = 'DNB'
4125: AND nvl(phone_line_type,'X') = nvl(FROM_CP.phone_line_type,'X')--bug 5221273
4126: AND contact_point_type = FROM_CP.contact_point_type --bug 5221273

Line 4142: Select 'True' INTO case_new FROM HZ_CONTACT_POINTS

4138: -- Merge to into from
4139: --If Exactly same then Merge
4140:
4141: BEGIN
4142: Select 'True' INTO case_new FROM HZ_CONTACT_POINTS
4143: WHERE contact_point_id = FROM_CP.contact_point_id
4144: AND (CONTACT_POINT_TYPE ||
4145: STATUS ||
4146: EDI_TRANSACTION_HANDLING ||

Line 4197: FROM HZ_CONTACT_POINTS

4193: PHONE_EXTENSION ||
4194: PHONE_LINE_TYPE ||
4195: TELEX_NUMBER ||
4196: WEB_TYPE
4197: FROM HZ_CONTACT_POINTS
4198: WHERE contact_point_id = l_to)
4199: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4200: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4201: FROM HZ_CONTACT_POINTS

Line 4201: FROM HZ_CONTACT_POINTS

4197: FROM HZ_CONTACT_POINTS
4198: WHERE contact_point_id = l_to)
4199: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4200: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4201: FROM HZ_CONTACT_POINTS
4202: WHERE contact_point_id = l_to)
4203: AND nvl(URL, 'NOURL') = (
4204: SELECT nvl(URL, 'NOURL')
4205: FROM HZ_CONTACT_POINTS

Line 4205: FROM HZ_CONTACT_POINTS

4201: FROM HZ_CONTACT_POINTS
4202: WHERE contact_point_id = l_to)
4203: AND nvl(URL, 'NOURL') = (
4204: SELECT nvl(URL, 'NOURL')
4205: FROM HZ_CONTACT_POINTS
4206: WHERE contact_point_id = l_to);
4207:
4208: EXCEPTION
4209: WHEN NO_DATA_FOUND THEN

Line 4217: 'HZ_CONTACT_POINTS',

4213:
4214: IF case_new = 'True' THEN
4215: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4216: p_batch_party_id,
4217: 'HZ_CONTACT_POINTS',
4218: l_to,
4219: FROM_CP.contact_point_id,
4220: 'T',
4221: hz_utility_pub.created_by,

Line 4227: UPDATE HZ_CONTACT_POINTS

4223: hz_utility_pub.last_update_login,
4224: hz_utility_pub.last_update_date,
4225: hz_utility_pub.last_updated_by);
4226: ELSE
4227: UPDATE HZ_CONTACT_POINTS
4228: SET actual_content_source = 'USER_ENTERED',
4229: last_update_date =hz_utility_pub.last_update_date,
4230: last_updated_by = hz_utility_pub.last_updated_by,
4231: last_update_login=hz_utility_pub.last_update_login,

Line 4248: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

4244: request_id = hz_utility_pub.request_id,
4245: program_application_id = hz_utility_pub.program_application_id,
4246: program_id = hz_utility_pub.program_id,
4247: program_update_date = sysdate
4248: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4249: AND OWNER_TABLE_ID = l_to
4250: AND ORIG_SYSTEM = 'DNB'
4251: AND STATUS = 'A';
4252: END IF;

Line 4258: Select 'True' INTO case_new FROM HZ_CONTACT_POINTS

4254: -- Merge from into to
4255: --Perform Exact Dup check
4256:
4257: BEGIN
4258: Select 'True' INTO case_new FROM HZ_CONTACT_POINTS
4259: WHERE contact_point_id = FROM_CP.contact_point_id
4260: AND
4261: CONTACT_POINT_TYPE ||
4262: STATUS ||

Line 4314: FROM HZ_CONTACT_POINTS

4310: PHONE_EXTENSION ||
4311: PHONE_LINE_TYPE ||
4312: TELEX_NUMBER ||
4313: WEB_TYPE
4314: FROM HZ_CONTACT_POINTS
4315: WHERE contact_point_id = l_to)
4316: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4317: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4318: FROM HZ_CONTACT_POINTS

Line 4318: FROM HZ_CONTACT_POINTS

4314: FROM HZ_CONTACT_POINTS
4315: WHERE contact_point_id = l_to)
4316: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4317: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4318: FROM HZ_CONTACT_POINTS
4319: WHERE contact_point_id = l_to)
4320: AND nvl(URL, 'NOURL') = (
4321: SELECT nvl(URL, 'NOURL')
4322: FROM HZ_CONTACT_POINTS

Line 4322: FROM HZ_CONTACT_POINTS

4318: FROM HZ_CONTACT_POINTS
4319: WHERE contact_point_id = l_to)
4320: AND nvl(URL, 'NOURL') = (
4321: SELECT nvl(URL, 'NOURL')
4322: FROM HZ_CONTACT_POINTS
4323: WHERE contact_point_id = l_to);
4324:
4325: EXCEPTION
4326: WHEN No_Data_Found THEN

Line 4334: 'HZ_CONTACT_POINTS',

4330:
4331: IF case_new = 'True' THEN --Populate HZ_MERGE_PARTY_DETAILS
4332: HZ_MERGE_PARTY_DETAILS_PKG.Insert_Row(
4333: p_batch_party_id,
4334: 'HZ_CONTACT_POINTS',
4335: FROM_CP.contact_point_id,
4336: l_to,
4337: 'Y',
4338: hz_utility_pub.created_by,

Line 4344: UPDATE HZ_CONTACT_POINTS

4340: hz_utility_pub.last_update_login,
4341: hz_utility_pub.last_update_date,
4342: hz_utility_pub.last_updated_by);
4343: ELSE
4344: UPDATE HZ_CONTACT_POINTS
4345: SET actual_content_source = 'USER_ENTERED',
4346: last_update_date =hz_utility_pub.last_update_date,
4347: last_updated_by = hz_utility_pub.last_updated_by,
4348: last_update_login=hz_utility_pub.last_update_login,

Line 4365: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'

4361: request_id = hz_utility_pub.request_id,
4362: program_application_id = hz_utility_pub.program_application_id,
4363: program_id = hz_utility_pub.program_id,
4364: program_update_date = sysdate
4365: WHERE OWNER_TABLE_NAME = 'HZ_CONTACT_POINTS'
4366: AND OWNER_TABLE_ID =FROM_CP.contact_point_id
4367: AND ORIG_SYSTEM = 'DNB'
4368: AND STATUS = 'A';
4369: END IF;