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_NOTIFICATION_TABLE_TYPE

Line 58: p_approval_array IN OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE

54:
55:
56:
57: PROCEDURE add_records(
58: p_approval_array IN OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE
59: ,p_record IN HXC_NOTIFICATION_TYPE
60: )
61: IS
62: l_index NUMBER;

Line 80: p_approval_array IN HXC_NOTIFICATION_TABLE_TYPE

76:
77: END add_records;
78:
79: FUNCTION get_block_ids(
80: p_approval_array IN HXC_NOTIFICATION_TABLE_TYPE
81: )
82: RETURN VARCHAR2
83: IS
84: l_block_ids VARCHAR2(32767) := null;

Line 678: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE

674: END get_name;
675:
676: PROCEDURE get_open_notifications(
677: p_approver_id IN NUMBER
678: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE
679: ,p_resource_id IN VARCHAR2
680: ,p_from_date IN VARCHAR2
681: ,p_to_date IN VARCHAR2
682: ,p_adv_search IN VARCHAR2

Line 696: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;

692: l_match BOOLEAN;
693: l_resource_id NUMBER := -1;
694: l_start_date DATE;
695: l_end_date DATE;
696: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;
697: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;
698: l_index NUMBER;
699:
700: l_messages HXC_MESSAGE_TABLE_TYPE;

Line 778: p_approval_array := HXC_NOTIFICATION_TABLE_TYPE();

774: SELECT HXC_TRANSACTION_LOCK_S.nextval
775: INTO g_transaction_id
776: FROM DUAL;
777:
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);

Line 779: l_approval_array := HXC_NOTIFICATION_TABLE_TYPE();

775: INTO g_transaction_id
776: FROM DUAL;
777:
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;

Line 1020: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE

1016: END get_open_notifications;
1017:
1018: PROCEDURE get_approval_history(
1019: p_approver_id IN NUMBER
1020: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE
1021: ,p_resource_id IN VARCHAR2
1022: ,p_from_date IN VARCHAR2
1023: ,p_to_date IN VARCHAR2
1024: ,p_adv_search IN VARCHAR2

Line 1072: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;

1068: AND NVL(p_to_date, TO_CHAR(apsum.start_time, 'YYYY/MM/DD')) >= TO_CHAR(apsum.start_time, 'YYYY/MM/DD')
1069: ORDER BY ppf.full_name desc, apsum.start_time desc;
1070:
1071: l_approval_record approval_notification;
1072: l_approval_array HXC_NOTIFICATION_TABLE_TYPE;
1073: l_array_index NUMBER := 0;
1074: l_selected_ids hxc_deposit_wrapper_utilities.t_simple_table;
1075: l_index NUMBER;
1076:

Line 1079: p_approval_array := HXC_NOTIFICATION_TABLE_TYPE();

1075: l_index NUMBER;
1076:
1077: l_proc VARCHAR2(500);
1078: BEGIN
1079: p_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
1080: l_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
1081:
1082:
1083: OPEN c_app_periods(p_approver_id);

Line 1080: l_approval_array := HXC_NOTIFICATION_TABLE_TYPE();

1076:
1077: l_proc VARCHAR2(500);
1078: BEGIN
1079: p_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
1080: l_approval_array := HXC_NOTIFICATION_TABLE_TYPE();
1081:
1082:
1083: OPEN c_app_periods(p_approver_id);
1084:

Line 1191: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE

1187: END get_approval_history;
1188:
1189: PROCEDURE get_approval_notifications(
1190: p_approver_id IN NUMBER
1191: ,p_approval_array OUT NOCOPY HXC_NOTIFICATION_TABLE_TYPE
1192: ,p_resource_id IN VARCHAR2
1193: ,p_from_date IN VARCHAR2
1194: ,p_to_date IN VARCHAR2
1195: ,p_adv_search IN VARCHAR2