eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIME_APPROVAL_INFO dependencies on HXC_APP_PERIOD_SUMMARY

Line 31: hxc_app_period_summary aps

27: aps.notification_status,
28: aps.approver_id,
29: aps.time_recipient_id
30: from hxc_tc_ap_links tcl,
31: hxc_app_period_summary aps
32: where tcl.timecard_id = p_tc_id
33: and tcl.application_period_id = aps.application_period_id;
34:
35: l_dummy_name varchar2(360);

Line 65: from hxc_tc_ap_links tcl, hxc_app_period_summary aps

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'
68: and aps.application_period_id = tcl.application_period_id;
69:

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

172:
173: end findTimeRecipientId;
174:
175: function findAppPeriodId
176: (p_resource_id in hxc_app_period_summary.resource_id%type,
177: p_start_time in hxc_app_period_summary.start_time%type,
178: p_stop_time in hxc_app_period_summary.stop_time%type,
179: p_application_name in hxc_time_recipients.name%type,
180: p_time_category_name in hxc_time_categories.time_category_name%type)

Line 177: p_start_time in hxc_app_period_summary.start_time%type,

173: end findTimeRecipientId;
174:
175: function findAppPeriodId
176: (p_resource_id in hxc_app_period_summary.resource_id%type,
177: p_start_time in hxc_app_period_summary.start_time%type,
178: p_stop_time in hxc_app_period_summary.stop_time%type,
179: p_application_name in hxc_time_recipients.name%type,
180: p_time_category_name in hxc_time_categories.time_category_name%type)
181: return hxc_app_period_summary.application_period_id%type is

Line 178: p_stop_time in hxc_app_period_summary.stop_time%type,

174:
175: function findAppPeriodId
176: (p_resource_id in hxc_app_period_summary.resource_id%type,
177: p_start_time in hxc_app_period_summary.start_time%type,
178: p_stop_time in hxc_app_period_summary.stop_time%type,
179: p_application_name in hxc_time_recipients.name%type,
180: p_time_category_name in hxc_time_categories.time_category_name%type)
181: return hxc_app_period_summary.application_period_id%type is
182:

Line 181: return hxc_app_period_summary.application_period_id%type is

177: p_start_time in hxc_app_period_summary.start_time%type,
178: p_stop_time in hxc_app_period_summary.stop_time%type,
179: p_application_name in hxc_time_recipients.name%type,
180: p_time_category_name in hxc_time_categories.time_category_name%type)
181: return hxc_app_period_summary.application_period_id%type is
182:
183: cursor c_find_app_period
184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,

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

180: p_time_category_name in hxc_time_categories.time_category_name%type)
181: return hxc_app_period_summary.application_period_id%type is
182:
183: cursor c_find_app_period
184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,
186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is

Line 185: p_start_time in hxc_app_period_summary.start_time%type,

181: return hxc_app_period_summary.application_period_id%type is
182:
183: cursor c_find_app_period
184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,
186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is
189: select application_period_id

Line 186: p_stop_time in hxc_app_period_summary.stop_time%type,

182:
183: cursor c_find_app_period
184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,
186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is
189: select application_period_id
190: from hxc_app_period_summary

Line 187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,

183: cursor c_find_app_period
184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,
186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is
189: select application_period_id
190: from hxc_app_period_summary
191: where resource_id = p_resource_id

Line 188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is

184: (p_resource_id in hxc_app_period_summary.resource_id%type,
185: p_start_time in hxc_app_period_summary.start_time%type,
186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is
189: select application_period_id
190: from hxc_app_period_summary
191: where resource_id = p_resource_id
192: and trunc(start_time) = trunc(p_start_time)

Line 190: from hxc_app_period_summary

186: p_stop_time in hxc_app_period_summary.stop_time%type,
187: p_time_recipient_id in hxc_app_period_summary.time_recipient_id%type,
188: p_time_category_id in hxc_app_period_summary.time_category_id%type) is
189: select application_period_id
190: from hxc_app_period_summary
191: where resource_id = p_resource_id
192: and trunc(start_time) = trunc(p_start_time)
193: and trunc(stop_time) = trunc(p_stop_time)
194: and time_recipient_id = p_time_recipient_id

Line 199: l_application_period_id hxc_app_period_summary.application_period_id%type;

195: and nvl(time_category_id,-1) = nvl(p_time_category_id,-1);
196:
197: l_time_recipient_id hxc_time_recipients.time_recipient_id%type;
198: l_time_category_id hxc_time_categories.time_category_id%type;
199: l_application_period_id hxc_app_period_summary.application_period_id%type;
200:
201: begin
202:
203: l_time_recipient_id := findTimeRecipientId(p_application_name);

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

