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 4054: HZ_ORG_CONTACTS OC,

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

Line 4057: HZ_ORG_CONTACTS OC2

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

Line 4675: UPDATE HZ_ORG_CONTACTS

4671: BEGIN
4672:
4673: IF (x_to_id <> FND_API.G_MISS_NUM AND
4674: x_to_id <> p_from_id) THEN
4675: UPDATE HZ_ORG_CONTACTS
4676: SET
4677: STATUS = 'M',
4678: last_update_date = hz_utility_pub.last_update_date,
4679: last_updated_by = hz_utility_pub.user_id,

Line 4695: p_owner_table_name =>'HZ_ORG_CONTACTS',

4691: p_init_msg_list => FND_API.G_FALSE,
4692: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4693: p_old_owner_table_id => p_from_id,
4694: p_new_owner_table_id => x_to_id,
4695: p_owner_table_name =>'HZ_ORG_CONTACTS',
4696: p_orig_system => null,
4697: p_orig_system_reference => null,
4698: p_reason_code => 'MERGED',
4699: x_return_status => x_return_status,

Line 4711: UPDATE HZ_ORG_CONTACTS

4707: RETURN;
4708: END IF;
4709:
4710: ELSE
4711: UPDATE HZ_ORG_CONTACTS
4712: SET
4713: party_site_id = p_to_fk_id,
4714: last_update_date = hz_utility_pub.last_update_date,
4715: last_updated_by = hz_utility_pub.user_id,

Line 4743: FROM HZ_ORG_CONTACTS

4739: ) IS
4740:
4741: CURSOR c_merge_to_org_contact IS
4742: SELECT org_contact_id
4743: FROM HZ_ORG_CONTACTS
4744: WHERE party_relationship_id = p_to_fk_id;
4745:
4746: CURSOR c_org_cont_attributes(cp_org_cnt_id number) is
4747: select

Line 4762: from hz_org_contacts

4758: , RANK
4759: , NATIVE_LANGUAGE
4760: , OTHER_LANGUAGE_1
4761: , OTHER_LANGUAGE_2
4762: from hz_org_contacts
4763: where org_contact_id = cp_org_cnt_id;
4764:
4765: l_to_orgcontact_id NUMBER;
4766: l_msg_data VARCHAR2(2000);

Line 4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;

4765: l_to_orgcontact_id NUMBER;
4766: l_msg_data VARCHAR2(2000);
4767: l_msg_count NUMBER := 0;
4768:
4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;

Line 4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;

4766: l_msg_data VARCHAR2(2000);
4767: l_msg_count NUMBER := 0;
4768:
4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;

Line 4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;

4767: l_msg_count NUMBER := 0;
4768:
4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;

Line 4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;

4768:
4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;

Line 4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;

4769: L_FROM_DEPARTMENT_CODE HZ_ORG_CONTACTS.DEPARTMENT_CODE%TYPE;
4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;

Line 4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;

4770: L_FROM_DEPARTMENT HZ_ORG_CONTACTS.DEPARTMENT%TYPE;
4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;

Line 4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;

4771: L_FROM_TITLE HZ_ORG_CONTACTS.TITLE%TYPE;
4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;

Line 4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;

4772: L_FROM_JOB_TITLE HZ_ORG_CONTACTS.JOB_TITLE%TYPE;
4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;

Line 4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;

4773: L_FROM_MAIL_STOP HZ_ORG_CONTACTS.MAIL_STOP%TYPE;
4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;

Line 4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;

4774: L_FROM_CONTACT_KEY HZ_ORG_CONTACTS.CONTACT_KEY%TYPE;
4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;

Line 4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;

4775: L_FROM_DECISION_MAKER_FLAG HZ_ORG_CONTACTS.DECISION_MAKER_FLAG%TYPE;
4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4783:

Line 4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;

4776: L_FROM_JOB_TITLE_CODE HZ_ORG_CONTACTS.JOB_TITLE_CODE%TYPE;
4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4783:
4784: BEGIN

Line 4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;

4777: L_FROM_MANAGED_BY HZ_ORG_CONTACTS.MANAGED_BY%TYPE;
4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4783:
4784: BEGIN
4785:

Line 4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;

4778: L_FROM_REFERENCE_USE_FLAG HZ_ORG_CONTACTS.REFERENCE_USE_FLAG%TYPE;
4779: L_FROM_RANK HZ_ORG_CONTACTS.RANK%TYPE;
4780: L_FROM_NATIVE_LANGUAGE HZ_ORG_CONTACTS.NATIVE_LANGUAGE%TYPE;
4781: L_FROM_OTHER_LANGUAGE_1 HZ_ORG_CONTACTS.OTHER_LANGUAGE_1%TYPE;
4782: L_FROM_OTHER_LANGUAGE_2 HZ_ORG_CONTACTS.OTHER_LANGUAGE_2%TYPE;
4783:
4784: BEGIN
4785:
4786: IF (p_from_fk_id = p_to_fk_id) THEN

Line 4794: UPDATE HZ_ORG_CONTACTS

4790: OPEN c_merge_to_org_contact;
4791: FETCH c_merge_to_org_contact INTO l_to_orgcontact_id;
4792: IF c_merge_to_org_contact%NOTFOUND THEN
4793: CLOSE c_merge_to_org_contact;
4794: UPDATE HZ_ORG_CONTACTS
4795: SET
4796: party_relationship_id = p_to_fk_id,
4797: last_update_date = hz_utility_pub.last_update_date,
4798: last_updated_by = hz_utility_pub.user_id,

Line 4828: UPDATE HZ_ORG_CONTACTS

4824: L_FROM_OTHER_LANGUAGE_1,
4825: L_FROM_OTHER_LANGUAGE_2;
4826: close c_org_cont_attributes;
4827:
4828: UPDATE HZ_ORG_CONTACTS
4829: SET
4830: DEPARTMENT_CODE = DECODE(DEPARTMENT_CODE, NULL, L_FROM_DEPARTMENT_CODE,DEPARTMENT_CODE),
4831: DEPARTMENT = DECODE(DEPARTMENT, NULL, L_FROM_DEPARTMENT,DEPARTMENT ),
4832: TITLE = DECODE(TITLE, NULL, L_FROM_TITLE,TITLE),

Line 4848: UPDATE HZ_ORG_CONTACTS

4844:
4845: WHERE ORG_CONTACT_ID = l_to_orgcontact_id;
4846:
4847:
4848: UPDATE HZ_ORG_CONTACTS
4849: SET
4850: STATUS = 'M',
4851: last_update_date = hz_utility_pub.last_update_date,
4852: last_updated_by = hz_utility_pub.user_id,

Line 4868: p_owner_table_name =>'HZ_ORG_CONTACTS',

4864: p_init_msg_list => FND_API.G_FALSE,
4865: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
4866: p_old_owner_table_id => p_from_id,
4867: p_new_owner_table_id => l_to_orgcontact_id,
4868: p_owner_table_name =>'HZ_ORG_CONTACTS',
4869: p_orig_system => null,
4870: p_orig_system_reference => null,
4871: p_reason_code => 'MERGED',
4872: x_return_status => x_return_status,