APPS.POS_SUPP_CONTACT_PKG dependencies on HZ_RELATIONSHIPS

Line 401: p_rel_object_version_number - object version number of the relationship record in hz_relationships

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
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 :

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 829: We need to update status flag of HZ_RELATIONSHIPS table for this person party to 'A' irrespective

825:
826: END LOOP;
827:
828: /* Bug 9576302 Start
829: We need to update status flag of HZ_RELATIONSHIPS table for this person party to 'A' irrespective
830: of whether contact is active or not as in R12 we are making use of end_date to check whether contact
831: is active or not.
832:
833: We need to update the status flag in HZ_ORG_CONTACTS also to 'A' for the relationship_id

Line 836: UPDATE HZ_RELATIONSHIPS

832:
833: We need to update the status flag in HZ_ORG_CONTACTS also to 'A' for the relationship_id
834: */
835:
836: UPDATE HZ_RELATIONSHIPS
837: SET
838: STATUS='A'
839: WHERE
840: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

Line 840: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

836: UPDATE HZ_RELATIONSHIPS
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

Line 858: UPDATE HZ_RELATIONSHIPS

854: AND
855: RELATIONSHIP_CODE='CONTACT_OF'
856: );
857:
858: UPDATE HZ_RELATIONSHIPS
859: SET
860: STATUS='A'
861: WHERE
862: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

Line 862: RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

858: UPDATE HZ_RELATIONSHIPS
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

Line 884: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

880: UPDATE HZ_ORG_CONTACTS
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

Line 905: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

901: UPDATE HZ_ORG_CONTACTS
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