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_TIME_RECIPIENTS

Line 148: (p_time_recipient_name in hxc_time_recipients.name%type)

144:
145: end findTimeCategoryId;
146:
147: function findTimeRecipientId
148: (p_time_recipient_name in hxc_time_recipients.name%type)
149: return hxc_time_recipients.time_recipient_id%type is
150:
151: cursor c_find_tr_id
152: (p_name in hxc_time_recipients.name%type) is

Line 149: return hxc_time_recipients.time_recipient_id%type is

145: end findTimeCategoryId;
146:
147: function findTimeRecipientId
148: (p_time_recipient_name in hxc_time_recipients.name%type)
149: return hxc_time_recipients.time_recipient_id%type is
150:
151: cursor c_find_tr_id
152: (p_name in hxc_time_recipients.name%type) is
153: select time_recipient_id

Line 152: (p_name in hxc_time_recipients.name%type) is

148: (p_time_recipient_name in hxc_time_recipients.name%type)
149: return hxc_time_recipients.time_recipient_id%type is
150:
151: cursor c_find_tr_id
152: (p_name in hxc_time_recipients.name%type) is
153: select time_recipient_id
154: from hxc_time_recipients
155: where name = p_name;
156:

Line 154: from hxc_time_recipients

150:
151: cursor c_find_tr_id
152: (p_name in hxc_time_recipients.name%type) is
153: select time_recipient_id
154: from hxc_time_recipients
155: where name = p_name;
156:
157: l_tr_id hxc_time_recipients.time_recipient_id%type;
158:

Line 157: l_tr_id hxc_time_recipients.time_recipient_id%type;

153: select time_recipient_id
154: from hxc_time_recipients
155: where name = p_name;
156:
157: l_tr_id hxc_time_recipients.time_recipient_id%type;
158:
159: begin
160:
161: open c_find_tr_id(p_time_recipient_name);

Line 179: p_application_name in hxc_time_recipients.name%type,

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:
183: cursor c_find_app_period

Line 197: l_time_recipient_id hxc_time_recipients.time_recipient_id%type;

193: and trunc(stop_time) = trunc(p_stop_time)
194: and time_recipient_id = p_time_recipient_id
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

Line 477: p_application_name in hxc_time_recipients.name%type

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

Line 489: p_application_name in hxc_time_recipients.name%type,

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

Line 520: p_application_name in hxc_time_recipients.name%type

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

Line 538: p_application_name in hxc_time_recipients.name%type,

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
542: l_application_period_id hxc_app_period_summary.application_period_id%type;

Line 566: p_application_name in hxc_time_recipients.name%type

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

Line 584: p_application_name in hxc_time_recipients.name%type,

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
588: l_application_period_id hxc_app_period_summary.application_period_id%type;