238: ,update_mode varchar2(20)
239: );
240: --
241: Type g_phn_rec_type is RECORD
242: (phone_id per_phones.phone_id%type
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
239: );
240: --
241: Type g_phn_rec_type is RECORD
242: (phone_id per_phones.phone_id%type
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
240: --
241: Type g_phn_rec_type is RECORD
242: (phone_id per_phones.phone_id%type
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
248: ,parent_id per_phones.parent_id%type
241: Type g_phn_rec_type is RECORD
242: (phone_id per_phones.phone_id%type
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
248: ,parent_id per_phones.parent_id%type
249: ,update_mode varchar2(20)
242: (phone_id per_phones.phone_id%type
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
248: ,parent_id per_phones.parent_id%type
249: ,update_mode varchar2(20)
250: );
243: ,date_from per_phones.date_from%type
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
248: ,parent_id per_phones.parent_id%type
249: ,update_mode varchar2(20)
250: );
251: --
244: ,date_to per_phones.date_to%type --Bug 1554477
245: ,phone_type per_phones.phone_type%type
246: ,phone_number per_phones.phone_number%type
247: ,parent_table per_phones.parent_table%type
248: ,parent_id per_phones.parent_id%type
249: ,update_mode varchar2(20)
250: );
251: --
252: Type g_ptu_rec_type is RECORD