eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_OR_CONTACTS_PKG dependencies on HZ_PARTIES

Line 30: g_own_tab_name CONSTANT VARCHAR2(10) := 'HZ_PARTIES';

26: */
27:
28: g_email CONSTANT VARCHAR2(10) := 'EMAIL';
29: g_status CONSTANT VARCHAR2(1) := 'A';
30: g_own_tab_name CONSTANT VARCHAR2(10) := 'HZ_PARTIES';
31: g_contact_of CONSTANT VARCHAR2(15) := 'CONTACT_OF';
32: g_contact CONSTANT VARCHAR2(20) := 'CONTACT';
33:
34: FUNCTION get_error_msg(p_msg_cnt IN NUMBER) RETURN VARCHAR2 AS

Line 158: l_party_number hz_parties.party_number%TYPE;

154: l_party_rec hz_party_v2pub.party_rec_type;
155: org_rel_rec hz_relationship_v2pub.relationship_rec_type;
156:
157: l_var VARCHAR2(1);
158: l_party_number hz_parties.party_number%TYPE;
159: l_party_relationship_id hz_relationships.relationship_id%TYPE;
160: l_party_id hz_parties.party_id%TYPE;
161: l_contact_point_id NUMBER(10);
162:

Line 160: l_party_id hz_parties.party_id%TYPE;

156:
157: l_var VARCHAR2(1);
158: l_party_number hz_parties.party_number%TYPE;
159: l_party_relationship_id hz_relationships.relationship_id%TYPE;
160: l_party_id hz_parties.party_id%TYPE;
161: l_contact_point_id NUMBER(10);
162:
163: tmp_var1 VARCHAR2(2000);
164: tmp_var VARCHAR2(2000);

Line 166: lv_party_number hz_parties.party_number%TYPE;

162:
163: tmp_var1 VARCHAR2(2000);
164: tmp_var VARCHAR2(2000);
165:
166: lv_party_number hz_parties.party_number%TYPE;
167: lv_contact_party_number hz_parties.party_number%TYPE;
168:
169: -- Cursor for checking if the record exists in the
170: -- IGS_OR_CONTACTS_V for the Org Party Id and the

Line 167: lv_contact_party_number hz_parties.party_number%TYPE;

163: tmp_var1 VARCHAR2(2000);
164: tmp_var VARCHAR2(2000);
165:
166: lv_party_number hz_parties.party_number%TYPE;
167: lv_contact_party_number hz_parties.party_number%TYPE;
168:
169: -- Cursor for checking if the record exists in the
170: -- IGS_OR_CONTACTS_V for the Org Party Id and the
171: -- Contact Party Id

Line 179: REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND

175: FROM hz_relationships rel
176: WHERE object_id = cp_org_party_id AND
177: subject_id = cp_contact_party_id AND
178: REL.SUBJECT_TYPE = 'PERSON' AND
179: REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND
180: REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND
181: REL.DIRECTIONAL_FLAG = 'F' AND
182: REL.RELATIONSHIP_TYPE = 'CONTACT';
183:

Line 180: REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND

176: WHERE object_id = cp_org_party_id AND
177: subject_id = cp_contact_party_id AND
178: REL.SUBJECT_TYPE = 'PERSON' AND
179: REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND
180: REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND
181: REL.DIRECTIONAL_FLAG = 'F' AND
182: REL.RELATIONSHIP_TYPE = 'CONTACT';
183:
184:

Line 189: FROM hz_parties

185: FUNCTION get_party_number ( p_party_id number)
186: RETURN VARCHAR2 IS
187: CURSOR c_party IS
188: SELECT party_number
189: FROM hz_parties
190: WHERE party_id = p_party_id;
191:
192: lv_party_number VARCHAR2(30);
193:

Line 268: org_rel_rec.subject_table_name := 'HZ_PARTIES';

264: ocon_rec.attribute18 := x_attribute18;
265: ocon_rec.attribute19 := x_attribute19;
266: ocon_rec.attribute20 := x_attribute20;
267: org_rel_rec.subject_type := 'PERSON';
268: org_rel_rec.subject_table_name := 'HZ_PARTIES';
269: org_rel_rec.object_type := 'ORGANIZATION';
270: org_rel_rec.object_table_name := 'HZ_PARTIES';
271: org_rel_rec.relationship_code := g_contact_of;
272:

Line 270: org_rel_rec.object_table_name := 'HZ_PARTIES';