221:
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

Line 229: (p_app_period_id in hxc_app_period_summary.application_period_id%type) is

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
231: from hxc_tc_ap_links
232: where application_period_id = p_app_period_id;
233:

Line 301: p_application_period_id in hxc_app_period_summary.application_period_id%type) is

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:
305: begin

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

461: return g_timecard_info.submission_date;
462: end get_timecard_submission_date;
463:
464: function get_app_approval_status
465: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
466: return hxc_app_period_summary.approval_status%type is
467:
468: begin
469: verifyOrCreateCache(findTimecardId(p_application_period_id),p_application_period_id);

Line 466: return hxc_app_period_summary.approval_status%type is

462: end get_timecard_submission_date;
463:
464: function get_app_approval_status
465: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
466: return hxc_app_period_summary.approval_status%type is
467:
468: begin
469: verifyOrCreateCache(findTimecardId(p_application_period_id),p_application_period_id);
470: return g_application_info(p_application_period_id).approval_status;

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

470: return g_application_info(p_application_period_id).approval_status;
471: end get_app_approval_status;
472:
473: function get_app_approval_status
474: (p_resource_id in hxc_app_period_summary.resource_id%type,
475: p_start_time in hxc_app_period_summary.start_time%type,
476: p_stop_time in hxc_app_period_summary.stop_time%type,
477: p_application_name in hxc_time_recipients.name%type
478: )

Line 475: p_start_time in hxc_app_period_summary.start_time%type,

471: end get_app_approval_status;
472:
473: function get_app_approval_status
474: (p_resource_id in hxc_app_period_summary.resource_id%type,
475: p_start_time in hxc_app_period_summary.start_time%type,
476: p_stop_time in hxc_app_period_summary.stop_time%type,
477: p_application_name in hxc_time_recipients.name%type
478: )
479: return hxc_app_period_summary.approval_status%type is

Line 476: p_stop_time in hxc_app_period_summary.stop_time%type,

472:
473: function get_app_approval_status
474: (p_resource_id in hxc_app_period_summary.resource_id%type,
475: p_start_time in hxc_app_period_summary.start_time%type,
476: p_stop_time in hxc_app_period_summary.stop_time%type,
477: p_application_name in hxc_time_recipients.name%type
478: )
479: return hxc_app_period_summary.approval_status%type is
480:

Line 479: return hxc_app_period_summary.approval_status%type is

475: p_start_time in hxc_app_period_summary.start_time%type,
476: p_stop_time in hxc_app_period_summary.stop_time%type,
477: p_application_name in hxc_time_recipients.name%type
478: )
479: return hxc_app_period_summary.approval_status%type is
480:
481: begin
482: return get_app_approval_status(p_resource_id,p_start_time,p_stop_time,p_application_name,null);
483: end get_app_approval_status;

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

482: return get_app_approval_status(p_resource_id,p_start_time,p_stop_time,p_application_name,null);
483: end get_app_approval_status;
484:
485: function get_app_approval_status
486: (p_resource_id in hxc_app_period_summary.resource_id%type,
487: p_start_time in hxc_app_period_summary.start_time%type,
488: p_stop_time in hxc_app_period_summary.stop_time%type,
489: p_application_name in hxc_time_recipients.name%type,
490: p_time_category_name in hxc_time_categories.time_category_name%type

Line 487: p_start_time in hxc_app_period_summary.start_time%type,

483: end get_app_approval_status;
484:
485: function get_app_approval_status
486: (p_resource_id in hxc_app_period_summary.resource_id%type,
487: p_start_time in hxc_app_period_summary.start_time%type,
488: p_stop_time in hxc_app_period_summary.stop_time%type,
489: p_application_name in hxc_time_recipients.name%type,
490: p_time_category_name in hxc_time_categories.time_category_name%type
491: )

Line 488: p_stop_time in hxc_app_period_summary.stop_time%type,

484:
485: function get_app_approval_status
486: (p_resource_id in hxc_app_period_summary.resource_id%type,
487: p_start_time in hxc_app_period_summary.start_time%type,
488: p_stop_time in hxc_app_period_summary.stop_time%type,
489: p_application_name in hxc_time_recipients.name%type,
490: p_time_category_name in hxc_time_categories.time_category_name%type
491: )
492: return hxc_app_period_summary.approval_status%type is

Line 492: return hxc_app_period_summary.approval_status%type is

488: p_stop_time in hxc_app_period_summary.stop_time%type,
489: p_application_name in hxc_time_recipients.name%type,
490: p_time_category_name in hxc_time_categories.time_category_name%type
491: )
492: return hxc_app_period_summary.approval_status%type is
493:
494: l_application_period_id hxc_app_period_summary.application_period_id%type;
495:
496: begin

