APPS.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on HZ_PARTY_V2PUB

Line 90: x_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,

86: /* private procedures, called in do_profile_attribute_merge */
87: PROCEDURE construct_organization_rec(
88: p_merge_batch_id IN NUMBER,
89: p_merge_to_party_id IN NUMBER,
90: x_organization_rec OUT NOCOPY HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE,
91: x_return_status OUT NOCOPY VARCHAR2
92: ) is
93: cursor get_org_rec_csr is
94: select attribute_name, attribute_value, attribute_type, attribute_party_id

Line 104: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;

100: l_attribute_name varchar2(30);
101: l_attribute_value varchar2(2000);
102: l_attribute_type varchar2(30);
103: l_attribute_party_id number;
104: l_organization_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
105: l_attribute_date_value date; -- Bug No:3729832
106: begin
107: -- Initialize return status to SUCCESS
108: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 122: -- out NOCOPY the columns are not supported in hz_party_v2pub.organization_rec

118: l_attribute_value := to_number(l_attribute_value);
119: end if;
120:
121: -- The following code is generated from fnd_columns, commented
122: -- out NOCOPY the columns are not supported in hz_party_v2pub.organization_rec
123: IF L_ATTRIBUTE_NAME = 'BEST_TIME_CONTACT_END' THEN
124: L_ORGANIZATION_REC.BEST_TIME_CONTACT_END := l_attribute_date_value;--L_ATTRIBUTE_VALUE; -- Bug No:3729832
125: ELSIF L_ATTRIBUTE_NAME = 'ORGANIZATION_NAME_PHONETIC' THEN
126: L_ORGANIZATION_REC.ORGANIZATION_NAME_PHONETIC := L_ATTRIBUTE_VALUE;

Line 501: x_person_rec OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,

497: PROCEDURE construct_person_rec(
498: p_merge_batch_id IN NUMBER,
499: p_merge_to_party_id IN NUMBER,
500: p_orig_sys_ref IN VARCHAR2,
501: x_person_rec OUT NOCOPY HZ_PARTY_V2PUB.PERSON_REC_TYPE,
502: x_return_status OUT NOCOPY VARCHAR2
503: ) is
504: cursor get_person_rec_csr is
505: select attribute_name, attribute_value, attribute_type

Line 514: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

510:
511: l_attribute_name varchar2(30);
512: l_attribute_value varchar2(2000);
513: l_attribute_type varchar2(30);
514: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
515: l_attribute_date_value date; -- Bug No:3729832
516: begin
517: -- Initialize return status to SUCCESS
518: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 533: -- out NOCOPY the columns are not supported in hz_party_v2pub.person_rec

529: l_attribute_value := to_number(l_attribute_value);
530: end if;
531:
532: -- The following code is generated from fnd_columns, commented
533: -- out NOCOPY the columns are not supported in hz_party_v2pub.person_rec
534:
535: IF (NVL(p_orig_sys_ref,'X') LIKE 'PER:%') THEN -- bug no: 4193165
536:
537: IF (NVL(FND_PROFILE.VALUE('HZ_CREATED_BY_MODULE'), '-222') <> 'HR API') THEN

Line 819: l_org_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;

815: p_entity_name IN VARCHAR2,
816: x_return_status OUT NOCOPY VARCHAR2
817: ) is
818:
819: l_org_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
820: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
821: l_profile_id number;
822: l_msg_count number;
823: l_msg_data varchar2(2000);

Line 820: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;

816: x_return_status OUT NOCOPY VARCHAR2
817: ) is
818:
819: l_org_rec HZ_PARTY_V2PUB.ORGANIZATION_REC_TYPE;
820: l_person_rec HZ_PARTY_V2PUB.PERSON_REC_TYPE;
821: l_profile_id number;
822: l_msg_count number;
823: l_msg_data varchar2(2000);
824: l_object_version_number number;

Line 868: Hz_party_v2pub.update_organization (

864: close get_obj_version_csr;
865:
866: Construct_organization_rec(p_merge_batch_id,p_merge_to_party_id,l_org_rec,x_return_status);
867:
868: Hz_party_v2pub.update_organization (
869: p_init_msg_list => FND_API.G_FALSE,
870: p_organization_rec => l_org_rec,
871: p_party_object_version_number =>l_object_version_number,
872: x_profile_id => l_profile_id,

Line 904: Hz_party_v2pub.update_person (

900: close get_obj_version_csr;
901:
902: Construct_person_rec(p_merge_batch_id, p_merge_to_party_id, l_orig_sys_ref,l_person_rec,x_return_status);
903:
904: Hz_party_v2pub.update_person (
905: p_init_msg_list => FND_API.G_FALSE,
906: p_person_rec => l_person_rec,
907: p_party_object_version_number => l_object_version_number,
908: x_profile_id => l_profile_id,