APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_APP_PERIOD_SUMMARY

Line 19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,

15: submission_date hxc_timecard_summary.submission_date%type
16: );
17:
18: type application_info is record
19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,
20: approval_status hxc_app_period_summary.approval_status%type,
21: creation_date hxc_app_period_summary.creation_date%type,
22: notification_status hxc_app_period_summary.notification_status%type,
23: approver varchar2(360)

Line 20: approval_status hxc_app_period_summary.approval_status%type,

16: );
17:
18: type application_info is record
19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,
20: approval_status hxc_app_period_summary.approval_status%type,
21: creation_date hxc_app_period_summary.creation_date%type,
22: notification_status hxc_app_period_summary.notification_status%type,
23: approver varchar2(360)
24: );

Line 21: creation_date hxc_app_period_summary.creation_date%type,

17:
18: type application_info is record
19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,
20: approval_status hxc_app_period_summary.approval_status%type,
21: creation_date hxc_app_period_summary.creation_date%type,
22: notification_status hxc_app_period_summary.notification_status%type,
23: approver varchar2(360)
24: );
25:

Line 22: notification_status hxc_app_period_summary.notification_status%type,

18: type application_info is record
19: (time_recipient_id hxc_app_period_summary.time_recipient_id%type,
20: approval_status hxc_app_period_summary.approval_status%type,
21: creation_date hxc_app_period_summary.creation_date%type,
22: notification_status hxc_app_period_summary.notification_status%type,
23: approver varchar2(360)
24: );
25:
26: type application_info_table is table of application_info

Line 80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)

76: p_stop_time in hxc_timecard_summary.stop_time%type)
77: return hxc_timecard_summary.submission_date%type;
78:
79: function get_app_approval_status
80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
81: return hxc_app_period_summary.approval_status%type;
82:
83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,

Line 81: return hxc_app_period_summary.approval_status%type;

77: return hxc_timecard_summary.submission_date%type;
78:
79: function get_app_approval_status
80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
81: return hxc_app_period_summary.approval_status%type;
82:
83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,
85: p_start_time in hxc_app_period_summary.start_time%type,

Line 84: (p_resource_id in hxc_app_period_summary.resource_id%type,

80: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
81: return hxc_app_period_summary.approval_status%type;
82:
83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,
85: p_start_time in hxc_app_period_summary.start_time%type,
86: p_stop_time in hxc_app_period_summary.stop_time%type,
87: p_application_name in hxc_time_recipients.name%type
88: )

Line 85: p_start_time in hxc_app_period_summary.start_time%type,

81: return hxc_app_period_summary.approval_status%type;
82:
83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,
85: p_start_time in hxc_app_period_summary.start_time%type,
86: p_stop_time in hxc_app_period_summary.stop_time%type,
87: p_application_name in hxc_time_recipients.name%type
88: )
89: return hxc_app_period_summary.approval_status%type;

Line 86: p_stop_time in hxc_app_period_summary.stop_time%type,

82:
83: function get_app_approval_status
84: (p_resource_id in hxc_app_period_summary.resource_id%type,
85: p_start_time in hxc_app_period_summary.start_time%type,
86: p_stop_time in hxc_app_period_summary.stop_time%type,
87: p_application_name in hxc_time_recipients.name%type
88: )
89: return hxc_app_period_summary.approval_status%type;
90:

Line 89: return hxc_app_period_summary.approval_status%type;

