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.PAY_ASG_LINK_USAGES_PKG dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --------------------------------------------------------------------------------
4: --
5: -- Declare global variables
6: --
7: g_debug boolean := hr_utility.debug_enabled;
8: type t_num_tab is table of number
9: index by binary_integer;
10: type t_date_tab is table of date
11: index by binary_integer;

Line 195: hr_utility.set_location('entering PAY_ASG_LINK_USAGES_PKG.SET_ALU ',10);

191: v_unwanted_out_parameter,
192: false);
193: --
194: if g_debug then
195: hr_utility.set_location('entering PAY_ASG_LINK_USAGES_PKG.SET_ALU ',10);
196: end if;
197: l_alu_end := least(p_effective_end_date,
198: v_previous_end_date,
199: v_termination_date);

Line 207: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.SET_ALU. Initialize v_asg_id_tab',20);

203: v_previous_end_date);
204:
205: if l_init_collection then
206: if g_debug then
207: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.SET_ALU. Initialize v_asg_id_tab',20);
208: end if;
209: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);
210: v_asg_id_tab := t_num_tab();
211: v_start_date_tab := t_date_tab();

Line 209: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);

205: if l_init_collection then
206: if g_debug then
207: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.SET_ALU. Initialize v_asg_id_tab',20);
208: end if;
209: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);
210: v_asg_id_tab := t_num_tab();
211: v_start_date_tab := t_date_tab();
212: v_end_date_tab := t_date_tab();
213: l_init_collection := FALSE;

Line 226: hr_utility.trace('set ALU('||l_idx||'). v_asg_id:'||v_previous_assignment_id||

222: v_end_date_tab.EXTEND;
223: --
224: -- Set the ALU data to table variables.
225: if g_debug then
226: hr_utility.trace('set ALU('||l_idx||'). v_asg_id:'||v_previous_assignment_id||
227: ' '||l_alu_start||' '||l_alu_end);
228: end if;
229: --
230: v_asg_id_tab(l_idx) := v_previous_assignment_id;

Line 236: hr_utility.set_location('leaving PAY_ASG_LINK_USAGES_PKG.SET_ALU ',90);

232: v_end_date_tab(l_idx) := l_alu_end;
233:
234: end if;
235: if g_debug then
236: hr_utility.set_location('leaving PAY_ASG_LINK_USAGES_PKG.SET_ALU ',90);
237: end if;
238: --
239: end set_ALU;
240: --end create_ALU;

Line 250: hr_utility.set_location('entering PAY_ASG_LINK_USAGES_PKG.upload_alus. ',10);

246: is
247: l_count number;
248: begin
249: if g_debug then
250: hr_utility.set_location('entering PAY_ASG_LINK_USAGES_PKG.upload_alus. ',10);
251: end if;
252: l_count := v_asg_id_tab.count;
253: l_upload_needed := TRUE;
254:

Line 261: hr_utility.set_location

257: if (v_asg_id_tab = v_old_asg_id_tab) and
258: (v_start_date_tab = v_old_start_date_tab) and
259: (v_end_date_tab = v_old_end_date_tab) then
260: if g_debug then
261: hr_utility.set_location
262: ('PAY_ASG_LINK_USAGES_PKG.upload_alus. no upload needed',20);
263: end if;
264: l_upload_needed := FALSE;
265:

Line 268: hr_utility.set_location

264: l_upload_needed := FALSE;
265:
266: else
267: if g_debug then
268: hr_utility.set_location
269: ('PAY_ASG_LINK_USAGES_PKG.upload_alus. upload needed. newcount'||v_asg_id_tab.count,30);
270: end if;
271: delete from pay_assignment_link_usages_f
272: where element_link_id = p_element_link_id;

Line 306: hr_utility.set_location('leaving PAY_ASG_LINK_USAGES_PKG.upload_alus. ',90);

302: v_end_date_tab.delete;
303:
304: end if;
305: if g_debug then
306: hr_utility.set_location('leaving PAY_ASG_LINK_USAGES_PKG.upload_alus. ',90);
307: end if;
308:
309: end upload_alus;
310: --

Line 315: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU',10);

311: --
312: begin
313: --
314: if g_debug then
315: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU',10);
316: end if;
317: -- build collections for existing alus for this link
318: l_init_collection := TRUE;
319: v_asg_id_tab := t_num_tab();

Line 329: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. old_alu_count:'||v_old_asg_id_tab.count,20);

325: from pay_assignment_link_usages_f
326: where element_link_id = p_element_link_id
327: order by 1,2;
328: if g_debug then
329: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. old_alu_count:'||v_old_asg_id_tab.count,20);
330: end if;
331:
332: -- Cycle through qualifying assignments. Create an ALU when the last end date
333: -- of a continuous set of date-effective rows for an assignment is found.

Line 456: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);

452: dbms_sql.column_value(sql_curs,2,l_effective_start_date);
453: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
454: --
455: if g_debug then
456: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);
457: hr_utility.trace('l_assignment_id:'||l_assignment_id||
458: ' l_effective_start_date:'||l_effective_start_date||
459: ' l_effective_end_date:'||l_effective_end_date);
460: end if;

Line 457: hr_utility.trace('l_assignment_id:'||l_assignment_id||

453: dbms_sql.column_value(sql_curs,3,l_effective_end_date);
454: --
455: if g_debug then
456: hr_utility.set_location('PAY_ASG_LINK_USAGES_PKG.INSERT_ALU. row_count:'||row_count,50);
457: hr_utility.trace('l_assignment_id:'||l_assignment_id||
458: ' l_effective_start_date:'||l_effective_start_date||
459: ' l_effective_end_date:'||l_effective_end_date);
460: end if;
461: --

Line 934: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

930: when hr_api.object_locked then
931: --
932: -- Failed to lock the assignment.
933: --
934: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
935: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
936: hr_utility.raise_error;
937: end lock_asg;
938: --

Line 935: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');

931: --
932: -- Failed to lock the assignment.
933: --
934: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
935: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
936: hr_utility.raise_error;
937: end lock_asg;
938: --
939: begin

Line 936: hr_utility.raise_error;

932: -- Failed to lock the assignment.
933: --
934: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
935: hr_utility.set_message_token('TABLE_NAME', 'per_all_assignments_f');
936: hr_utility.raise_error;
937: end lock_asg;
938: --
939: begin
940:

Line 941: hr_utility.set_location('Entering: '||l_proc, 5);

937: end lock_asg;
938: --
939: begin
940:
941: hr_utility.set_location('Entering: '||l_proc, 5);
942: --
943: -- Check the eligibility of the people group and
944: -- also establish the necessary cache.
945: --

Line 956: hr_utility.set_location(l_proc, 10);

952: -- Construct the date tables for ALU
953: --
954: if l_eligible_pg_exists then
955:
956: hr_utility.set_location(l_proc, 10);
957:
958: l_asg_locked := false;
959: --
960: -- Setup the ALU table data

Line 1046: hr_utility.set_location('Leaving: '||l_proc, 100);

1042: );
1043: --
1044: end if;
1045: --
1046: hr_utility.set_location('Leaving: '||l_proc, 100);
1047: --
1048: end create_alu_asg_pg;
1049: --
1050: --------------------------------------------------------------------------------

Line 1088: hr_utility.set_location('Entering: '||l_proc, 5);

1084: l_link_idx number;
1085: --
1086: begin
1087: --
1088: hr_utility.set_location('Entering: '||l_proc, 5);
1089: --
1090: -- Check to see if the specified table variable contains
1091: -- any element link data.
1092: --

Line 1097: hr_utility.set_location(l_proc, 10);

1093: if p_pg_link_tab.count = 0 then
1094: --
1095: -- No element link was specified, hence exit this procedure.
1096: --
1097: hr_utility.set_location(l_proc, 10);
1098: return;
1099: end if;
1100:
1101: --

Line 1114: hr_utility.set_location(l_proc, 20);

1110: --
1111: -- No people group is associated with this assignment,
1112: -- hence exit this procedure.
1113: --
1114: hr_utility.set_location(l_proc, 20);
1115: return;
1116: end if;
1117:
1118: --

Line 1177: hr_utility.set_location('Leaving: '||l_proc, 100);

1173: end if;
1174: --
1175: end loop;
1176: --
1177: hr_utility.set_location('Leaving: '||l_proc, 100);
1178: --
1179: end create_alu_asg;
1180: --
1181: --------------------------------------------------------------------------------

Line 1403: hr_utility.trace('PAY_ASG_LINK_USAGES_PKG.rebuild_alus compare new/old counts '||

1399: close csr_asg_pglink;
1400:
1401: -- Create the ALUs in bulk
1402: if g_debug then
1403: hr_utility.trace('PAY_ASG_LINK_USAGES_PKG.rebuild_alus compare new/old counts '||
1404: v_alu_char_tab.count||'/'||v_old_alu_char_tab.count);
1405: end if;
1406: --
1407: if v_alu_char_tab <> v_old_alu_char_tab then --{ start rebuild needed

Line 1408: hr_utility.trace('Rebuild_alus rebuild needed');

1404: v_alu_char_tab.count||'/'||v_old_alu_char_tab.count);
1405: end if;
1406: --
1407: if v_alu_char_tab <> v_old_alu_char_tab then --{ start rebuild needed
1408: hr_utility.trace('Rebuild_alus rebuild needed');
1409: delete from pay_assignment_link_usages_f alu
1410: where alu.assignment_id = p_assignment_id;
1411:
1412: -- Create the ALUs in bulk