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.
PACKAGE: APPS.HXC_ABS_RETRIEVAL_PKG

Source


1 PACKAGE hxc_abs_retrieval_pkg AUTHID CURRENT_USER AS
2 /* $Header: hxcabsret.pkh 120.6.12020000.1 2012/06/28 05:03:48 appldev ship $ */
3 
4    g_retrieval_process_id        hxc_retrieval_processes.retrieval_process_id%TYPE;
5 
6    TYPE NUMTAB IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
7    TYPE VARCHARTAB IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;
8    TYPE DATETAB IS TABLE OF DATE INDEX BY PLS_INTEGER;
9 
10    TYPE t_absences IS TABLE OF hxc_abs_ret_temp%ROWTYPE INDEX BY BINARY_INTEGER;
11 
12    TYPE r_transactions IS RECORD (
13       time_building_block_id   hxc_abs_ret_temp.time_building_block_id%TYPE,
14       object_version_number          hxc_abs_ret_temp.object_version_number%TYPE
15    );
16 
17    TYPE t_transactions IS TABLE OF r_transactions
18       INDEX BY BINARY_INTEGER;
19 
20    TYPE r_absences_details IS RECORD (
21       absence_attendance_type_id   per_absence_attendances.absence_attendance_type_id%TYPE,
22       date_start                   per_absence_attendances.date_start%TYPE,
23       date_end                     per_absence_attendances.date_end%TYPE,
24       time_start                   per_absence_attendances.time_start%TYPE,
25       time_end                     per_absence_attendances.time_end%TYPE,
26       person_id                    per_absence_attendances.person_id%TYPE,
27       program_application_id       per_absence_attendances.program_application_id%TYPE
28    );
29 
30    TYPE t_absences_details IS TABLE OF r_absences_details
31       INDEX BY BINARY_INTEGER;
32 
33    TYPE r_edited_days IS RECORD (
34       day_start           hxc_abs_ret_temp.day_start%TYPE,
35       day_stop		  hxc_abs_ret_temp.day_stop%TYPE,
36       time_building_block_id   hxc_abs_ret_temp.time_building_block_id%TYPE,
37       object_version_number          hxc_abs_ret_temp.object_version_number%TYPE
38    );
39 
40    TYPE t_edited_days IS TABLE OF r_edited_days
41       INDEX BY BINARY_INTEGER;
42 
43    TYPE r_tk_ret_messages IS RECORD (
44        message_name	   fnd_new_messages.message_name%TYPE,
45        employee_name       per_all_people_f.full_name%TYPE
46    );
47 
48    TYPE t_tk_ret_messages IS TABLE OF r_tk_ret_messages
49       INDEX BY BINARY_INTEGER;
50 
51    g_tk_ret_messages             t_tk_ret_messages;
52 
53    TYPE r_cost_attributes IS RECORD (
54   	time_building_block_id		hxc_abs_ret_temp.time_building_block_id%TYPE,
55   	object_version_number		hxc_abs_ret_temp.object_version_number%TYPE,
56 	attribute1  			hxc_time_attributes.attribute1%TYPE,
57 	attribute2  			hxc_time_attributes.attribute1%TYPE,
58 	attribute3  			hxc_time_attributes.attribute1%TYPE,
59 	attribute4  			hxc_time_attributes.attribute1%TYPE,
60 	attribute5  			hxc_time_attributes.attribute1%TYPE,
61 	attribute6  			hxc_time_attributes.attribute1%TYPE,
62 	attribute7  			hxc_time_attributes.attribute1%TYPE,
63 	attribute8  			hxc_time_attributes.attribute1%TYPE,
64 	attribute9  			hxc_time_attributes.attribute1%TYPE,
65 	attribute10 			hxc_time_attributes.attribute1%TYPE,
66 	attribute11 			hxc_time_attributes.attribute1%TYPE,
67 	attribute12 			hxc_time_attributes.attribute1%TYPE,
68 	attribute13 			hxc_time_attributes.attribute1%TYPE,
69 	attribute14 			hxc_time_attributes.attribute1%TYPE,
70 	attribute15 			hxc_time_attributes.attribute1%TYPE,
71 	attribute16 			hxc_time_attributes.attribute1%TYPE,
72 	attribute17 			hxc_time_attributes.attribute1%TYPE,
73 	attribute18 			hxc_time_attributes.attribute1%TYPE,
74 	attribute19 			hxc_time_attributes.attribute1%TYPE,
75 	attribute20 			hxc_time_attributes.attribute1%TYPE,
76 	attribute21 			hxc_time_attributes.attribute1%TYPE,
77 	attribute22 			hxc_time_attributes.attribute1%TYPE,
78 	attribute23 			hxc_time_attributes.attribute1%TYPE,
79 	attribute24 			hxc_time_attributes.attribute1%TYPE,
80 	attribute25 			hxc_time_attributes.attribute1%TYPE,
81 	attribute26 			hxc_time_attributes.attribute1%TYPE,
82 	attribute27 			hxc_time_attributes.attribute1%TYPE,
83 	attribute28 			hxc_time_attributes.attribute1%TYPE,
84 	attribute29 			hxc_time_attributes.attribute1%TYPE,
85 	attribute30 			hxc_time_attributes.attribute1%TYPE,
86 	flex_value1  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
87 	flex_value2  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
88 	flex_value3  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
89 	flex_value4  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
90 	flex_value5  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
94 	flex_value9  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
91 	flex_value6  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
92 	flex_value7  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
93 	flex_value8  			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
95 	flex_value10 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
96 	flex_value11 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
97 	flex_value12 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
98 	flex_value13 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
99 	flex_value14 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
100 	flex_value15 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
101 	flex_value16 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
102 	flex_value17 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
103 	flex_value18 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
104 	flex_value19 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
105 	flex_value20 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
106 	flex_value21 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
107 	flex_value22 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
108 	flex_value23 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
109 	flex_value24 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
110 	flex_value25 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
111 	flex_value26 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
112 	flex_value27 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
113 	flex_value28 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
114 	flex_value29 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
115 	flex_value30 			FND_FLEX_VALUES_VL.FLEX_VALUE%TYPE,
116 	cost_allocation_keyflex_id      pay_cost_allocation_keyflex.cost_allocation_keyflex_id%TYPE
117     );
118 
119    TYPE t_cost_attributes IS TABLE OF r_cost_attributes
120       INDEX BY BINARY_INTEGER;
121 
122 
123    TYPE r_cost_struct IS RECORD	(
124           business_group_id       	NUMBER,
125 	  cost_allocation_structure	VARCHAR2(150)
126     );
127 
128    TYPE t_cost_struct IS TABLE OF r_cost_struct INDEX BY BINARY_INTEGER;
129    g_cost_struct  t_cost_struct;
130 
131    TYPE r_ret_rules IS RECORD	(
132           retrieval_rule_group_id       	NUMBER,
133 	  status				VARCHAR2(20)
134     );
135 
136    TYPE t_ret_rules IS TABLE OF r_ret_rules INDEX BY BINARY_INTEGER;
137    g_ret_rules  t_ret_rules;
138 
139 -- changed signature
140    PROCEDURE post_absences ( p_resource_id IN NUMBER,
141    			     p_tc_start    IN DATE,
142    			     p_tc_stop     IN DATE,
143    			     p_tc_status   IN VARCHAR2,
144    			     p_messages    IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
145    );
146 
147    PROCEDURE create_absences (
151 
148       p_absences   IN   hxc_abs_retrieval_pkg.t_absences,
149       p_uom        IN   VARCHAR2
150    );
152    PROCEDURE recreate_absences (
153       p_absences                    IN   hxc_abs_retrieval_pkg.t_absences_details,
154       p_uom                         IN     VARCHAR2,
155       p_old_absence_attendance_id   IN     NUMBER
156    );
157 
158    PROCEDURE delete_absences (
159       p_absence_attendance_id   IN   		NUMBER,
160       p_edited_days             IN   		hxc_abs_retrieval_pkg.t_edited_days,
161       p_uom                     IN   		VARCHAR2
162    );
163 
164    PROCEDURE create_transactions (
165       p_tbb_id         IN   hxc_abs_retrieval_pkg.NUMTAB,
166       p_tbb_ovn        IN   hxc_abs_retrieval_pkg.NUMTAB,
167       p_status         IN   VARCHAR2 DEFAULT NULL,
168       p_description    IN   VARCHAR2 DEFAULT NULL
169    );
170 
171    PROCEDURE update_cost_center (
172       p_absence_attendance_id   	IN   NUMBER,
173       p_cost_allocation_keyflex_id  	IN   NUMBER
174 
175    );
176 
177 
178    PROCEDURE insert_audit_header (
179       p_status      in            varchar2
180      ,p_description in            varchar2
181      ,p_transaction_id      out nocopy hxc_transactions.transaction_id%type
182    );
183 
184 
185    PROCEDURE insert_audit_details  (
186       p_tbb_id         IN   hxc_abs_retrieval_pkg.NUMTAB
187      ,p_tbb_ovn        IN   hxc_abs_retrieval_pkg.NUMTAB
188      ,p_status         IN   VARCHAR2 DEFAULT NULL
189      ,p_description    IN   VARCHAR2 DEFAULT NULL
190      ,p_transaction_id IN   hxc_transactions.transaction_id%type
191    );
192 
193 
194    PROCEDURE populate_cost_keyflex  (
195    	p_cost_attributes   IN OUT NOCOPY hxc_abs_retrieval_pkg.t_cost_attributes );
196 
197 
198    FUNCTION is_view_only ( p_absence_attendance_type_id NUMBER )
199    RETURN BOOLEAN;
200 
201 
202    PROCEDURE addTkError  ( p_token    VARCHAR2 );
203 
204    FUNCTION get_cost_alloc_struct ( p_business_group_id IN NUMBER)
205    RETURN VARCHAR2;
206 
210 END hxc_abs_retrieval_pkg;
207    FUNCTION get_retrieval_rule ( p_retrieval_rule_grp_id IN NUMBER)
208    RETURN VARCHAR2;
209 
211