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 HR_UTILITY

Line 26: g_debug BOOLEAN := hr_utility.debug_enabled;

22: type cur_type is REF CURSOR;
23:
24: g_transaction_id NUMBER := NULL;
25: g_package VARCHAR2(100) := 'hxc_approval_utilities.';
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

Line 39: hr_utility.set_location(g_package||l_proc, 10);

35:
36: BEGIN
37: if g_debug then
38: l_proc := 'is_selected';
39: hr_utility.set_location(g_package||l_proc, 10);
40: end if;
41:
42: FOR l_index IN p_selected_ids.first .. p_selected_ids.last
43: LOOP

Line 69: hr_utility.set_location(g_package||l_proc, 10);

65:
66: BEGIN
67: if g_debug then
68: l_proc:= 'add_records';
69: hr_utility.set_location(g_package||l_proc, 10);
70: end if;
71: l_index := p_approval_array.count;
72:
73: p_approval_array.extend;

Line 91: hr_utility.set_location(g_package||l_proc, 10);

87:
88: BEGIN
89: if g_debug then
90: l_proc:= 'get_block_ids';
91: hr_utility.set_location(g_package||l_proc, 10);
92: end if;
93:
94: FOR l_block_index IN p_approval_array.first .. p_approval_array.last
95: LOOP

Line 408: hr_utility.set_location(g_package||l_proc, 10);

404:
405: BEGIN
406: if g_debug then
407: l_proc := 'adv_search';
408: hr_utility.set_location(g_package||l_proc, 10);
409: end if;
410: --Setting the MOAC params as part of R12 changes.
411: hxc_deposit_wrapper_utilities.string_to_table(
412: p_separator => '|'

Line 418: hr_utility.set_location(g_package||l_proc, 20);

414: ,p_table => l_adv_table
415: );
416:
417: if g_debug then
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';

Line 427: hr_utility.set_location(g_package||l_proc, 30);

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
427: hr_utility.set_location(g_package||l_proc, 30);
428: end if;
429: l_additional_where := NULL;
430:
431: l_adv_table_index := 0;

Line 437: hr_utility.set_location(g_package||l_proc, 40);

433: LOOP
434: EXIT WHEN NOT l_adv_table.exists(l_adv_table_index);
435:
436: if g_debug then
437: hr_utility.set_location(g_package||l_proc, 40);
438: end if;
439:
440: l_search_by := l_adv_table(l_adv_table_index);
441: l_search_operator := l_adv_table(l_adv_table_index + 1);

Line 458: hr_utility.set_location(g_package||l_proc, 50);

454: IF l_search_by = 'PERIOD_STARTS'
455: THEN
456:
457: if g_debug then
458: hr_utility.set_location(g_package||l_proc, 50);
459: end if;
460: l_one_where := 'TRUNC(htbb.start_time) '
461: || l_search_operator
462: || ' TO_DATE('

Line 471: hr_utility.set_location(g_package||l_proc, 60);

467:
468: ELSIF l_search_by = 'PERIOD_ENDS'
469: THEN
470: if g_debug then
471: hr_utility.set_location(g_package||l_proc, 60);
472: end if;
473: l_one_where := 'TRUNC(htbb.stop_time) '
474: || l_search_operator
475: || ' TO_DATE('

Line 484: hr_utility.set_location(g_package||l_proc, 70);

480:
481: ELSIF l_search_by = 'SUBMISSION_DATE'
482: THEN
483: if g_debug then
484: hr_utility.set_location(g_package||l_proc, 70);
485: end if;
486: l_one_where := 'TRUNC(htbb.creation_date) '
487: || l_search_operator
488: || ' TO_DATE('

Line 575: hr_utility.set_location(g_package||l_proc, 100);

571:
572: END IF;
573:
574: if g_debug then
575: hr_utility.set_location(g_package||l_proc, 100);
576: end if;
577: l_additional_where := l_additional_where
578: || ' '
579: || l_search_connector

Line 588: hr_utility.set_location(g_package||l_proc, 110);

584:
585: END LOOP;
586:
587: if g_debug then
588: hr_utility.set_location(g_package||l_proc, 110);
589: end if;
590:
591: IF l_additional_where IS NOT NULL
592: THEN

Line 594: hr_utility.set_location(g_package||l_proc, 120);

