APPS.OE_OE_INLINE_ADDRESS dependencies on HZ_PARTIES

Line 132: x_rel_party_number hz_parties.party_number%TYPE;

128: x_party_number varchar2(50);
129: x_profile_id number;
130:
131: x_rel_party_id number;
132: x_rel_party_number hz_parties.party_number%TYPE;
133: x_party_relationship_id number;
134:
135: l_org_contact_rec hz_party_contact_v2pub.org_contact_rec_type;
136: x_org_contact_id number;

Line 194: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

190: l_org_contact_rec.party_rel_rec.object_id := p_party_id;
191: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
192: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
193: l_org_contact_rec.party_rel_rec.start_date := sysdate;
194: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
195: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
196: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
197: l_org_contact_rec.party_rel_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
198:

Line 195: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';

191: l_org_contact_rec.party_rel_rec.relationship_type := 'CONTACT';
192: l_org_contact_rec.party_rel_rec.relationship_code := 'CONTACT_OF';
193: l_org_contact_rec.party_rel_rec.start_date := sysdate;
194: l_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';
195: l_org_contact_rec.party_rel_rec.object_table_name := 'HZ_PARTIES';
196: l_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
197: l_org_contact_rec.party_rel_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
198:
199:

Line 202: From HZ_PARTIES

198:
199:
200: Select party_type
201: Into l_org_contact_rec.party_rel_rec.object_type
202: From HZ_PARTIES
203: Where party_id = p_party_id;
204:
205: if l_gen_contact_number = 'N' then
206:

Line 345: from hz_parties

341: end if;
342:
343: select party_name
344: into x_contact_name
345: from hz_parties
346: where party_id = x_party_id;
347:
348: x_contact_id := x_cust_account_role_id;
349:

Line 423: AND owner_table_name = 'HZ_PARTIES'

419: /*CURSOR c_email IS
420: SELECT email_address
421: FROM hz_contact_points
422: WHERE owner_table_id = p_contact_party_id
423: AND owner_table_name = 'HZ_PARTIES'
424: AND contact_point_type = 'EMAIL'
425: AND primary_flag = 'Y'
426: AND status = 'A'; */
427:

Line 430: fROM hz_parties

426: AND status = 'A'; */
427:
428: CURSOR c_email IS
429: SELECT email_address
430: fROM hz_parties
431: where party_id = p_contact_party_id;
432:
433: l_email hz_parties.email_address%TYPE;
434: l_create_email boolean := FALSE;

Line 433: l_email hz_parties.email_address%TYPE;

429: SELECT email_address
430: fROM hz_parties
431: where party_id = p_contact_party_id;
432:
433: l_email hz_parties.email_address%TYPE;
434: l_create_email boolean := FALSE;
435:
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 635: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';

631: BEGIN
632:
633: l_contact_points_rec.contact_point_type := in_contact_point_type;
634: l_contact_points_rec.status := 'A';
635: l_contact_points_rec.owner_table_name := 'HZ_PARTIES';
636: l_contact_points_rec.owner_table_id := in_owner_table_id;
637: l_contact_points_rec.primary_flag := 'Y';
638: l_contact_points_rec.created_by_module := NVL(p_created_by_module,G_CREATED_BY_MODULE);
639:

Line 1583: x_party_number hz_parties.party_number%TYPE;

1579:
1580: ) IS
1581:
1582: x_party_id number;
1583: x_party_number hz_parties.party_number%TYPE;
1584:
1585: --
1586: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1587: --

Line 2003: from hz_parties

1999:
2000:
2001: select party_name
2002: into out_cust_name
2003: from hz_parties
2004: where party_id = x_party_id;
2005:
2006: else
2007: out_cust_id := in_cust_account_id;

Line 2020: hz_parties party

2016: out_cust_name,
2017: out_cust_number,
2018: out_party_number
2019: from hz_cust_accounts acct,
2020: hz_parties party
2021: where acct.cust_account_id = in_cust_account_id
2022: and party.party_id = acct.party_id;
2023:
2024: