APPS.POS_SUPP_CONTACT_PKG dependencies on HZ_ORG_CONTACTS

Line 402: p_cont_object_version_number - object version number of the hz_org_contacts record

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 :
406: x_return_status - returns either success/failure

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 833: We need to update the status flag in HZ_ORG_CONTACTS also to 'A' for the relationship_id

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
834: */
835:
836: UPDATE HZ_RELATIONSHIPS
837: SET

Line 880: UPDATE HZ_ORG_CONTACTS

876: AND
877: RELATIONSHIP_CODE='CONTACT'
878: );
879:
880: UPDATE HZ_ORG_CONTACTS
881: SET
882: STATUS='A'
883: WHERE
884: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE

Line 901: UPDATE HZ_ORG_CONTACTS

897: RELATIONSHIP_TYPE='CONTACT'
898: AND
899: RELATIONSHIP_CODE='CONTACT_OF');
900:
901: UPDATE HZ_ORG_CONTACTS
902: SET
903: STATUS='A'
904: WHERE
905: PARTY_RELATIONSHIP_ID=(SELECT RELATIONSHIP_ID FROM HZ_RELATIONSHIPS WHERE