590:
591: IF l_additional_where IS NOT NULL
592: THEN
593: if g_debug then
594: hr_utility.set_location(g_package||l_proc, 120);
595: end if;
596: l_sql_where := l_sql_where
597: || ' AND ('
598: || l_additional_where

Line 603: hr_utility.set_location(g_package||l_proc, 130);

599: || ' )';
600: END IF;
601:
602: if g_debug then
603: hr_utility.set_location(g_package||l_proc, 130);
604: end if;
605: l_complete_sql := l_sql_select
606: || ' '
607: || l_sql_from

Line 611: hr_utility.set_location(g_package||l_proc, 140);

607: || l_sql_from
608: || ' '
609: || l_sql_where;
610: if g_debug then
611: hr_utility.set_location(g_package||l_proc, 140);
612: end if;
613: --execute query
614: l_selected_id_index := 0;
615:

Line 623: hr_utility.trace('selected id=' || p_selected_ids(l_selected_id_index));

619:
620: EXIT WHEN c_sql%NOTFOUND;
621:
622: if g_debug then
623: hr_utility.trace('selected id=' || p_selected_ids(l_selected_id_index));
624: end if;
625: l_selected_id_index := l_selected_id_index + 1;
626: END LOOP;
627:

Line 631: hr_utility.set_location(g_package||l_proc, 150);

627:
628: CLOSE c_sql;
629:
630: if g_debug then
631: hr_utility.set_location(g_package||l_proc, 150);
632: end if;
633: END adv_search;
634:
635: PROCEDURE release_locks

Line 770: hr_utility.set_location(g_package||l_proc, 10);

766:
767: BEGIN
768: if g_debug then
769: l_proc := 'get_approval_notifications';
770: hr_utility.set_location(g_package||l_proc, 10);
771: end if;
772: release_locks;
773:
774: SELECT HXC_TRANSACTION_LOCK_S.nextval

Line 782: hr_utility.set_location(g_package||l_proc, 20);

