APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_TIMECARD_SUMMARY

Line 20: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

16:
17: end clearCache;
18:
19: procedure createApplicationCache
20: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
21:
22: cursor c_ap_cache_info
23: (p_tc_id in hxc_tc_ap_links.timecard_id%type) is
24: select aps.application_period_id,

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

55:
56: end createApplicationCache;
57:
58: function findApprovalDate
59: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
60: return hxc_timecard_summary.submission_date%type is
61:
62: cursor c_approval_date
63: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

Line 60: return hxc_timecard_summary.submission_date%type is

56: end createApplicationCache;
57:
58: function findApprovalDate
59: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
60: return hxc_timecard_summary.submission_date%type is
61:
62: cursor c_approval_date
63: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
64: select max(aps.creation_date)

Line 63: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

59: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
60: return hxc_timecard_summary.submission_date%type is
61:
62: cursor c_approval_date
63: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
64: select max(aps.creation_date)
65: from hxc_tc_ap_links tcl, hxc_app_period_summary aps
66: where tcl.timecard_id = p_timecard_id
67: and aps.approval_status = 'APPROVED'

Line 84: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is

80: return l_approval_date;
81: end findApprovalDate;
82:
83: procedure createTimecardCache
84: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
85:
86: cursor c_tc_cache_info
87: (p_tc_id in hxc_timecard_summary.timecard_id%type) is
88: select ts.timecard_id,

Line 87: (p_tc_id in hxc_timecard_summary.timecard_id%type) is

83: procedure createTimecardCache
84: (p_timecard_id in hxc_timecard_summary.timecard_id%type) is
85:
86: cursor c_tc_cache_info
87: (p_tc_id in hxc_timecard_summary.timecard_id%type) is
88: select ts.timecard_id,
89: ts.approval_status,
90: ts.recorded_hours,
91: ts.has_reasons,

Line 93: from hxc_timecard_summary ts

89: ts.approval_status,
90: ts.recorded_hours,
91: ts.has_reasons,
92: ts.submission_date
93: from hxc_timecard_summary ts
94: where ts.timecard_id = p_tc_id;
95:
96: begin
97:

Line 226: return hxc_timecard_summary.timecard_id%type is

222: end findAppPeriodId;
223:
224: function findTimecardId
225: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
226: return hxc_timecard_summary.timecard_id%type is
227:
228: cursor c_find_timecard_id
229: (p_app_period_id in hxc_app_period_summary.application_period_id%type) is
230: select timecard_id

Line 234: l_timecard_id hxc_timecard_summary.timecard_id%type;

230: select timecard_id
231: from hxc_tc_ap_links
232: where application_period_id = p_app_period_id;
233:
234: l_timecard_id hxc_timecard_summary.timecard_id%type;
235:
236: begin
237:
238: open c_find_timecard_id(p_application_period_id);

Line 252: (p_resource_id in hxc_timecard_summary.resource_id%type,

248:
249: end findTimecardId;
250:
251: function findTimecardId
252: (p_resource_id in hxc_timecard_summary.resource_id%type,
253: p_start_time in hxc_timecard_summary.start_time%type,
254: p_stop_time in hxc_timecard_summary.stop_time%type)
255: return hxc_timecard_summary.timecard_id%type is
256:

Line 253: p_start_time in hxc_timecard_summary.start_time%type,

249: end findTimecardId;
250:
251: function findTimecardId
252: (p_resource_id in hxc_timecard_summary.resource_id%type,
253: p_start_time in hxc_timecard_summary.start_time%type,
254: p_stop_time in hxc_timecard_summary.stop_time%type)
255: return hxc_timecard_summary.timecard_id%type is
256:
257: cursor c_find_timecard_id

Line 254: p_stop_time in hxc_timecard_summary.stop_time%type)

