143: ,update_mode varchar2(20)
144: );
145: --
146: Type g_cont_rec_type is RECORD
147: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
144: );
145: --
146: Type g_cont_rec_type is RECORD
147: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
152: ,date_start per_contact_relationships.date_start%TYPE
145: --
146: Type g_cont_rec_type is RECORD
147: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
152: ,date_start per_contact_relationships.date_start%TYPE
153: );
146: Type g_cont_rec_type is RECORD
147: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
152: ,date_start per_contact_relationships.date_start%TYPE
153: );
154: --
147: (contact_relationship_id per_contact_relationships.contact_relationship_id%type
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
152: ,date_start per_contact_relationships.date_start%TYPE
153: );
154: --
155: Type g_add_rec_type is RECORD
148: ,contact_type per_contact_relationships.contact_type%type
149: ,person_id per_contact_relationships.person_id%type
150: ,contact_person_id per_contact_relationships.contact_person_id%type
151: ,business_group_id per_contact_relationships.business_group_id%type
152: ,date_start per_contact_relationships.date_start%TYPE
153: );
154: --
155: Type g_add_rec_type is RECORD
156: (address_id per_addresses.address_id%type