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_CATEGORIES

Line 115: (p_time_category_name in hxc_time_categories.time_category_name%type)

111: end if;
112: end createTimecardCache;
113:
114: function findTimeCategoryId
115: (p_time_category_name in hxc_time_categories.time_category_name%type)
116: return hxc_time_categories.time_category_id%type is
117:
118: cursor c_tc_id
119: (p_name in hxc_time_categories.time_category_name%type) is

Line 116: return hxc_time_categories.time_category_id%type is

112: end createTimecardCache;
113:
114: function findTimeCategoryId
115: (p_time_category_name in hxc_time_categories.time_category_name%type)
116: return hxc_time_categories.time_category_id%type is
117:
118: cursor c_tc_id
119: (p_name in hxc_time_categories.time_category_name%type) is
120: select time_category_id

Line 119: (p_name in hxc_time_categories.time_category_name%type) is

115: (p_time_category_name in hxc_time_categories.time_category_name%type)
116: return hxc_time_categories.time_category_id%type is
117:
118: cursor c_tc_id
119: (p_name in hxc_time_categories.time_category_name%type) is
120: select time_category_id
121: from hxc_time_categories
122: where time_category_name = p_name;
123:

Line 121: from hxc_time_categories

117:
118: cursor c_tc_id
119: (p_name in hxc_time_categories.time_category_name%type) is
120: select time_category_id
121: from hxc_time_categories
122: where time_category_name = p_name;
123:
124: l_tc_id hxc_time_categories.time_category_id%type;
125:

Line 124: l_tc_id hxc_time_categories.time_category_id%type;

120: select time_category_id
121: from hxc_time_categories
122: where time_category_name = p_name;
123:
124: l_tc_id hxc_time_categories.time_category_id%type;
125:
126: begin
127:
128: if(p_time_category_name is not null) then

Line 180: p_time_category_name in hxc_time_categories.time_category_name%type)

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
184: (p_resource_id in hxc_app_period_summary.resource_id%type,

Line 198: l_time_category_id hxc_time_categories.time_category_id%type;

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

Line 490: p_time_category_name in hxc_time_categories.time_category_name%type

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

Line 539: p_time_category_name in hxc_time_categories.time_category_name%type

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;
543: begin

Line 585: p_time_category_name in hxc_time_categories.time_category_name%type

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;
589: begin