266: ocon_rec.attribute20 := x_attribute20;
267: org_rel_rec.subject_type := 'PERSON';
268: org_rel_rec.subject_table_name := 'HZ_PARTIES';
269: org_rel_rec.object_type := 'ORGANIZATION';
270: org_rel_rec.object_table_name := 'HZ_PARTIES';
271: org_rel_rec.relationship_code := g_contact_of;
272:
273: -- Generating And Passing the party number if the profile value is set to 'No' for generating the party number
274: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

Line 452: l_party_id hz_parties.party_id%TYPE;

448: ocon_rec hz_party_contact_v2pub.org_contact_rec_type;
449: cpoint_rec hz_contact_point_v2pub.contact_point_rec_type;
450: email_rec hz_contact_point_v2pub.email_rec_type;
451: org_rel_rec hz_relationship_v2pub.relationship_rec_type;
452: l_party_id hz_parties.party_id%TYPE;
453: l_last_update_date DATE;
454: l_contact_point_id NUMBER(20);
455: tmp_var1 VARCHAR2(2000);
456: tmp_var VARCHAR2(2000);

Line 467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;

463:
464: l_obj_ver hz_contact_points.object_version_number%TYPE;
465: l_org_contacts_obj_ver_num hz_org_contacts.object_version_number%TYPE;
466: l_rel_obj_ver_num hz_org_contacts.object_version_number%TYPE;
467: l_hz_parties_obj_ver_num hz_org_contacts.object_version_number%TYPE;
468:
469: BEGIN
470:
471: -- Assign the values to the Org Contact Record

Line 499: org_rel_rec.subject_table_name := 'HZ_PARTIES';

495: ocon_rec.attribute19 := NVL(x_Attribute19,FND_API.G_MISS_CHAR);
496: ocon_rec.attribute20 := NVL(x_Attribute20,FND_API.G_MISS_CHAR);
497:
498: org_rel_rec.subject_type := 'PERSON';
499: org_rel_rec.subject_table_name := 'HZ_PARTIES';
500: org_rel_rec.object_type := 'ORGANIZATION';
501: org_rel_rec.object_table_name := 'HZ_PARTIES';
502: org_rel_rec.status := x_Status;
503: org_rel_rec.relationship_code := g_contact_of;

Line 501: org_rel_rec.object_table_name := 'HZ_PARTIES';

497:
498: org_rel_rec.subject_type := 'PERSON';
499: org_rel_rec.subject_table_name := 'HZ_PARTIES';
500: org_rel_rec.object_type := 'ORGANIZATION';
501: org_rel_rec.object_table_name := 'HZ_PARTIES';
502: org_rel_rec.status := x_Status;
503: org_rel_rec.relationship_code := g_contact_of;
504: org_rel_rec.relationship_id := x_party_relationship_id;
505:

Line 520: l_hz_parties_obj_ver_num := P_REL_PARTY_OVN;

516: -- email_rec.email_address := NVL(X_Email_Address,FND_API.G_MISS_CHAR);
517:
518: -- Fetch the Org Contact Last Update Date
519: l_org_contacts_obj_ver_num := P_ORG_CONT_OVN;
520: l_hz_parties_obj_ver_num := P_REL_PARTY_OVN;
521: l_rel_obj_ver_num := P_REL_OVN;
522:
523: -- Call the API for the updation of the Org Contact Record
524: hz_party_contact_v2pub.update_org_contact(

Line 529: p_party_object_version_number => l_hz_parties_obj_ver_num,

525: p_init_msg_list => 'T',
526: p_org_contact_rec => ocon_rec,
527: p_cont_object_version_number => l_org_contacts_obj_ver_num,
528: p_rel_object_version_number => l_rel_obj_ver_num,
529: p_party_object_version_number => l_hz_parties_obj_ver_num,
530: x_return_status => x_return_status,
531: x_msg_count => x_msg_count,
532: x_msg_data => x_msg_data);
533:

Line 638: P_REL_PARTY_OVN := l_hz_parties_obj_ver_num;

634:
635: -- every thing successful then
636: P_CONTACT_POINT_OVN := l_obj_ver ;
637: P_ORG_CONT_OVN := l_org_contacts_obj_ver_num;
638: P_REL_PARTY_OVN := l_hz_parties_obj_ver_num;
639: P_REL_OVN := l_rel_obj_ver_num ;
640: END update_row;
641:
642: END igs_or_contacts_pkg;