250:
251: function findTimecardId
252: (p_resource_id in hxc_timecard_summary.resource_id%type,
253: p_start_time in hxc_timecard_summary.start_time%type,
254: p_stop_time in hxc_timecard_summary.stop_time%type)
255: return hxc_timecard_summary.timecard_id%type is
256:
257: cursor c_find_timecard_id
258: (p_resource_id in hxc_timecard_summary.resource_id%type,

Line 255: return hxc_timecard_summary.timecard_id%type is

251: function findTimecardId
252: (p_resource_id in hxc_timecard_summary.resource_id%type,
253: p_start_time in hxc_timecard_summary.start_time%type,
254: p_stop_time in hxc_timecard_summary.stop_time%type)
255: return hxc_timecard_summary.timecard_id%type is
256:
257: cursor c_find_timecard_id
258: (p_resource_id in hxc_timecard_summary.resource_id%type,
259: p_start_time in hxc_timecard_summary.start_time%type,

Line 258: (p_resource_id in hxc_timecard_summary.resource_id%type,

254: p_stop_time in hxc_timecard_summary.stop_time%type)
255: return hxc_timecard_summary.timecard_id%type is
256:
257: cursor c_find_timecard_id
258: (p_resource_id in hxc_timecard_summary.resource_id%type,
259: p_start_time in hxc_timecard_summary.start_time%type,
260: p_stop_time in hxc_timecard_summary.stop_time%type) is
261: select timecard_id
262: from hxc_timecard_summary

Line 259: p_start_time in hxc_timecard_summary.start_time%type,

255: return hxc_timecard_summary.timecard_id%type is
256:
257: cursor c_find_timecard_id
258: (p_resource_id in hxc_timecard_summary.resource_id%type,
259: p_start_time in hxc_timecard_summary.start_time%type,
260: p_stop_time in hxc_timecard_summary.stop_time%type) is
261: select timecard_id
262: from hxc_timecard_summary
263: where resource_id = p_resource_id

Line 260: p_stop_time in hxc_timecard_summary.stop_time%type) is

256:
257: cursor c_find_timecard_id
258: (p_resource_id in hxc_timecard_summary.resource_id%type,
259: p_start_time in hxc_timecard_summary.start_time%type,
260: p_stop_time in hxc_timecard_summary.stop_time%type) is
261: select timecard_id
262: from hxc_timecard_summary
263: where resource_id = p_resource_id
264: and trunc(start_time) = trunc(p_start_time)

Line 262: from hxc_timecard_summary

258: (p_resource_id in hxc_timecard_summary.resource_id%type,
259: p_start_time in hxc_timecard_summary.start_time%type,
260: p_stop_time in hxc_timecard_summary.stop_time%type) is
261: select timecard_id
262: from hxc_timecard_summary
263: where resource_id = p_resource_id
264: and trunc(start_time) = trunc(p_start_time)
265: and trunc(stop_time) = trunc(p_stop_time);
266:

Line 267: l_timecard_id hxc_timecard_summary.timecard_id%type;

263: where resource_id = p_resource_id
264: and trunc(start_time) = trunc(p_start_time)
265: and trunc(stop_time) = trunc(p_stop_time);
266:
267: l_timecard_id hxc_timecard_summary.timecard_id%type;
268:
269: begin
270:
271: open c_find_timecard_id(p_resource_id,p_start_time,p_stop_time);

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

282: end findTimecardId;
283:
284:
285: function verifyCache
286: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
287: return boolean is
288:
289: begin
290:

Line 300: (p_timecard_id in hxc_timecard_summary.timecard_id%type,

296:
297: end verifyCache;
298:
299: procedure verifyOrCreateCache
300: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
301: p_application_period_id in hxc_app_period_summary.application_period_id%type) is
302:
303: l_timecard_id hxc_timecard_summary.timecard_id%type;
304:

Line 303: l_timecard_id hxc_timecard_summary.timecard_id%type;

299: procedure verifyOrCreateCache
300: (p_timecard_id in hxc_timecard_summary.timecard_id%type,
301: p_application_period_id in hxc_app_period_summary.application_period_id%type) is
302:
303: l_timecard_id hxc_timecard_summary.timecard_id%type;
304:
305: begin
306:
307: l_timecard_id := p_timecard_id;

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

326: -- Public interfaces below
327: --
328:
329: function get_timecard_approval_status
330: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
331: return hxc_timecard_summary.approval_status%type is
332:
333: begin
334: verifyOrCreateCache(p_timecard_id,null);

Line 331: return hxc_timecard_summary.approval_status%type is

327: --
328:
329: function get_timecard_approval_status
330: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
331: return hxc_timecard_summary.approval_status%type is
332:
333: begin
334: verifyOrCreateCache(p_timecard_id,null);
335: return g_timecard_info.approval_status;

Line 339: (p_resource_id in hxc_timecard_summary.resource_id%type,

335: return g_timecard_info.approval_status;
336: end get_timecard_approval_status;
337:
338: function get_timecard_approval_status
339: (p_resource_id in hxc_timecard_summary.resource_id%type,
340: p_start_time in hxc_timecard_summary.start_time%type,
341: p_stop_time in hxc_timecard_summary.stop_time%type)
342: return hxc_timecard_summary.approval_status%type is
343:

Line 340: p_start_time in hxc_timecard_summary.start_time%type,

336: end get_timecard_approval_status;
337:
338: function get_timecard_approval_status
339: (p_resource_id in hxc_timecard_summary.resource_id%type,
340: p_start_time in hxc_timecard_summary.start_time%type,
341: p_stop_time in hxc_timecard_summary.stop_time%type)
342: return hxc_timecard_summary.approval_status%type is
343:
344: begin

Line 341: p_stop_time in hxc_timecard_summary.stop_time%type)

337:
338: function get_timecard_approval_status
339: (p_resource_id in hxc_timecard_summary.resource_id%type,
340: p_start_time in hxc_timecard_summary.start_time%type,
341: p_stop_time in hxc_timecard_summary.stop_time%type)
342: return hxc_timecard_summary.approval_status%type is
343:
344: begin
345: verifyOrCreateCache

Line 342: return hxc_timecard_summary.approval_status%type is

338: function get_timecard_approval_status
339: (p_resource_id in hxc_timecard_summary.resource_id%type,
340: p_start_time in hxc_timecard_summary.start_time%type,
341: p_stop_time in hxc_timecard_summary.stop_time%type)
342: return hxc_timecard_summary.approval_status%type is
343:
344: begin
345: verifyOrCreateCache
346: (findTimecardId

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

353: return g_timecard_info.approval_status;
354: end get_timecard_approval_status;
355:
356: function get_timecard_approval_date
357: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
358: return hxc_timecard_summary.submission_date%type is
359:
360: begin
361: verifyOrCreateCache(p_timecard_id,null);

Line 358: return hxc_timecard_summary.submission_date%type is

354: end get_timecard_approval_status;
355:
356: function get_timecard_approval_date
357: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
358: return hxc_timecard_summary.submission_date%type is
359:
360: begin
361: verifyOrCreateCache(p_timecard_id,null);
362: return g_timecard_info.approval_date;

Line 366: (p_resource_id in hxc_timecard_summary.resource_id%type,

362: return g_timecard_info.approval_date;
363: end get_timecard_approval_date;
364:
365: function get_timecard_approval_date
366: (p_resource_id in hxc_timecard_summary.resource_id%type,
367: p_start_time in hxc_timecard_summary.start_time%type,
368: p_stop_time in hxc_timecard_summary.stop_time%type)
369: return hxc_timecard_summary.submission_date%type is
370:

Line 367: p_start_time in hxc_timecard_summary.start_time%type,

363: end get_timecard_approval_date;
364:
365: function get_timecard_approval_date
366: (p_resource_id in hxc_timecard_summary.resource_id%type,
367: p_start_time in hxc_timecard_summary.start_time%type,
368: p_stop_time in hxc_timecard_summary.stop_time%type)
369: return hxc_timecard_summary.submission_date%type is
370:
371: begin

Line 368: p_stop_time in hxc_timecard_summary.stop_time%type)

364:
365: function get_timecard_approval_date
366: (p_resource_id in hxc_timecard_summary.resource_id%type,
367: p_start_time in hxc_timecard_summary.start_time%type,
368: p_stop_time in hxc_timecard_summary.stop_time%type)
369: return hxc_timecard_summary.submission_date%type is
370:
371: begin
372: verifyOrCreateCache

Line 369: return hxc_timecard_summary.submission_date%type is

365: function get_timecard_approval_date
366: (p_resource_id in hxc_timecard_summary.resource_id%type,
367: p_start_time in hxc_timecard_summary.start_time%type,
368: p_stop_time in hxc_timecard_summary.stop_time%type)
369: return hxc_timecard_summary.submission_date%type is
370:
371: begin
372: verifyOrCreateCache
373: (findTimecardId

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

380: return g_timecard_info.approval_date;
381: end get_timecard_approval_date;
382:
383: function get_timecard_recorded_hours
384: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
385: return hxc_timecard_summary.recorded_hours%type is
386:
387: begin
388: verifyOrCreateCache(p_timecard_id,null);

Line 385: return hxc_timecard_summary.recorded_hours%type is

381: end get_timecard_approval_date;
382:
383: function get_timecard_recorded_hours
384: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
385: return hxc_timecard_summary.recorded_hours%type is
386:
387: begin
388: verifyOrCreateCache(p_timecard_id,null);
389: return g_timecard_info.recorded_hours;

Line 393: (p_resource_id in hxc_timecard_summary.resource_id%type,

389: return g_timecard_info.recorded_hours;
390: end get_timecard_recorded_hours;
391:
392: function get_timecard_recorded_hours
393: (p_resource_id in hxc_timecard_summary.resource_id%type,
394: p_start_time in hxc_timecard_summary.start_time%type,
395: p_stop_time in hxc_timecard_summary.stop_time%type)
396: return hxc_timecard_summary.recorded_hours%type is
397:

Line 394: p_start_time in hxc_timecard_summary.start_time%type,

390: end get_timecard_recorded_hours;
391:
392: function get_timecard_recorded_hours
393: (p_resource_id in hxc_timecard_summary.resource_id%type,
394: p_start_time in hxc_timecard_summary.start_time%type,
395: p_stop_time in hxc_timecard_summary.stop_time%type)
396: return hxc_timecard_summary.recorded_hours%type is
397:
398: begin

Line 395: p_stop_time in hxc_timecard_summary.stop_time%type)

391:
392: function get_timecard_recorded_hours
393: (p_resource_id in hxc_timecard_summary.resource_id%type,
394: p_start_time in hxc_timecard_summary.start_time%type,
395: p_stop_time in hxc_timecard_summary.stop_time%type)
396: return hxc_timecard_summary.recorded_hours%type is
397:
398: begin
399: verifyOrCreateCache

Line 396: return hxc_timecard_summary.recorded_hours%type is

392: function get_timecard_recorded_hours
393: (p_resource_id in hxc_timecard_summary.resource_id%type,
394: p_start_time in hxc_timecard_summary.start_time%type,
395: p_stop_time in hxc_timecard_summary.stop_time%type)
396: return hxc_timecard_summary.recorded_hours%type is
397:
398: begin
399: verifyOrCreateCache
400: (findTimecardId

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

407: return g_timecard_info.recorded_hours;
408: end get_timecard_recorded_hours;
409:
410: function get_timecard_audit_data_exists
411: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
412: return hxc_timecard_summary.has_reasons%type is
413:
414: begin
415: verifyOrCreateCache(p_timecard_id, null);

Line 412: return hxc_timecard_summary.has_reasons%type is

408: end get_timecard_recorded_hours;
409:
410: function get_timecard_audit_data_exists
411: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
412: return hxc_timecard_summary.has_reasons%type is
413:
414: begin
415: verifyOrCreateCache(p_timecard_id, null);
416: return g_timecard_info.audit_data_exists;

Line 420: (p_resource_id in hxc_timecard_summary.resource_id%type,

416: return g_timecard_info.audit_data_exists;
417: end get_timecard_audit_data_exists;
418:
419: function get_timecard_audit_data_exists
420: (p_resource_id in hxc_timecard_summary.resource_id%type,
421: p_start_time in hxc_timecard_summary.start_time%type,
422: p_stop_time in hxc_timecard_summary.stop_time%type)
423: return hxc_timecard_summary.has_reasons%type is
424:

Line 421: p_start_time in hxc_timecard_summary.start_time%type,

417: end get_timecard_audit_data_exists;
418:
419: function get_timecard_audit_data_exists
420: (p_resource_id in hxc_timecard_summary.resource_id%type,
421: p_start_time in hxc_timecard_summary.start_time%type,
422: p_stop_time in hxc_timecard_summary.stop_time%type)
423: return hxc_timecard_summary.has_reasons%type is
424:
425: begin

Line 422: p_stop_time in hxc_timecard_summary.stop_time%type)

418:
419: function get_timecard_audit_data_exists
420: (p_resource_id in hxc_timecard_summary.resource_id%type,
421: p_start_time in hxc_timecard_summary.start_time%type,
422: p_stop_time in hxc_timecard_summary.stop_time%type)
423: return hxc_timecard_summary.has_reasons%type is
424:
425: begin
426: verifyOrCreateCache

Line 423: return hxc_timecard_summary.has_reasons%type is

419: function get_timecard_audit_data_exists
420: (p_resource_id in hxc_timecard_summary.resource_id%type,
421: p_start_time in hxc_timecard_summary.start_time%type,
422: p_stop_time in hxc_timecard_summary.stop_time%type)
423: return hxc_timecard_summary.has_reasons%type is
424:
425: begin
426: verifyOrCreateCache
427: (findTimecardId

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

434: return g_timecard_info.audit_data_exists;
435: end get_timecard_audit_data_exists;
436:
437: function get_timecard_submission_date
438: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
439: return hxc_timecard_summary.submission_date%type is
440:
441: begin
442: verifyOrCreateCache(p_timecard_id,null);

Line 439: return hxc_timecard_summary.submission_date%type is

435: end get_timecard_audit_data_exists;
436:
437: function get_timecard_submission_date
438: (p_timecard_id in hxc_timecard_summary.timecard_id%type)
439: return hxc_timecard_summary.submission_date%type is
440:
441: begin
442: verifyOrCreateCache(p_timecard_id,null);
443: return g_timecard_info.submission_date;

Line 447: (p_resource_id in hxc_timecard_summary.resource_id%type,

443: return g_timecard_info.submission_date;
444: end get_timecard_submission_date;
445:
446: function get_timecard_submission_date
447: (p_resource_id in hxc_timecard_summary.resource_id%type,
448: p_start_time in hxc_timecard_summary.start_time%type,
449: p_stop_time in hxc_timecard_summary.stop_time%type)
450: return hxc_timecard_summary.submission_date%type is
451:

Line 448: p_start_time in hxc_timecard_summary.start_time%type,

444: end get_timecard_submission_date;
445:
446: function get_timecard_submission_date
447: (p_resource_id in hxc_timecard_summary.resource_id%type,
448: p_start_time in hxc_timecard_summary.start_time%type,
449: p_stop_time in hxc_timecard_summary.stop_time%type)
450: return hxc_timecard_summary.submission_date%type is
451:
452: begin

Line 449: p_stop_time in hxc_timecard_summary.stop_time%type)

445:
446: function get_timecard_submission_date
447: (p_resource_id in hxc_timecard_summary.resource_id%type,
448: p_start_time in hxc_timecard_summary.start_time%type,
449: p_stop_time in hxc_timecard_summary.stop_time%type)
450: return hxc_timecard_summary.submission_date%type is
451:
452: begin
453: verifyOrCreateCache

Line 450: return hxc_timecard_summary.submission_date%type is

446: function get_timecard_submission_date
447: (p_resource_id in hxc_timecard_summary.resource_id%type,
448: p_start_time in hxc_timecard_summary.start_time%type,
449: p_stop_time in hxc_timecard_summary.stop_time%type)
450: return hxc_timecard_summary.submission_date%type is
451:
452: begin
453: verifyOrCreateCache
454: (findTimecardId