APPS.PQP_ABSVAL_PKG dependencies on PQP_GAP_DURATION_SUMMARY

Line 48: assignment_id pqp_gap_duration_summary.assignment_id%type

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

Line 49: ,gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%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

Line 50: ,summary_type pqp_gap_duration_summary.summary_type%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

Line 51: ,gap_level pqp_gap_duration_summary.gap_level%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

Line 52: ,date_start pqp_gap_duration_summary.date_start%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

Line 53: ,date_end pqp_gap_duration_summary.date_end%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

Line 54: ,duration_in_days pqp_gap_duration_summary.duration_in_days%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)

Line 55: ,duration_in_hours pqp_gap_duration_summary.duration_in_hours%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)
59: );

Line 56: ,gap_duration_summary_id pqp_gap_duration_summary.gap_duration_summary_id%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: );
60:

Line 57: ,object_version_number pqp_gap_duration_summary.object_version_number%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:
61: TYPE r_absence_balance

Line 63: gap_absence_plan_id pqp_gap_duration_summary.gap_absence_plan_id%Type

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)

Line 64: ,gap_level pqp_gap_duration_summary.gap_level%Type

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)