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_APPROVAL_UTILITIES dependencies on HXC_TIME_BUILDING_BLOCKS

Line 5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE

1: PACKAGE BODY hxc_approval_utilities AS
2: /* $Header: hxcaprutil.pkb 120.7.12010000.2 2008/10/17 15:50:41 bbayragi ship $ */
3:
4: TYPE approval_notification is RECORD(
5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE

Line 6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE

2: /* $Header: hxcaprutil.pkb 120.7.12010000.2 2008/10/17 15:50:41 bbayragi ship $ */
3:
4: TYPE approval_notification is RECORD(
5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE

Line 7: ,start_time hxc_time_building_blocks.start_time%TYPE

3:
4: TYPE approval_notification is RECORD(
5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE

Line 8: ,stop_time hxc_time_building_blocks.stop_time%TYPE

4: TYPE approval_notification is RECORD(
5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE
12: ,application_name fnd_application_tl.application_name%TYPE

Line 9: ,approval_status hxc_time_building_blocks.approval_status%TYPE

5: time_building_block_id hxc_time_building_blocks.time_building_block_id%TYPE
6: ,object_version_number hxc_time_building_blocks.object_version_number%TYPE
7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE
12: ,application_name fnd_application_tl.application_name%TYPE
13: ,resource_id hxc_time_building_blocks.resource_id%TYPE

Line 11: ,comment_text hxc_time_building_blocks.comment_text%TYPE

7: ,start_time hxc_time_building_blocks.start_time%TYPE
8: ,stop_time hxc_time_building_blocks.stop_time%TYPE
9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE
12: ,application_name fnd_application_tl.application_name%TYPE
13: ,resource_id hxc_time_building_blocks.resource_id%TYPE
14: ,total_hours NUMBER(15, 3)
15: ,premium_hours NUMBER(15, 3)

Line 13: ,resource_id hxc_time_building_blocks.resource_id%TYPE

9: ,approval_status hxc_time_building_blocks.approval_status%TYPE
10: ,employee_name per_all_people_f.full_name%TYPE
11: ,comment_text hxc_time_building_blocks.comment_text%TYPE
12: ,application_name fnd_application_tl.application_name%TYPE
13: ,resource_id hxc_time_building_blocks.resource_id%TYPE
14: ,total_hours NUMBER(15, 3)
15: ,premium_hours NUMBER(15, 3)
16: ,non_worked_hours NUMBER(15, 3)
17: ,time_recipient_id NUMBER(15)

Line 30: ,p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

26: g_debug BOOLEAN := hr_utility.debug_enabled;
27:
28: FUNCTION is_selected(
29: p_selected_ids IN hxc_deposit_wrapper_utilities.t_simple_table
30: ,p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
31: )
32: RETURN BOOLEAN
33: IS
34: l_proc VARCHAR2(100);

Line 109: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

105: RETURN l_block_ids;
106: END get_block_ids;
107:
108: FUNCTION has_comment(
109: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
110: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
111: ,p_operator IN VARCHAR2
112: ,p_comment IN VARCHAR2
113:

Line 110: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

106: END get_block_ids;
107:
108: FUNCTION has_comment(
109: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
110: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
111: ,p_operator IN VARCHAR2
112: ,p_comment IN VARCHAR2
113:
114: ) RETURN VARCHAR2

Line 152: || ' FROM hxc_time_building_blocks htbb,'

148: || '''';
149: */
150: -- New l_sql
151: l_sql := 'SELECT ''Y'''
152: || ' FROM hxc_time_building_blocks htbb,'
153: || ' hxc_time_building_blocks htbb_tc'
154: || ' WHERE htbb.time_building_block_id = ' || p_block_id
155: || ' AND htbb.object_version_number = ' || p_block_ovn
156: || ' AND htbb_tc.scope = ''TIMECARD'''

Line 153: || ' hxc_time_building_blocks htbb_tc'

149: */
150: -- New l_sql
151: l_sql := 'SELECT ''Y'''
152: || ' FROM hxc_time_building_blocks htbb,'
153: || ' hxc_time_building_blocks htbb_tc'
154: || ' WHERE htbb.time_building_block_id = ' || p_block_id
155: || ' AND htbb.object_version_number = ' || p_block_ovn
156: || ' AND htbb_tc.scope = ''TIMECARD'''
157: || ' AND htbb_tc.resource_id = htbb.resource_id'

Line 181: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

177: RETURN 'Y';
178: END has_comment;
179:
180: FUNCTION has_detail_comment(
181: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
182: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
183: ,p_operator IN VARCHAR2
184: ,p_comment IN VARCHAR2
185:

Line 182: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

178: END has_comment;
179:
180: FUNCTION has_detail_comment(
181: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
182: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
183: ,p_operator IN VARCHAR2
184: ,p_comment IN VARCHAR2
185:
186: ) RETURN VARCHAR2

Line 204: || ' hxc_time_building_blocks htbb_detail'

200: END IF;
201:
202: l_sql := 'SELECT ''Y'''
203: || ' FROM hxc_ap_detail_links aplinks,'
204: || ' hxc_time_building_blocks htbb_detail'
205: || ' WHERE aplinks.application_period_id = ' || p_block_id
206: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '
207: || ' AND aplinks.time_building_block_ovn = htbb_detail.object_version_number '
208: || ' AND htbb_detail.date_to = hr_general.end_of_time'

Line 266: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

262:
263:
264:
265: FUNCTION attribute_search(
266: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
267: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
268: ,p_search_by IN VARCHAR2
269: ,p_search_value IN VARCHAR2
270: ,p_search_operator IN VARCHAR2

Line 267: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE

263:
264:
265: FUNCTION attribute_search(
266: p_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
267: ,p_block_ovn IN hxc_time_building_blocks.object_version_number%TYPE
268: ,p_search_by IN VARCHAR2
269: ,p_search_value IN VARCHAR2
270: ,p_search_operator IN VARCHAR2
271: ,p_resource_id IN VARCHAR2

Line 325: || ' hxc_time_building_blocks htbb_detail,'

321:
322:
323: l_sql := 'SELECT ''Y'''
324: || ' FROM hxc_ap_detail_links aplinks,'
325: || ' hxc_time_building_blocks htbb_detail,'
326: || ' hxc_time_attribute_usages htau,'
327: || ' hxc_time_attributes hta'
328: || ' WHERE aplinks.application_period_id = ' || p_block_id
329: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '

Line 340: || ' hxc_time_building_blocks htbb_detail,'

336: || ' AND hta.' || l_segment ||' '|| p_search_operator||' '||''''||l_like_string || p_search_value||l_like_string||'''';
337: else
338: l_sql := 'SELECT ''Y'''
339: || ' FROM hxc_ap_detail_links aplinks,'
340: || ' hxc_time_building_blocks htbb_detail,'
341: || ' hxc_time_attribute_usages htau,'
342: || ' hxc_time_attributes hta'
343: || ' WHERE aplinks.application_period_id = ' || p_block_id
344: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '

Line 422: l_sql_from := 'FROM hxc_time_building_blocks htbb';

418: hr_utility.set_location(g_package||l_proc, 20);
419: end if;
420:
421: l_sql_select := 'SELECT time_building_block_id';
422: l_sql_from := 'FROM hxc_time_building_blocks htbb';
423: l_sql_where := 'WHERE htbb.time_building_block_id IN (' || p_block_ids || ')'
424: || ' AND htbb.date_to = hr_general.end_of_time';
425:
426: if g_debug then

Line 547: po_vendors pv, po_headers_all pha, hxc_time_building_blocks detail,

543: );
544:
545: l_one_where := 'htbb.time_building_block_id in (select distinct hadl.APPLICATION_PERIOD_ID
546: from hxc_time_attributes hta, hxc_time_attribute_usages htau,
547: po_vendors pv, po_headers_all pha, hxc_time_building_blocks detail,
548: hxc_ap_detail_links hadl, po_lines_all pla
549: where hta.attribute_category ='||''''||l_context||''''
550: ||' and hta.'||l_segment
551: ||'= pla.po_line_id and pv.vendor_name '

Line 688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;

684: IS
685: -- l_approver_name per_all_people_f.full_name%TYPE;
686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';
687: l_item_key wf_item_activity_statuses.item_key%TYPE;
688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
690: l_approval_record approval_notification;
691: l_array_index NUMBER := 0;
692: l_match BOOLEAN;

Line 689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;

685: -- l_approver_name per_all_people_f.full_name%TYPE;
686: l_item_type wf_item_activity_statuses.item_type%TYPE := 'HXCEMP';
687: l_item_key wf_item_activity_statuses.item_key%TYPE;
688: l_app_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
689: l_app_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
690: l_approval_record approval_notification;
691: l_array_index NUMBER := 0;
692: l_match BOOLEAN;
693: l_resource_id NUMBER := -1;

Line 726: p_app_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE

722: AND fu.employee_id = p_approver_id
723: ORDER BY from_user desc;
724:
725: CURSOR c_approval_periods(
726: p_app_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE
727: ,p_app_bb_ovn IN hxc_time_building_blocks.object_version_number%TYPE
728: )
729: IS
730: SELECT /*+ leading(apsum) */

Line 727: ,p_app_bb_ovn IN hxc_time_building_blocks.object_version_number%TYPE

723: ORDER BY from_user desc;
724:
725: CURSOR c_approval_periods(
726: p_app_bb_id IN hxc_time_building_blocks.time_building_block_id%TYPE
727: ,p_app_bb_ovn IN hxc_time_building_blocks.object_version_number%TYPE
728: )
729: IS
730: SELECT /*+ leading(apsum) */
731: apsum.application_period_id

Line 747: ,hxc_time_building_blocks htbb

743: apsum.time_recipient_id
744: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
745: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
746: FROM hxc_app_period_summary apsum
747: ,hxc_time_building_blocks htbb
748: ,fnd_application_tl favtl
749: ,per_all_people_f ppf
750: ,hxc_time_recipients htr
751: ,hxc_tc_ap_links htal

Line 1028: p_approver_id hxc_time_building_blocks.time_building_block_id%TYPE

1024: ,p_adv_search IN VARCHAR2
1025: )
1026: IS
1027: CURSOR c_app_periods(
1028: p_approver_id hxc_time_building_blocks.time_building_block_id%TYPE
1029: )
1030: IS
1031: SELECT /*+ leading(apsum) */
1032: apsum.application_period_id

Line 1048: ,hxc_time_building_blocks htbb

1044: apsum.time_recipient_id
1045: ,nvl(ppf.employee_number,ppf.NPW_NUMBER)
1046: ,hxc_self_service_timecard.get_timecard_transferred_to(hts.timecard_id, hts.timecard_ovn)
1047: FROM hxc_app_period_summary apsum
1048: ,hxc_time_building_blocks htbb
1049: ,fnd_application_tl favtl
1050: ,per_all_people_f ppf
1051: ,hxc_time_recipients htr
1052: ,hxc_tc_ap_links htal