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.POS_SUPP_CONTACT_PKG dependencies on HZ_PARTIES

Line 20: l_rel_party_number hz_parties.party_number%TYPE;

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;
24: l_org_contact_id NUMBER;

Line 35: l_rel_rec.object_table_name := 'HZ_PARTIES';

31: l_rel_party_rec := NULL;
32:
33: l_rel_rec.object_id := p_vendor_party_id;
34: l_rel_rec.object_type := 'ORGANIZATION';
35: l_rel_rec.object_table_name := 'HZ_PARTIES';
36: l_rel_rec.subject_id := p_person_party_id;
37: l_rel_rec.subject_type := 'PERSON';
38: l_rel_rec.subject_table_name := 'HZ_PARTIES';
39: l_rel_rec.relationship_code := 'CONTACT_OF';

Line 38: l_rel_rec.subject_table_name := 'HZ_PARTIES';

34: l_rel_rec.object_type := 'ORGANIZATION';
35: l_rel_rec.object_table_name := 'HZ_PARTIES';
36: l_rel_rec.subject_id := p_person_party_id;
37: l_rel_rec.subject_type := 'PERSON';
38: l_rel_rec.subject_table_name := 'HZ_PARTIES';
39: l_rel_rec.relationship_code := 'CONTACT_OF';
40: l_rel_rec.relationship_type := 'CONTACT';
41: l_rel_rec.start_date := Sysdate;
42: l_rel_rec.end_date := p_inactive_date;

Line 119: l_person_party_number hz_parties.party_number%TYPE;

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);
123: l_step VARCHAR2(100);

Line 386: p_contact_party_id - holds party id of the 'PERSON' party record in hz_parties.

382: like name,email,phone number,fax etc.
383: Parameters :
384:
385: IN :
386: p_contact_party_id - holds party id of the 'PERSON' party record in hz_parties.
387: p_vendor_party_id - holds party id of the 'ORGANIZATION' party record in hz_parties.
388: p_first_name - first name of the contact
389: p_last_name - last name of the contact
390: p_middle_name - middle name of the contact

Line 387: p_vendor_party_id - holds party id of the 'ORGANIZATION' party record in hz_parties.

383: Parameters :
384:
385: IN :
386: p_contact_party_id - holds party id of the 'PERSON' party record in hz_parties.
387: p_vendor_party_id - holds party id of the 'ORGANIZATION' party record in hz_parties.
388: p_first_name - first name of the contact
389: p_last_name - last name of the contact
390: p_middle_name - middle name of the contact
391: p_contact_title - contact title of the contact

Line 397: p_party_object_version_number - object version number of the relationship record in hz_parties

393: p_phone_number - phone number of the contact
394: p_fax_number - fax number of the contact
395: p_email_address - email address of the contact
396: p_inactive_date - inactive date of the contact
397: p_party_object_version_number - object version number of the relationship record in hz_parties
398: p_email_object_version_number - object version number of the email contact in hz_contact_points
399: p_phone_object_version_number - object version number of the phone contact in hz_contact_points
400: p_fax_object_version_number - object version number of the fax contact in hz_contact_points
401: p_rel_object_version_number - object version number of the relationship record in hz_relationships

Line 403: p_person_party_obversion_num - object version number of the 'PERSON' party record in hz_parties

399: p_phone_object_version_number - object version number of the phone contact in hz_contact_points
400: p_fax_object_version_number - object version number of the fax contact in hz_contact_points
401: p_rel_object_version_number - object version number of the relationship record in hz_relationships
402: p_cont_object_version_number - object version number of the hz_org_contacts record
403: p_person_party_obversion_num - object version number of the 'PERSON' party record in hz_parties
404:
405: OUT :
406: x_return_status - returns either success/failure
407: x_msg_count - returns the number of error messages

Line 455: FROM hz_parties

451: person_pre_name_adjunct,
452: person_title,
453: object_version_number,
454: known_as
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;

Line 472: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp

468: hzr.object_version_number rel_object_version_number,
469: hzr.party_id,
470: hzr.relationship_id,
471: hp.object_version_number rel_party_obj_ver_num
472: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp
473: WHERE hoc.party_relationship_id = hzr.relationship_id
474: AND hzr.object_table_name = 'HZ_PARTIES'
475: AND hzr.object_id = p_vendor_party_id
476: AND hzr.subject_table_name = 'HZ_PARTIES'

