DBA Data[Home] [Help]

APPS.HXC_INTEGRATION_LAYER_V1_GRP dependencies on HXC_TIMECARD_SUMMARY

Line 173: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

169: -- ----------------------------------------------------------------------------
170: -- |-----------------< get_timecard_approval_status >------------------------|
171: -- ----------------------------------------------------------------------------
172: FUNCTION get_timecard_approval_status
173: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
174: RETURN hxc_timecard_summary.approval_status%type;
175:
176: -- ----------------------------------------------------------------------------
177: -- |-----------------< get_timecard_approval_status 2>------------------------|

Line 174: RETURN hxc_timecard_summary.approval_status%type;

170: -- |-----------------< get_timecard_approval_status >------------------------|
171: -- ----------------------------------------------------------------------------
172: FUNCTION get_timecard_approval_status
173: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
174: RETURN hxc_timecard_summary.approval_status%type;
175:
176: -- ----------------------------------------------------------------------------
177: -- |-----------------< get_timecard_approval_status 2>------------------------|
178: -- ----------------------------------------------------------------------------

Line 180: (p_resource_id in hxc_timecard_summary.resource_id%type

176: -- ----------------------------------------------------------------------------
177: -- |-----------------< get_timecard_approval_status 2>------------------------|
178: -- ----------------------------------------------------------------------------
179: FUNCTION get_timecard_approval_status
180: (p_resource_id in hxc_timecard_summary.resource_id%type
181: ,p_start_time in hxc_timecard_summary.start_time%type
182: ,p_stop_time in hxc_timecard_summary.stop_time%type)
183: RETURN hxc_timecard_summary.approval_status%type;
184:

Line 181: ,p_start_time in hxc_timecard_summary.start_time%type

177: -- |-----------------< get_timecard_approval_status 2>------------------------|
178: -- ----------------------------------------------------------------------------
179: FUNCTION get_timecard_approval_status
180: (p_resource_id in hxc_timecard_summary.resource_id%type
181: ,p_start_time in hxc_timecard_summary.start_time%type
182: ,p_stop_time in hxc_timecard_summary.stop_time%type)
183: RETURN hxc_timecard_summary.approval_status%type;
184:
185: -- ----------------------------------------------------------------------------

Line 182: ,p_stop_time in hxc_timecard_summary.stop_time%type)

178: -- ----------------------------------------------------------------------------
179: FUNCTION get_timecard_approval_status
180: (p_resource_id in hxc_timecard_summary.resource_id%type
181: ,p_start_time in hxc_timecard_summary.start_time%type
182: ,p_stop_time in hxc_timecard_summary.stop_time%type)
183: RETURN hxc_timecard_summary.approval_status%type;
184:
185: -- ----------------------------------------------------------------------------
186: -- |-----------------< get_timecard_submission_date 2>------------------------|

Line 183: RETURN hxc_timecard_summary.approval_status%type;

179: FUNCTION get_timecard_approval_status
180: (p_resource_id in hxc_timecard_summary.resource_id%type
181: ,p_start_time in hxc_timecard_summary.start_time%type
182: ,p_stop_time in hxc_timecard_summary.stop_time%type)
183: RETURN hxc_timecard_summary.approval_status%type;
184:
185: -- ----------------------------------------------------------------------------
186: -- |-----------------< get_timecard_submission_date 2>------------------------|
187: -- ----------------------------------------------------------------------------

Line 189: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

185: -- ----------------------------------------------------------------------------
186: -- |-----------------< get_timecard_submission_date 2>------------------------|
187: -- ----------------------------------------------------------------------------
188: FUNCTION get_timecard_submission_date
189: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
190: RETURN hxc_timecard_summary.submission_date%type;
191:
192: -- ----------------------------------------------------------------------------
193: -- |-----------------< get_timecard_submission_date 2>------------------------|

Line 190: RETURN hxc_timecard_summary.submission_date%type;

186: -- |-----------------< get_timecard_submission_date 2>------------------------|
187: -- ----------------------------------------------------------------------------
188: FUNCTION get_timecard_submission_date
189: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
190: RETURN hxc_timecard_summary.submission_date%type;
191:
192: -- ----------------------------------------------------------------------------
193: -- |-----------------< get_timecard_submission_date 2>------------------------|
194: -- ----------------------------------------------------------------------------

