228: ,update_mode varchar2(20)
229: );
230: --
231: Type g_apl_rec_type is RECORD
232: (application_id per_applications.application_id%type
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
229: );
230: --
231: Type g_apl_rec_type is RECORD
232: (application_id per_applications.application_id%type
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
237: ,business_group_id per_applications.business_group_id%type
230: --
231: Type g_apl_rec_type is RECORD
232: (application_id per_applications.application_id%type
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
237: ,business_group_id per_applications.business_group_id%type
238: ,update_mode varchar2(20)
231: Type g_apl_rec_type is RECORD
232: (application_id per_applications.application_id%type
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
237: ,business_group_id per_applications.business_group_id%type
238: ,update_mode varchar2(20)
239: );
232: (application_id per_applications.application_id%type
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
237: ,business_group_id per_applications.business_group_id%type
238: ,update_mode varchar2(20)
239: );
240: --
233: ,person_id per_applications.person_id%type
234: ,date_received per_applications.date_received%type
235: ,date_end per_applications.date_end%type
236: ,termination_reason per_applications.termination_reason%type
237: ,business_group_id per_applications.business_group_id%type
238: ,update_mode varchar2(20)
239: );
240: --
241: Type g_phn_rec_type is RECORD