DBA Data[Home] [Help]

APPS.POS_SUPP_CONTACT_PKG dependencies on HZ_PARTY_V2PUB

Line 19: l_rel_party_rec hz_party_v2pub.party_rec_type;

15: p_department IN VARCHAR2 DEFAULT NULL
16: )
17: IS
18: l_rel_rec hz_relationship_v2pub.relationship_rec_type;
19: l_rel_party_rec hz_party_v2pub.party_rec_type;
20: l_rel_party_number hz_parties.party_number%TYPE;
21: l_rel_id NUMBER;
22: l_rel_party_id NUMBER;
23: l_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;

Line 80: p_prefix => 'call hz_party_v2pub.create_person',

76: );
77:
78: pos_log.log_call_result
79: (p_module => 'POSCONTB',
80: p_prefix => 'call hz_party_v2pub.create_person',
81: p_return_status => x_return_status,
82: p_msg_count => x_msg_count,
83: p_msg_data => x_msg_data
84: );

Line 118: l_person_party_rec hz_party_v2pub.party_rec_type;

114: p_alt_phone_number IN VARCHAR2 DEFAULT NULL,
115: p_url IN VARCHAR2 DEFAULT NULL
116: )
117: IS
118: l_person_party_rec hz_party_v2pub.party_rec_type;
119: l_person_party_number hz_parties.party_number%TYPE;
120: l_person_rec hz_party_v2pub.person_rec_type;
121: l_person_profile_id NUMBER;
122: l_method VARCHAR2(30);

Line 120: l_person_rec hz_party_v2pub.person_rec_type;

116: )
117: IS
118: l_person_party_rec hz_party_v2pub.party_rec_type;
119: l_person_party_number hz_parties.party_number%TYPE;
120: l_person_rec hz_party_v2pub.person_rec_type;
121: l_person_profile_id NUMBER;
122: l_method VARCHAR2(30);
123: l_step VARCHAR2(100);
124: l_rel_party_id NUMBER;

Line 178: hz_party_v2pub.create_person

174: || ' person_pre_name_adjunct ' || l_person_rec.person_pre_name_adjunct
175: );
176: END IF;
177:
178: hz_party_v2pub.create_person
179: (p_init_msg_list => fnd_api.g_false,
180: p_person_rec => l_person_rec,
181: p_party_usage_code => 'SUPPLIER_CONTACT',
182: x_return_status => x_return_status,

Line 199: p_prefix => 'call hz_party_v2pub.create_person',

195: /* End */
196:
197: pos_log.log_call_result
198: (p_module => 'POSCONTB',
199: p_prefix => 'call hz_party_v2pub.create_person',
200: p_return_status => x_return_status,
201: p_msg_count => x_msg_count,
202: p_msg_data => x_msg_data
203: );

Line 459: l_person_rec hz_party_v2pub.person_rec_type;

455: FROM hz_parties
456: WHERE party_id = p_contact_party_id;
457:
458: l_contact_party_rec l_contact_party_cur%ROWTYPE;
459: l_person_rec hz_party_v2pub.person_rec_type;
460: l_party_rec hz_party_v2pub.party_rec_type;
461: l_profile_id NUMBER;
462: /*For BUG 7938942 as part of l_cur2 adding department field also*/
463: CURSOR l_cur2 IS

Line 460: l_party_rec hz_party_v2pub.party_rec_type;

456: WHERE party_id = p_contact_party_id;
457:
458: l_contact_party_rec l_contact_party_cur%ROWTYPE;
459: l_person_rec hz_party_v2pub.person_rec_type;
460: l_party_rec hz_party_v2pub.party_rec_type;
461: l_profile_id NUMBER;
462: /*For BUG 7938942 as part of l_cur2 adding department field also*/
463: CURSOR l_cur2 IS
464: SELECT hoc.org_contact_id,

Line 709: hz_party_v2pub.update_person

705:
706: /* Bug 7027825 , For Updating A Person Party Type We need to pass the object version number of the
707: PERSON record ,So changed the below object version number parameter to l_person_party_obversion_num */
708:
709: hz_party_v2pub.update_person
710: (p_init_msg_list => fnd_api.g_true,
711: p_person_rec => l_person_rec,
712: p_party_object_version_number => l_person_party_obversion_num,
713: x_profile_id => l_profile_id,