Line 196: (p_resource_id in hxc_timecard_summary.resource_id%type

192: -- ----------------------------------------------------------------------------
193: -- |-----------------< get_timecard_submission_date 2>------------------------|
194: -- ----------------------------------------------------------------------------
195: FUNCTION get_timecard_submission_date
196: (p_resource_id in hxc_timecard_summary.resource_id%type
197: ,p_start_time in hxc_timecard_summary.start_time%type
198: ,p_stop_time in hxc_timecard_summary.stop_time%type)
199: RETURN hxc_timecard_summary.submission_date%type;
200:

Line 197: ,p_start_time in hxc_timecard_summary.start_time%type

193: -- |-----------------< get_timecard_submission_date 2>------------------------|
194: -- ----------------------------------------------------------------------------
195: FUNCTION get_timecard_submission_date
196: (p_resource_id in hxc_timecard_summary.resource_id%type
197: ,p_start_time in hxc_timecard_summary.start_time%type
198: ,p_stop_time in hxc_timecard_summary.stop_time%type)
199: RETURN hxc_timecard_summary.submission_date%type;
200:
201:

Line 198: ,p_stop_time in hxc_timecard_summary.stop_time%type)

194: -- ----------------------------------------------------------------------------
195: FUNCTION get_timecard_submission_date
196: (p_resource_id in hxc_timecard_summary.resource_id%type
197: ,p_start_time in hxc_timecard_summary.start_time%type
198: ,p_stop_time in hxc_timecard_summary.stop_time%type)
199: RETURN hxc_timecard_summary.submission_date%type;
200:
201:
202: -- ----------------------------------------------------------------------------

Line 199: RETURN hxc_timecard_summary.submission_date%type;

195: FUNCTION get_timecard_submission_date
196: (p_resource_id in hxc_timecard_summary.resource_id%type
197: ,p_start_time in hxc_timecard_summary.start_time%type
198: ,p_stop_time in hxc_timecard_summary.stop_time%type)
199: RETURN hxc_timecard_summary.submission_date%type;
200:
201:
202: -- ----------------------------------------------------------------------------
203: -- |-----------------< get_timecard_approval_date >------------------------|

Line 206: (p_timecard_id in hxc_timecard_summary.timecard_id%type)

202: -- ----------------------------------------------------------------------------
203: -- |-----------------< get_timecard_approval_date >------------------------|
204: -- ----------------------------------------------------------------------------
205: FUNCTION get_timecard_approval_date
206: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
207: RETURN hxc_timecard_summary.submission_date%type;
208:
209: -- ----------------------------------------------------------------------------
210: -- |-----------------< get_timecard_approval_date 2 >------------------------|

Line 207: RETURN hxc_timecard_summary.submission_date%type;

203: -- |-----------------< get_timecard_approval_date >------------------------|
204: -- ----------------------------------------------------------------------------
205: FUNCTION get_timecard_approval_date
206: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
207: RETURN hxc_timecard_summary.submission_date%type;
208:
209: -- ----------------------------------------------------------------------------
210: -- |-----------------< get_timecard_approval_date 2 >------------------------|
211: -- ----------------------------------------------------------------------------

Line 214: (p_resource_id in hxc_timecard_summary.resource_id%type

210: -- |-----------------< get_timecard_approval_date 2 >------------------------|
211: -- ----------------------------------------------------------------------------
212:
213: FUNCTION get_timecard_approval_date
214: (p_resource_id in hxc_timecard_summary.resource_id%type
215: ,p_start_time in hxc_timecard_summary.start_time%type
216: ,p_stop_time in hxc_timecard_summary.stop_time%type)
217: RETURN hxc_timecard_summary.submission_date%type;
218:

Line 215: ,p_start_time in hxc_timecard_summary.start_time%type

211: -- ----------------------------------------------------------------------------
212:
213: FUNCTION get_timecard_approval_date
214: (p_resource_id in hxc_timecard_summary.resource_id%type
215: ,p_start_time in hxc_timecard_summary.start_time%type
216: ,p_stop_time in hxc_timecard_summary.stop_time%type)
217: RETURN hxc_timecard_summary.submission_date%type;
218:
219: --

Line 216: ,p_stop_time in hxc_timecard_summary.stop_time%type)

212:
213: FUNCTION get_timecard_approval_date
214: (p_resource_id in hxc_timecard_summary.resource_id%type
215: ,p_start_time in hxc_timecard_summary.start_time%type
216: ,p_stop_time in hxc_timecard_summary.stop_time%type)
217: RETURN hxc_timecard_summary.submission_date%type;
218:
219: --
220: -- Straight Interface

Line 217: RETURN hxc_timecard_summary.submission_date%type;

213: FUNCTION get_timecard_approval_date
214: (p_resource_id in hxc_timecard_summary.resource_id%type
215: ,p_start_time in hxc_timecard_summary.start_time%type
216: ,p_stop_time in hxc_timecard_summary.stop_time%type)
217: RETURN hxc_timecard_summary.submission_date%type;
218:
219: --
220: -- Straight Interface
221: --