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_MERGE_PKG dependencies on HZ_ORG_CONTACTS

Line 641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc

637: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
638: l_to_id = p_from_id) THEN
639: FOR ORG_CT IN (
640: SELECT oc.ORG_CONTACT_ID
641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
642: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
643: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
644: HZ_DQM_SYNC.stage_contact_merge(
645: 'HZ_STAGED_CONTACTS',

Line 648: 'HZ_ORG_CONTACTS',

644: HZ_DQM_SYNC.stage_contact_merge(
645: 'HZ_STAGED_CONTACTS',
646: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
647: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
648: 'HZ_ORG_CONTACTS',
649: p_batch_id,p_batch_party_id,x_return_status);
650: END LOOP;
651: END IF;
652:

Line 700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc

696: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
697: l_to_id = p_from_id) THEN
698: FOR ORG_CT IN (
699: SELECT oc.ORG_CONTACT_ID
700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
701: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
702: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
703: HZ_DQM_SYNC.stage_contact_merge(
704: 'HZ_STAGED_CONTACTS',

Line 707: 'HZ_ORG_CONTACTS',

703: HZ_DQM_SYNC.stage_contact_merge(
704: 'HZ_STAGED_CONTACTS',
705: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
706: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
707: 'HZ_ORG_CONTACTS',
708: p_batch_id,p_batch_party_id,x_return_status);
709: END LOOP;
710: END IF;
711:

Line 745: 'HZ_ORG_CONTACTS','HZ_PARTY_SITES',

741:
742: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
743: p_to_fk_id, p_par_entity_name,
744: 'HZ_MERGE_PKG.org_contact_merge',
745: 'HZ_ORG_CONTACTS','HZ_PARTY_SITES',
746: 'ORG_CONTACT_ID', 'PARTY_SITE_ID',x_return_status);
747:
748: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
749: do_org_contact_transfer(p_from_id,l_to_id, p_from_fk_id,

Line 787: 'HZ_ORG_CONTACTS','HZ_PARTY_RELATIONSHIPS',

783:
784: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
785: p_to_fk_id, p_par_entity_name,
786: 'HZ_MERGE_PKG.org_contact_merge2',
787: 'HZ_ORG_CONTACTS','HZ_PARTY_RELATIONSHIPS',
788: 'ORG_CONTACT_ID', 'PARTY_RELATIONSHIP_ID',x_return_status);
789:
790: IF (x_return_status =FND_API.G_RET_STS_SUCCESS) THEN
791: do_org_contact_transfer2(p_from_id,l_to_id, p_from_fk_id,

Line 805: 'HZ_ORG_CONTACTS',

801: HZ_DQM_SYNC.stage_contact_merge(
802: 'HZ_STAGED_CONTACTS',
803: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
804: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
805: 'HZ_ORG_CONTACTS',
806: p_batch_id,p_batch_party_id,x_return_status);
807: END LOOP;
808: END IF;
809:

Line 2173: 'HZ_ORG_CONTACT_ROLES','HZ_ORG_CONTACTS',

2169:
2170: check_params(p_entity_name, p_from_id, l_to_id, p_from_fk_id,
2171: p_to_fk_id, p_par_entity_name,
2172: 'HZ_MERGE_PKG.org_contact_role_merge',
2173: 'HZ_ORG_CONTACT_ROLES','HZ_ORG_CONTACTS',
2174: 'ORG_CONTACT_ROLE_ID', 'ORG_CONTACT_ID',x_return_status);
2175:
2176: IF (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_to_id = FND_API.G_MISS_NUM) THEN
2177: l_dup_exists := HZ_MERGE_DUP_CHECK.check_org_contact_role_dup(

Line 4056: HZ_ORG_CONTACTS OC,

4052: BEGIN
4053: SELECT 'Exists'
4054: INTO l_exists
4055: FROM HZ_RELATIONSHIPS PR,
4056: HZ_ORG_CONTACTS OC,
4057: HZ_ORG_CONTACT_ROLES OCR,
4058: HZ_RELATIONSHIPS PR2,
4059: HZ_ORG_CONTACTS OC2
4060: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'

Line 4059: HZ_ORG_CONTACTS OC2

4055: FROM HZ_RELATIONSHIPS PR,
4056: HZ_ORG_CONTACTS OC,
4057: HZ_ORG_CONTACT_ROLES OCR,
4058: HZ_RELATIONSHIPS PR2,
4059: HZ_ORG_CONTACTS OC2
4060: WHERE OCR.PRIMARY_CONTACT_PER_ROLE_TYPE = 'Y'
4061: AND OCR.ROLE_TYPE = l_role_type
4062: AND OCR.ORG_CONTACT_ID = OC.ORG_CONTACT_ID
4063: AND OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID

Line 4681: UPDATE HZ_ORG_CONTACTS

4677: BEGIN
4678:
4679: IF (x_to_id <> FND_API.G_MISS_NUM AND
4680: x_to_id <> p_from_id) THEN
4681: UPDATE HZ_ORG_CONTACTS
4682: SET
4683: STATUS = 'M',
4684: last_update_date = hz_utility_pub.last_update_date,
4685: last_updated_by = hz_utility_pub.user_id,

Line 4701: p_owner_table_name =>'HZ_ORG_CONTACTS',

4697: p_init_msg_list => FND_API.G_FALSE,
4698: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4699: p_old_owner_table_id => p_from_id,
4700: p_new_owner_table_id => x_to_id,
4701: p_owner_table_name =>'HZ_ORG_CONTACTS',
4702: p_orig_system => null,
4703: p_orig_system_reference => null,
4704: p_reason_code => 'MERGED',
4705: x_return_status => x_return_status,

Line 4717: UPDATE HZ_ORG_CONTACTS

4713: RETURN;
4714: END IF;
4715:
4716: ELSE
4717: UPDATE HZ_ORG_CONTACTS
4718: SET
4719: party_site_id = p_to_fk_id,
4720: last_update_date = hz_utility_pub.last_update_date,
4721: last_updated_by = hz_utility_pub.user_id,

Line 4749: FROM HZ_ORG_CONTACTS

4745: ) IS
4746:
4747: CURSOR c_merge_to_org_contact IS
4748: SELECT org_contact_id
4749: FROM HZ_ORG_CONTACTS
4750: WHERE party_relationship_id = p_to_fk_id;
4751:
4752: CURSOR c_org_cont_attributes(cp_org_cnt_id number) is
4753: select

Line 4768: from hz_org_contacts

4764: , RANK
4765: , NATIVE_LANGUAGE
4766: , OTHER_LANGUAGE_1
4767: , OTHER_LANGUAGE_2
4768: from hz_org_contacts
4769: where org_contact_id = cp_org_cnt_id;
4770:
4771: l_to_orgcontact_id NUMBER;
4772: l_msg_data VARCHAR2(2000);

Line 4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;

4771: l_to_orgcontact_id NUMBER;
4772: l_msg_data VARCHAR2(2000);
4773: l_msg_count NUMBER := 0;
4774:
4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;

Line 4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;

4772: l_msg_data VARCHAR2(2000);
4773: l_msg_count NUMBER := 0;
4774:
4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;

Line 4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;

4773: l_msg_count NUMBER := 0;
4774:
4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;

Line 4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;

4774:
4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;

Line 4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;

4775: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;

Line 4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;

4776: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;

Line 4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;

4777: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;

Line 4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;

4778: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;

Line 4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;

4779: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;

Line 4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;

4780: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;

Line 4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;

4781: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4789:

Line 4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;

4782: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4789:
4790: BEGIN

Line 4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;

4783: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4789:
4790: BEGIN
4791:

Line 4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;

4784: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4785: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4786: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4787: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4788: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4789:
4790: BEGIN
4791:
4792: IF (p_from_fk_id = p_to_fk_id) THEN

Line 4800: UPDATE HZ_ORG_CONTACTS

4796: OPEN c_merge_to_org_contact;
4797: FETCH c_merge_to_org_contact INTO l_to_orgcontact_id;
4798: IF c_merge_to_org_contact%NOTFOUND THEN
4799: CLOSE c_merge_to_org_contact;
4800: UPDATE HZ_ORG_CONTACTS
4801: SET
4802: party_relationship_id = p_to_fk_id,
4803: last_update_date = hz_utility_pub.last_update_date,
4804: last_updated_by = hz_utility_pub.user_id,

Line 4834: UPDATE HZ_ORG_CONTACTS

4830: L_FROM_OTHER_LANGUAGE_1,
4831: L_FROM_OTHER_LANGUAGE_2;
4832: close c_org_cont_attributes;
4833:
4834: UPDATE HZ_ORG_CONTACTS
4835: SET
4836: DEPARTMENT_CODE = DECODE(DEPARTMENT_CODE, NULL, L_FROM_DEPARTMENT_CODE,DEPARTMENT_CODE),
4837: DEPARTMENT = DECODE(DEPARTMENT, NULL, L_FROM_DEPARTMENT,DEPARTMENT ),
4838: TITLE = DECODE(TITLE, NULL, L_FROM_TITLE,TITLE),

Line 4854: UPDATE HZ_ORG_CONTACTS

4850:
4851: WHERE ORG_CONTACT_ID = l_to_orgcontact_id;
4852:
4853:
4854: UPDATE HZ_ORG_CONTACTS
4855: SET
4856: STATUS = 'M',
4857: last_update_date = hz_utility_pub.last_update_date,
4858: last_updated_by = hz_utility_pub.user_id,

Line 4874: p_owner_table_name =>'HZ_ORG_CONTACTS',

4870: p_init_msg_list => FND_API.G_FALSE,
4871: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4872: p_old_owner_table_id => p_from_id,
4873: p_new_owner_table_id => l_to_orgcontact_id,
4874: p_owner_table_name =>'HZ_ORG_CONTACTS',
4875: p_orig_system => null,
4876: p_orig_system_reference => null,
4877: p_reason_code => 'MERGED',
4878: x_return_status => x_return_status,