85: p_start_time in hxc_app_period_summary.start_time%type,
86: p_stop_time in hxc_app_period_summary.stop_time%type,
87: p_application_name in hxc_time_recipients.name%type
88: )
89: return hxc_app_period_summary.approval_status%type;
90:
91: function get_app_approval_status
92: (p_resource_id in hxc_app_period_summary.resource_id%type,
93: p_start_time in hxc_app_period_summary.start_time%type,

Line 92: (p_resource_id in hxc_app_period_summary.resource_id%type,

88: )
89: return hxc_app_period_summary.approval_status%type;
90:
91: function get_app_approval_status
92: (p_resource_id in hxc_app_period_summary.resource_id%type,
93: p_start_time in hxc_app_period_summary.start_time%type,
94: p_stop_time in hxc_app_period_summary.stop_time%type,
95: p_application_name in hxc_time_recipients.name%type,
96: p_time_category_name in hxc_time_categories.time_category_name%type

Line 93: p_start_time in hxc_app_period_summary.start_time%type,

89: return hxc_app_period_summary.approval_status%type;
90:
91: function get_app_approval_status
92: (p_resource_id in hxc_app_period_summary.resource_id%type,
93: p_start_time in hxc_app_period_summary.start_time%type,
94: p_stop_time in hxc_app_period_summary.stop_time%type,
95: p_application_name in hxc_time_recipients.name%type,
96: p_time_category_name in hxc_time_categories.time_category_name%type
97: )

Line 94: p_stop_time in hxc_app_period_summary.stop_time%type,

90:
91: function get_app_approval_status
92: (p_resource_id in hxc_app_period_summary.resource_id%type,
93: p_start_time in hxc_app_period_summary.start_time%type,
94: p_stop_time in hxc_app_period_summary.stop_time%type,
95: p_application_name in hxc_time_recipients.name%type,
96: p_time_category_name in hxc_time_categories.time_category_name%type
97: )
98: return hxc_app_period_summary.approval_status%type;

Line 98: return hxc_app_period_summary.approval_status%type;

94: p_stop_time in hxc_app_period_summary.stop_time%type,
95: p_application_name in hxc_time_recipients.name%type,
96: p_time_category_name in hxc_time_categories.time_category_name%type
97: )
98: return hxc_app_period_summary.approval_status%type;
99:
100: function get_app_creation_date
101: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
102: return hxc_app_period_summary.creation_date%type;

Line 101: (p_application_period_id in hxc_app_period_summary.application_period_id%type)

97: )
98: return hxc_app_period_summary.approval_status%type;
99:
100: function get_app_creation_date
101: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
102: return hxc_app_period_summary.creation_date%type;
103:
104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,

Line 102: return hxc_app_period_summary.creation_date%type;

98: return hxc_app_period_summary.approval_status%type;
99:
100: function get_app_creation_date
101: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
102: return hxc_app_period_summary.creation_date%type;
103:
104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,
106: p_start_time in hxc_app_period_summary.start_time%type,

Line 105: (p_resource_id in hxc_app_period_summary.resource_id%type,

101: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
102: return hxc_app_period_summary.creation_date%type;
103:
104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,
106: p_start_time in hxc_app_period_summary.start_time%type,
107: p_stop_time in hxc_app_period_summary.stop_time%type,
108: p_application_name in hxc_time_recipients.name%type
109: )

Line 106: p_start_time in hxc_app_period_summary.start_time%type,

102: return hxc_app_period_summary.creation_date%type;
103:
104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,
106: p_start_time in hxc_app_period_summary.start_time%type,
107: p_stop_time in hxc_app_period_summary.stop_time%type,
108: p_application_name in hxc_time_recipients.name%type
109: )
110: return hxc_app_period_summary.creation_date%type;

Line 107: p_stop_time in hxc_app_period_summary.stop_time%type,

103:
104: function get_app_creation_date
105: (p_resource_id in hxc_app_period_summary.resource_id%type,
106: p_start_time in hxc_app_period_summary.start_time%type,
107: p_stop_time in hxc_app_period_summary.stop_time%type,
108: p_application_name in hxc_time_recipients.name%type
109: )
110: return hxc_app_period_summary.creation_date%type;
111:

Line 110: return hxc_app_period_summary.creation_date%type;