Line 474: AND hzr.object_table_name = 'HZ_PARTIES'

470: hzr.relationship_id,
471: hp.object_version_number rel_party_obj_ver_num
472: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp
473: WHERE hoc.party_relationship_id = hzr.relationship_id
474: AND hzr.object_table_name = 'HZ_PARTIES'
475: AND hzr.object_id = p_vendor_party_id
476: AND hzr.subject_table_name = 'HZ_PARTIES'
477: AND hzr.subject_id = p_contact_party_id
478: AND hzr.relationship_type = 'CONTACT'

Line 476: AND hzr.subject_table_name = 'HZ_PARTIES'

472: FROM hz_org_contacts hoc, hz_relationships hzr, hz_parties hp
473: WHERE hoc.party_relationship_id = hzr.relationship_id
474: AND hzr.object_table_name = 'HZ_PARTIES'
475: AND hzr.object_id = p_vendor_party_id
476: AND hzr.subject_table_name = 'HZ_PARTIES'
477: AND hzr.subject_id = p_contact_party_id
478: AND hzr.relationship_type = 'CONTACT'
479: AND hzr.relationship_code = 'CONTACT_OF'
480: AND hzr.party_id = hp.party_id;

Line 841: SUBJECT_TABLE_NAME='HZ_PARTIES'

837: SET
838: STATUS='A'
839: WHERE
840: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE
841: SUBJECT_TABLE_NAME='HZ_PARTIES'
842: AND
843: SUBJECT_ID=p_contact_party_id
844: AND
845: SUBJECT_TYPE='PERSON'

Line 847: OBJECT_TABLE_NAME='HZ_PARTIES'

843: SUBJECT_ID=p_contact_party_id
844: AND
845: SUBJECT_TYPE='PERSON'
846: AND
847: OBJECT_TABLE_NAME='HZ_PARTIES'
848: AND
849: OBJECT_ID=p_vendor_party_id
850: AND
851: OBJECT_TYPE='ORGANIZATION'

Line 863: OBJECT_TABLE_NAME='HZ_PARTIES'

859: SET
860: STATUS='A'
861: WHERE
862: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE
863: OBJECT_TABLE_NAME='HZ_PARTIES'
864: AND
865: OBJECT_ID=p_contact_party_id
866: AND
867: OBJECT_TYPE='PERSON'

Line 869: SUBJECT_TABLE_NAME='HZ_PARTIES'

865: OBJECT_ID=p_contact_party_id
866: AND
867: OBJECT_TYPE='PERSON'
868: AND
869: SUBJECT_TABLE_NAME='HZ_PARTIES'
870: AND
871: SUBJECT_ID=p_vendor_party_id
872: AND
873: SUBJECT_TYPE='ORGANIZATION'

Line 885: SUBJECT_TABLE_NAME='HZ_PARTIES'

881: SET
882: STATUS='A'
883: WHERE
884: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE
885: SUBJECT_TABLE_NAME='HZ_PARTIES'
886: AND
887: SUBJECT_ID=p_contact_party_id
888: AND
889: SUBJECT_TYPE='PERSON'

Line 891: OBJECT_TABLE_NAME='HZ_PARTIES'

887: SUBJECT_ID=p_contact_party_id
888: AND
889: SUBJECT_TYPE='PERSON'
890: AND
891: OBJECT_TABLE_NAME='HZ_PARTIES'
892: AND
893: OBJECT_ID=p_vendor_party_id
894: AND
895: OBJECT_TYPE='ORGANIZATION'

Line 906: OBJECT_TABLE_NAME='HZ_PARTIES'

902: SET
903: STATUS='A'
904: WHERE
905: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE
906: OBJECT_TABLE_NAME='HZ_PARTIES'
907: AND
908: OBJECT_ID=p_contact_party_id
909: AND
910: OBJECT_TYPE='PERSON'

Line 912: SUBJECT_TABLE_NAME='HZ_PARTIES'

908: OBJECT_ID=p_contact_party_id
909: AND
910: OBJECT_TYPE='PERSON'
911: AND
912: SUBJECT_TABLE_NAME='HZ_PARTIES'
913: AND
914: SUBJECT_ID=p_vendor_party_id
915: AND
916: SUBJECT_TYPE='ORGANIZATION'