44: );
45:
46: TYPE r_duration_summary
47: IS RECORD(
48: assignment_id pqp_gap_duration_summary.assignment_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
45:
46: TYPE r_duration_summary
47: IS RECORD(
48: assignment_id pqp_gap_duration_summary.assignment_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
46: TYPE r_duration_summary
47: IS RECORD(
48: assignment_id pqp_gap_duration_summary.assignment_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
47: IS RECORD(
48: assignment_id pqp_gap_duration_summary.assignment_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
48: assignment_id pqp_gap_duration_summary.assignment_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
57: ,object_version_number pqp_gap_duration_summary.object_version_number%type
50: ,summary_type pqp_gap_duration_summary.summary_type%type
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
57: ,object_version_number pqp_gap_duration_summary.object_version_number%type
58: ,action_type VARCHAR2(2)
51: ,gap_level pqp_gap_duration_summary.gap_level%type
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
57: ,object_version_number pqp_gap_duration_summary.object_version_number%type
58: ,action_type VARCHAR2(2)
59: );
52: ,date_start pqp_gap_duration_summary.date_start%type
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
57: ,object_version_number pqp_gap_duration_summary.object_version_number%type
58: ,action_type VARCHAR2(2)
59: );
60:
53: ,date_end pqp_gap_duration_summary.date_end%type
54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%type
55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%type
56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%type
57: ,object_version_number pqp_gap_duration_summary.object_version_number%type
58: ,action_type VARCHAR2(2)
59: );
60:
61: TYPE r_absence_balance
59: );
60:
61: TYPE r_absence_balance
62: Is Record(
63: gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%Type
64: ,gap_level pqp_gap_duration_summary.gap_level%Type
65: ,entitlement_granted NUMBER(10,5)
66: ,entitlement_used_to_date NUMBER(10,5)
67: ,entitlement_used_by_abs NUMBER(10,5)
60:
61: TYPE r_absence_balance
62: Is Record(
63: gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%Type
64: ,gap_level pqp_gap_duration_summary.gap_level%Type
65: ,entitlement_granted NUMBER(10,5)
66: ,entitlement_used_to_date NUMBER(10,5)
67: ,entitlement_used_by_abs NUMBER(10,5)
68: ,entitlement_remaining NUMBER(10,5)