778: p_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
779: l_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
780:
781: if g_debug then
782: hr_utility.set_location(g_package||l_proc, 20);
783: end if;
784: OPEN c_notification_item_keys(
785: p_item_type => l_item_type
786: ,p_approver_id => p_approver_id

Line 815: hr_utility.set_location(g_package||l_proc, 30);

811: END IF;
812: END IF;
813:
814: if g_debug then
815: hr_utility.set_location(g_package||l_proc, 30);
816: end if;
817: IF l_match
818: THEN
819: IF p_from_date IS NOT NULL

Line 838: hr_utility.set_location(g_package||l_proc, 40);

834: END IF;
835: END IF;
836:
837: if g_debug then
838: hr_utility.set_location(g_package||l_proc, 40);
839: end if;
840: IF l_match
841: THEN
842: IF p_to_date IS NOT NULL

Line 861: hr_utility.set_location(g_package||l_proc, 50);

857: END IF;
858: END IF;
859:
860: if g_debug then
861: hr_utility.set_location(g_package||l_proc, 50);
862: end if;
863: IF l_match
864: THEN
865:

Line 881: hr_utility.set_location(g_package||l_proc, 60);

877: AND item_key = l_item_key
878: AND name = 'APP_BB_OVN';
879:
880: if g_debug then
881: hr_utility.set_location(g_package||l_proc, 60);
882: end if;
883: OPEN c_approval_periods(
884: p_app_bb_id => l_app_bb_id
885: ,p_app_bb_ovn => l_app_bb_ovn

Line 910: hr_utility.set_location(g_package||l_proc, 70);

906: IF l_success
907: THEN
908:
909: if g_debug then
910: hr_utility.set_location(g_package||l_proc, 70);
911: end if;
912: l_approval_array.extend;
913:
914: l_array_index := l_array_index + 1;

Line 946: hr_utility.set_location(g_package||l_proc, 80);

942:
943: CLOSE c_notification_item_keys;
944:
945: if g_debug then
946: hr_utility.set_location(g_package||l_proc, 80);
947: end if;
948:
949: IF l_approval_array.count = 0
950: THEN

Line 958: hr_utility.set_location(g_package||l_proc, 90);

954: --adv search
955: IF p_adv_search IS NOT NULL
956: THEN
957: if g_debug then
958: hr_utility.set_location(g_package||l_proc, 90);
959: end if;
960:
961: adv_search(
962: p_block_ids => get_block_ids(l_approval_array)

Line 968: hr_utility.set_location(g_package||l_proc, 100);

964: ,p_selected_ids => l_selected_ids
965: );
966:
967: if g_debug then
968: hr_utility.set_location(g_package||l_proc, 100);
969: end if;
970:
971: IF l_selected_ids.count > 0
972: THEN

Line 974: hr_utility.set_location(g_package||l_proc, 110);

970:
971: IF l_selected_ids.count > 0
972: THEN
973: if g_debug then
974: hr_utility.set_location(g_package||l_proc, 110);
975: end if;
976:
977: --populate p_approval_array and return
978: l_index := l_approval_array.first;

Line 995: hr_utility.set_location(g_package||l_proc, 120);

991:
992: END LOOP;
993:
994: if g_debug then
995: hr_utility.set_location(g_package||l_proc, 120);
996: end if;
997: END IF;
998:
999: ELSE

Line 1001: hr_utility.set_location(g_package||l_proc, 130);

997: END IF;
998:
999: ELSE
1000: if g_debug then
1001: hr_utility.set_location(g_package||l_proc, 130);
1002: end if;
1003: --simple search
1004: p_approval_array := l_approval_array;
1005:

Line 1007: hr_utility.set_location(g_package||l_proc, 140);

1003: --simple search
1004: p_approval_array := l_approval_array;
1005:
1006: if g_debug then
1007: hr_utility.set_location(g_package||l_proc, 140);
1008: end if;
1009: END IF;
1010:
1011: if g_debug then

Line 1012: hr_utility.set_location(g_package||l_proc, 150);

1008: end if;
1009: END IF;
1010:
1011: if g_debug then
1012: hr_utility.set_location(g_package||l_proc, 150);
1013: end if;
1014:
1015:
1016: END get_open_notifications;

Line 1091: hr_utility.set_location(g_package||l_proc, 70);

1087: EXIT WHEN c_app_periods%NOTFOUND;
1088:
1089: if g_debug then
1090: l_proc := 'get_approval_history';
1091: hr_utility.set_location(g_package||l_proc, 70);
1092: end if;
1093:
1094: l_approval_array.extend;
1095:

Line 1132: hr_utility.set_location(g_package||l_proc, 90);

1128: --adv search
1129: IF p_adv_search IS NOT NULL
1130: THEN
1131: if g_debug then
1132: hr_utility.set_location(g_package||l_proc, 90);
1133: end if;
1134: adv_search(
1135: p_block_ids => get_block_ids(l_approval_array)
1136: ,p_adv_search => p_adv_search

Line 1141: hr_utility.set_location(g_package||l_proc, 100);

1137: ,p_selected_ids => l_selected_ids
1138: );
1139:
1140: if g_debug then
1141: hr_utility.set_location(g_package||l_proc, 100);
1142: end if;
1143:
1144: IF l_selected_ids.count > 0
1145: THEN

Line 1147: hr_utility.set_location(g_package||l_proc, 110);

1143:
1144: IF l_selected_ids.count > 0
1145: THEN
1146: if g_debug then
1147: hr_utility.set_location(g_package||l_proc, 110);
1148: end if;
1149:
1150: --populate p_approval_array and return
1151: l_index := l_approval_array.first;

Line 1168: hr_utility.set_location(g_package||l_proc, 120);

1164:
1165: END LOOP;
1166:
1167: if g_debug then
1168: hr_utility.set_location(g_package||l_proc, 120);
1169: end if;
1170: END IF;
1171:
1172: ELSE

Line 1174: hr_utility.set_location(g_package||l_proc, 130);

1170: END IF;
1171:
1172: ELSE
1173: if g_debug then
1174: hr_utility.set_location(g_package||l_proc, 130);
1175: end if;
1176: --simple search
1177: p_approval_array := l_approval_array;
1178:

Line 1180: hr_utility.set_location(g_package||l_proc, 140);

1176: --simple search
1177: p_approval_array := l_approval_array;
1178:
1179: if g_debug then
1180: hr_utility.set_location(g_package||l_proc, 140);
1181: end if;
1182: END IF;
1183:
1184: if g_debug then

Line 1185: hr_utility.set_location(g_package||l_proc, 150);

1181: end if;
1182: END IF;
1183:
1184: if g_debug then
1185: hr_utility.set_location(g_package||l_proc, 150);
1186: end if;
1187: END get_approval_history;
1188:
1189: PROCEDURE get_approval_notifications(