Line 494: l_application_period_id hxc_app_period_summary.application_period_id%type;

490: p_time_category_name in hxc_time_categories.time_category_name%type
491: )
492: return hxc_app_period_summary.approval_status%type is
493:
494: l_application_period_id hxc_app_period_summary.application_period_id%type;
495:
496: begin
497: l_application_period_id := findAppPeriodId
498: (p_resource_id,

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

504: return g_application_info(l_application_period_id).approval_status;
505: end get_app_approval_status;
506:
507: function get_app_creation_date
508: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
509: return hxc_app_period_summary.creation_date%type is
510:
511: begin
512: verifyOrCreateCache(findTimecardId(p_application_period_id), p_application_period_id);

Line 509: return hxc_app_period_summary.creation_date%type is

505: end get_app_approval_status;
506:
507: function get_app_creation_date
508: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
509: return hxc_app_period_summary.creation_date%type is
510:
511: begin
512: verifyOrCreateCache(findTimecardId(p_application_period_id), p_application_period_id);
513: return g_application_info(p_application_period_id).creation_date;

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

513: return g_application_info(p_application_period_id).creation_date;
514: end get_app_creation_date;
515:
516: function get_app_creation_date
517: (p_resource_id in hxc_app_period_summary.resource_id%type,
518: p_start_time in hxc_app_period_summary.start_time%type,
519: p_stop_time in hxc_app_period_summary.stop_time%type,
520: p_application_name in hxc_time_recipients.name%type
521: )

Line 518: p_start_time in hxc_app_period_summary.start_time%type,

514: end get_app_creation_date;
515:
516: function get_app_creation_date
517: (p_resource_id in hxc_app_period_summary.resource_id%type,
518: p_start_time in hxc_app_period_summary.start_time%type,
519: p_stop_time in hxc_app_period_summary.stop_time%type,
520: p_application_name in hxc_time_recipients.name%type
521: )
522: return hxc_app_period_summary.creation_date%type is

Line 519: p_stop_time in hxc_app_period_summary.stop_time%type,

515:
516: function get_app_creation_date
517: (p_resource_id in hxc_app_period_summary.resource_id%type,
518: p_start_time in hxc_app_period_summary.start_time%type,
519: p_stop_time in hxc_app_period_summary.stop_time%type,
520: p_application_name in hxc_time_recipients.name%type
521: )
522: return hxc_app_period_summary.creation_date%type is
523:

Line 522: return hxc_app_period_summary.creation_date%type is

518: p_start_time in hxc_app_period_summary.start_time%type,
519: p_stop_time in hxc_app_period_summary.stop_time%type,
520: p_application_name in hxc_time_recipients.name%type
521: )
522: return hxc_app_period_summary.creation_date%type is
523:
524: begin
525: return get_app_creation_date
526: (p_resource_id,

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

531: );
532: end get_app_creation_date;
533:
534: function get_app_creation_date
535: (p_resource_id in hxc_app_period_summary.resource_id%type,
536: p_start_time in hxc_app_period_summary.start_time%type,
537: p_stop_time in hxc_app_period_summary.stop_time%type,
538: p_application_name in hxc_time_recipients.name%type,
539: p_time_category_name in hxc_time_categories.time_category_name%type

Line 536: p_start_time in hxc_app_period_summary.start_time%type,

532: end get_app_creation_date;
533:
534: function get_app_creation_date
535: (p_resource_id in hxc_app_period_summary.resource_id%type,
536: p_start_time in hxc_app_period_summary.start_time%type,
537: p_stop_time in hxc_app_period_summary.stop_time%type,
538: p_application_name in hxc_time_recipients.name%type,
539: p_time_category_name in hxc_time_categories.time_category_name%type
540: )

Line 537: p_stop_time in hxc_app_period_summary.stop_time%type,

533:
534: function get_app_creation_date
535: (p_resource_id in hxc_app_period_summary.resource_id%type,
536: p_start_time in hxc_app_period_summary.start_time%type,
537: p_stop_time in hxc_app_period_summary.stop_time%type,
538: p_application_name in hxc_time_recipients.name%type,
539: p_time_category_name in hxc_time_categories.time_category_name%type
540: )
541: return hxc_app_period_summary.creation_date%type is

Line 541: return hxc_app_period_summary.creation_date%type is

537: p_stop_time in hxc_app_period_summary.stop_time%type,
538: p_application_name in hxc_time_recipients.name%type,
539: p_time_category_name in hxc_time_categories.time_category_name%type
540: )
541: return hxc_app_period_summary.creation_date%type is
542: l_application_period_id hxc_app_period_summary.application_period_id%type;
543: begin
544: l_application_period_id := findAppPeriodId
545: (p_resource_id,

Line 542: l_application_period_id hxc_app_period_summary.application_period_id%type;

538: p_application_name in hxc_time_recipients.name%type,
539: p_time_category_name in hxc_time_categories.time_category_name%type
540: )
541: return hxc_app_period_summary.creation_date%type is
542: l_application_period_id hxc_app_period_summary.application_period_id%type;
543: begin
544: l_application_period_id := findAppPeriodId
545: (p_resource_id,
546: p_start_time,

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

551: return g_application_info(l_application_period_id).creation_date;
552: end get_app_creation_date;
553:
554: function get_app_approver
555: (p_application_period_id in hxc_app_period_summary.application_period_id%type)
556: return varchar2 is
557: begin
558: verifyOrCreateCache(findTimecardId(p_application_period_id),p_application_period_id);
559: return g_application_info(p_application_period_id).approver;

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

559: return g_application_info(p_application_period_id).approver;
560: end get_app_approver;
561:
562: function get_app_approver
563: (p_resource_id in hxc_app_period_summary.resource_id%type,
564: p_start_time in hxc_app_period_summary.start_time%type,
565: p_stop_time in hxc_app_period_summary.stop_time%type,
566: p_application_name in hxc_time_recipients.name%type
567: )

Line 564: p_start_time in hxc_app_period_summary.start_time%type,

560: end get_app_approver;
561:
562: function get_app_approver
563: (p_resource_id in hxc_app_period_summary.resource_id%type,
564: p_start_time in hxc_app_period_summary.start_time%type,
565: p_stop_time in hxc_app_period_summary.stop_time%type,
566: p_application_name in hxc_time_recipients.name%type
567: )
568: return varchar2 is

Line 565: p_stop_time in hxc_app_period_summary.stop_time%type,

561:
562: function get_app_approver
563: (p_resource_id in hxc_app_period_summary.resource_id%type,
564: p_start_time in hxc_app_period_summary.start_time%type,
565: p_stop_time in hxc_app_period_summary.stop_time%type,
566: p_application_name in hxc_time_recipients.name%type
567: )
568: return varchar2 is
569:

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

577: );
578: end get_app_approver;
579:
580: function get_app_approver
581: (p_resource_id in hxc_app_period_summary.resource_id%type,
582: p_start_time in hxc_app_period_summary.start_time%type,
583: p_stop_time in hxc_app_period_summary.stop_time%type,
584: p_application_name in hxc_time_recipients.name%type,
585: p_time_category_name in hxc_time_categories.time_category_name%type

Line 582: p_start_time in hxc_app_period_summary.start_time%type,

578: end get_app_approver;
579:
580: function get_app_approver
581: (p_resource_id in hxc_app_period_summary.resource_id%type,
582: p_start_time in hxc_app_period_summary.start_time%type,
583: p_stop_time in hxc_app_period_summary.stop_time%type,
584: p_application_name in hxc_time_recipients.name%type,
585: p_time_category_name in hxc_time_categories.time_category_name%type
586: )

Line 583: p_stop_time in hxc_app_period_summary.stop_time%type,

579:
580: function get_app_approver
581: (p_resource_id in hxc_app_period_summary.resource_id%type,
582: p_start_time in hxc_app_period_summary.start_time%type,
583: p_stop_time in hxc_app_period_summary.stop_time%type,
584: p_application_name in hxc_time_recipients.name%type,
585: p_time_category_name in hxc_time_categories.time_category_name%type
586: )
587: return varchar2 is

Line 588: l_application_period_id hxc_app_period_summary.application_period_id%type;

584: p_application_name in hxc_time_recipients.name%type,
585: p_time_category_name in hxc_time_categories.time_category_name%type
586: )
587: return varchar2 is
588: l_application_period_id hxc_app_period_summary.application_period_id%type;
589: begin
590: l_application_period_id := findAppPeriodId
591: (p_resource_id,
592: p_start_time,