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;
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;
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
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;
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);
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;
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
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:
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);
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:
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