302: );
303: --
304:
305: Type g_per_school_rec_type is RECORD
306: (person_id per_establishment_attendances.person_id%type
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
303: --
304:
305: Type g_per_school_rec_type is RECORD
306: (person_id per_establishment_attendances.person_id%type
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
311: ,business_group_id per_establishment_attendances.business_group_id%type
304:
305: Type g_per_school_rec_type is RECORD
306: (person_id per_establishment_attendances.person_id%type
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
311: ,business_group_id per_establishment_attendances.business_group_id%type
312: ,update_mode varchar2(20)
305: Type g_per_school_rec_type is RECORD
306: (person_id per_establishment_attendances.person_id%type
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
311: ,business_group_id per_establishment_attendances.business_group_id%type
312: ,update_mode varchar2(20)
313: );
306: (person_id per_establishment_attendances.person_id%type
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
311: ,business_group_id per_establishment_attendances.business_group_id%type
312: ,update_mode varchar2(20)
313: );
314:
307: ,full_time per_establishment_attendances.full_time%type
308: ,attended_end_date per_establishment_attendances.attended_end_date%type
309: ,establishment_id per_establishment_attendances.establishment_id%type
310: ,attended_start_date per_establishment_attendances.attended_start_date%type
311: ,business_group_id per_establishment_attendances.business_group_id%type
312: ,update_mode varchar2(20)
313: );
314:
315: Type g_prem_mo_rec_type is RECORD