106: p_start_time in hxc_app_period_summary.start_time%type,
107: p_stop_time in hxc_app_period_summary.stop_time%type,
108: p_application_name in hxc_time_recipients.name%type
109: )
110: return hxc_app_period_summary.creation_date%type;
111:
112: function get_app_creation_date
113: (p_resource_id in hxc_app_period_summary.resource_id%type,
114: p_start_time in hxc_app_period_summary.start_time%type,

Line 113: (p_resource_id in hxc_app_period_summary.resource_id%type,

109: )
110: return hxc_app_period_summary.creation_date%type;
111:
112: function get_app_creation_date
113: (p_resource_id in hxc_app_period_summary.resource_id%type,
114: p_start_time in hxc_app_period_summary.start_time%type,
115: p_stop_time in hxc_app_period_summary.stop_time%type,
116: p_application_name in hxc_time_recipients.name%type,
117: p_time_category_name in hxc_time_categories.time_category_name%type

Line 114: p_start_time in hxc_app_period_summary.start_time%type,

110: return hxc_app_period_summary.creation_date%type;
111:
112: function get_app_creation_date
113: (p_resource_id in hxc_app_period_summary.resource_id%type,
114: p_start_time in hxc_app_period_summary.start_time%type,
115: p_stop_time in hxc_app_period_summary.stop_time%type,
116: p_application_name in hxc_time_recipients.name%type,
117: p_time_category_name in hxc_time_categories.time_category_name%type
118: )

Line 115: p_stop_time in hxc_app_period_summary.stop_time%type,

111:
112: function get_app_creation_date
113: (p_resource_id in hxc_app_period_summary.resource_id%type,
114: p_start_time in hxc_app_period_summary.start_time%type,
115: p_stop_time in hxc_app_period_summary.stop_time%type,
116: p_application_name in hxc_time_recipients.name%type,
117: p_time_category_name in hxc_time_categories.time_category_name%type
118: )
119: return hxc_app_period_summary.creation_date%type;

Line 119: return hxc_app_period_summary.creation_date%type;

115: p_stop_time in hxc_app_period_summary.stop_time%type,
116: p_application_name in hxc_time_recipients.name%type,
117: p_time_category_name in hxc_time_categories.time_category_name%type
118: )
119: return hxc_app_period_summary.creation_date%type;
120:
121: function get_app_approver
122: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
123: return varchar2;

Line 122: (p_application_period_id in hxc_app_period_summary.application_period_id%type)

118: )
119: return hxc_app_period_summary.creation_date%type;
120:
121: function get_app_approver
122: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
123: return varchar2;
124:
125: function get_app_approver
126: (p_resource_id in hxc_app_period_summary.resource_id%type,

Line 126: (p_resource_id in hxc_app_period_summary.resource_id%type,

122: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
123: return varchar2;
124:
125: function get_app_approver
126: (p_resource_id in hxc_app_period_summary.resource_id%type,
127: p_start_time in hxc_app_period_summary.start_time%type,
128: p_stop_time in hxc_app_period_summary.stop_time%type,
129: p_application_name in hxc_time_recipients.name%type
130: )

Line 127: p_start_time in hxc_app_period_summary.start_time%type,

123: return varchar2;
124:
125: function get_app_approver
126: (p_resource_id in hxc_app_period_summary.resource_id%type,
127: p_start_time in hxc_app_period_summary.start_time%type,
128: p_stop_time in hxc_app_period_summary.stop_time%type,
129: p_application_name in hxc_time_recipients.name%type
130: )
131: return varchar2;

Line 128: p_stop_time in hxc_app_period_summary.stop_time%type,

124:
125: function get_app_approver
126: (p_resource_id in hxc_app_period_summary.resource_id%type,
127: p_start_time in hxc_app_period_summary.start_time%type,
128: p_stop_time in hxc_app_period_summary.stop_time%type,
129: p_application_name in hxc_time_recipients.name%type
130: )
131: return varchar2;
132:

Line 134: (p_resource_id in hxc_app_period_summary.resource_id%type,

130: )
131: return varchar2;
132:
133: function get_app_approver
134: (p_resource_id in hxc_app_period_summary.resource_id%type,
135: p_start_time in hxc_app_period_summary.start_time%type,
136: p_stop_time in hxc_app_period_summary.stop_time%type,
137: p_application_name in hxc_time_recipients.name%type,
138: p_time_category_name in hxc_time_categories.time_category_name%type

Line 135: p_start_time in hxc_app_period_summary.start_time%type,

131: return varchar2;
132:
133: function get_app_approver
134: (p_resource_id in hxc_app_period_summary.resource_id%type,
135: p_start_time in hxc_app_period_summary.start_time%type,
136: p_stop_time in hxc_app_period_summary.stop_time%type,
137: p_application_name in hxc_time_recipients.name%type,
138: p_time_category_name in hxc_time_categories.time_category_name%type
139: )

Line 136: p_stop_time in hxc_app_period_summary.stop_time%type,

132:
133: function get_app_approver
134: (p_resource_id in hxc_app_period_summary.resource_id%type,
135: p_start_time in hxc_app_period_summary.start_time%type,
136: p_stop_time in hxc_app_period_summary.stop_time%type,
137: p_application_name in hxc_time_recipients.name%type,
138: p_time_category_name in hxc_time_categories.time_category_name%type
139: )
140: return varchar2;