APPS.FUN_SECURITY dependencies on HZ_RELATIONSHIP_V2PUB

Line 183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

179: l_object_version_number hz_relationships.object_version_number%TYPE;
180: l_party_object_version_number hz_relationships.object_version_number%TYPE := NULL;
181: l_cont_object_version_number hz_relationships.object_version_number%TYPE;
182: l_rel_object_version_number hz_relationships.object_version_number%TYPE;
183: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
184: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;
185: l_tca_contact_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
186: l_org_contact_role_id NUMBER;
187: l_org_contact_id NUMBER;

Line 419: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

415: DECLARE
416: l_relationship_id NUMBER(15);
417: l_party_id NUMBER(15);
418: l_party_number VARCHAR2(30);
419: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
420: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;
421: l_tca_contact_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
422: l_org_contact_role_id NUMBER;
423: l_org_contact_id NUMBER;

Line 661: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;

657: DECLARE
658: l_relationship_id NUMBER(15);
659: l_party_id NUMBER(15);
660: l_party_number VARCHAR2(30);
661: l_tca_relationship_record HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
662: l_tca_contact_role_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_ROLE_REC_TYPE;
663: l_tca_contact_record HZ_PARTY_CONTACT_V2PUB.ORG_CONTACT_REC_TYPE;
664: l_org_contact_role_id NUMBER;
665: l_org_contact_id NUMBER;