DBA Data[Home] [Help]

APPS.IBU_HZ_PERSON dependencies on HZ_PERSON_INFO_V2PUB

Line 21: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists

17: | it creates a new one and makes it primary
18: |
19: | REFERENCED APIS
20: | This API calls the following APIs
21: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists
22: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists
23: +======================================================================*/
24:
25: PROCEDURE Update_Person_Language(

Line 22: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists

18: |
19: | REFERENCED APIS
20: | This API calls the following APIs
21: | - HZ_PERSON_INFO_V2PUB.create_person_language if no row exists
22: | - HZ_PERSON_INFO_V2PUB.update_person_language if row exists
23: +======================================================================*/
24:
25: PROCEDURE Update_Person_Language(
26: p_party_id IN NUMBER,

Line 46: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;

42: FROM HZ_RELATIONSHIPS
43: WHERE PARTY_ID = p_party_id
44: AND SUBJECT_TYPE = 'PERSON';
45:
46: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;
47: l_id NUMBER;
48: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;
49: l_language_use_reference_id number;
50: l_object_version_number NUMBER;

Line 48: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;

44: AND SUBJECT_TYPE = 'PERSON';
45:
46: l_per_language_rec hz_person_info_v2pub.person_language_rec_type;
47: l_id NUMBER;
48: l_per_language_rec2 hz_person_info_v2pub.person_language_rec_type;
49: l_language_use_reference_id number;
50: l_object_version_number NUMBER;
51: l_party_type VARCHAR2(100);
52: l_person_party NUMBER;

Line 96: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary';

92:
93: l_per_language_rec.primary_language_indicator := 'N';
94: l_per_language_rec.language_use_reference_id := l_id;
95:
96: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary';
97:
98: hz_person_info_v2pub.update_person_language(
99: p_person_language_rec => l_per_language_rec,
100: p_object_version_number => l_object_version_number,

Line 98: hz_person_info_v2pub.update_person_language(

94: l_per_language_rec.language_use_reference_id := l_id;
95:
96: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to unset primary';
97:
98: hz_person_info_v2pub.update_person_language(
99: p_person_language_rec => l_per_language_rec,
100: p_object_version_number => l_object_version_number,
101: x_return_status => x_return_status,
102: x_msg_count => x_msg_count,

Line 105: x_debug_buf := x_debug_buf || ' After Call HZ_PERSON_INFO_V2PUB.update_person_language APIto unset primary';

101: x_return_status => x_return_status,
102: x_msg_count => x_msg_count,
103: x_msg_data => x_msg_data);
104:
105: x_debug_buf := x_debug_buf || ' After Call HZ_PERSON_INFO_V2PUB.update_person_language APIto unset primary';
106: EXCEPTION WHEN NO_DATA_FOUND THEN
107: NULL;
108: END;
109: --end unset primary language indicator

Line 124: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary';

120: l_per_language_rec2.primary_language_indicator := 'Y';
121: l_per_language_rec2.language_use_reference_id := l_id;
122:
123:
124: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary';
125: hz_person_info_v2pub.update_person_language(
126: p_person_language_rec => l_per_language_rec2,
127: p_object_version_number => l_object_version_number,
128: x_return_status => x_return_status,

Line 125: hz_person_info_v2pub.update_person_language(

121: l_per_language_rec2.language_use_reference_id := l_id;
122:
123:
124: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary';
125: hz_person_info_v2pub.update_person_language(
126: p_person_language_rec => l_per_language_rec2,
127: p_object_version_number => l_object_version_number,
128: x_return_status => x_return_status,
129: x_msg_count => x_msg_count,

Line 132: x_debug_buf := x_debug_buf || 'After Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary';

128: x_return_status => x_return_status,
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data);
131:
132: x_debug_buf := x_debug_buf || 'After Call HZ_PERSON_INFO_V2PUB.update_person_language API to set primary';
133: EXCEPTION WHEN NO_DATA_FOUND THEN
134: l_per_language_rec2.primary_language_indicator := 'Y';
135: l_per_language_rec2.party_id := l_party_id;
136: l_per_language_rec2.language_name := p_language_name;

Line 139: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary';

135: l_per_language_rec2.party_id := l_party_id;
136: l_per_language_rec2.language_name := p_language_name;
137: l_per_language_rec2.created_by_module := p_created_by_module;
138:
139: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary';
140: hz_person_info_v2pub.create_person_language(
141: p_person_language_rec => l_per_language_rec2,
142: x_language_use_reference_id => l_language_use_reference_id,
143: x_return_status => x_return_status,

Line 140: hz_person_info_v2pub.create_person_language(

136: l_per_language_rec2.language_name := p_language_name;
137: l_per_language_rec2.created_by_module := p_created_by_module;
138:
139: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary';
140: hz_person_info_v2pub.create_person_language(
141: p_person_language_rec => l_per_language_rec2,
142: x_language_use_reference_id => l_language_use_reference_id,
143: x_return_status => x_return_status,
144: x_msg_count => x_msg_count,

Line 146: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary';

142: x_language_use_reference_id => l_language_use_reference_id,
143: x_return_status => x_return_status,
144: x_msg_count => x_msg_count,
145: x_msg_data => x_msg_data);
146: x_debug_buf := x_debug_buf || 'Call HZ_PERSON_INFO_V2PUB.create_person_language API to set primary';
147:
148: END;
149: --end set primary language indicator
150: