DBA Data[Home] [Help]

APPS.OTA_RA_CON_API dependencies on HZ_PARTY_V2PUB

Line 144: -- Update person party using HZ_PARTY_V2PUB V2 APIs

140: AND ACCT_ROLE.CUST_ACCOUNT_ID = ROLE_ACCT.CUST_ACCOUNT_ID
141: AND ROLE_ACCT.PARTY_ID = REL.OBJECT_ID
142: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id;
143:
144: -- Update person party using HZ_PARTY_V2PUB V2 APIs
145:
146: l_sql_stat := ' Declare
147: per_rec HZ_PARTY_V2PUB.person_rec_type;
148: party_rec HZ_PARTY_V2PUB.party_rec_type;

Line 147: per_rec HZ_PARTY_V2PUB.person_rec_type;

143:
144: -- Update person party using HZ_PARTY_V2PUB V2 APIs
145:
146: l_sql_stat := ' Declare
147: per_rec HZ_PARTY_V2PUB.person_rec_type;
148: party_rec HZ_PARTY_V2PUB.party_rec_type;
149: Begin
150: per_rec.party_rec.party_id := :x_party_id;
151: per_rec.party_rec.status := ''A'';

Line 148: party_rec HZ_PARTY_V2PUB.party_rec_type;

144: -- Update person party using HZ_PARTY_V2PUB V2 APIs
145:
146: l_sql_stat := ' Declare
147: per_rec HZ_PARTY_V2PUB.person_rec_type;
148: party_rec HZ_PARTY_V2PUB.party_rec_type;
149: Begin
150: per_rec.party_rec.party_id := :x_party_id;
151: per_rec.party_rec.status := ''A'';
152: per_rec.person_first_name := :p_first_name;

Line 156: HZ_PARTY_V2PUB.update_person(

152: per_rec.person_first_name := :p_first_name;
153: per_rec.person_last_name := :p_last_name;
154: per_rec.person_title := :p_title;
155:
156: HZ_PARTY_V2PUB.update_person(
157: null,
158: per_rec,
159: :x_party_object_version_number,
160: :x_profile_id,

Line 283: per_rec HZ_PARTY_V2PUB.person_rec_type ;

279: l_sql_stat VARCHAR2(4000);
280: l_sql_stat_2 VARCHAR2(4000);
281: l_sql_stat_3 VARCHAR2(4000);
282: l_created_by_module varchar2(150);
283: per_rec HZ_PARTY_V2PUB.person_rec_type ;
284: party_rec HZ_PARTY_V2PUB.party_rec_type ;
285: ocon_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type ;
286: party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type ;
287: arole_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;

Line 284: party_rec HZ_PARTY_V2PUB.party_rec_type ;

280: l_sql_stat_2 VARCHAR2(4000);
281: l_sql_stat_3 VARCHAR2(4000);
282: l_created_by_module varchar2(150);
283: per_rec HZ_PARTY_V2PUB.person_rec_type ;
284: party_rec HZ_PARTY_V2PUB.party_rec_type ;
285: ocon_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type ;
286: party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type ;
287: arole_rec HZ_CUST_ACCOUNT_ROLE_V2PUB.cust_account_role_rec_type;
288:

Line 304: HZ_PARTY_V2PUB.create_person(

300: per_rec.person_last_name := x_last_name;
301: per_rec.person_title := x_title;
302: per_rec.created_by_module := l_created_by_module;
303:
304: HZ_PARTY_V2PUB.create_person(
305: l_temp,
306: per_rec,
307: i_subject_party_id,
308: i_subject_party_number,