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 PAY_ASG_LINK_USAGES_PKG

Line 1: package body PAY_ASG_LINK_USAGES_PKG as

1: package body PAY_ASG_LINK_USAGES_PKG as
2: /* $Header: pyalu.pkb 120.9.12020000.6 2012/07/06 11:35:16 vmaripal ship $ */
3: --------------------------------------------------------------------------------
4: --
5: -- Declare global variables

Line 28: g_package constant varchar2 (32) := 'pay_asg_link_usages_pkg.';

24: g_alu_asg_hist t_asg_grp_hist_tab; -- Asg people group history
25: g_alu_link_pg_id number; -- Link People Group ID
26: g_alu_asg_pg_hist t_asg_grp_hist_tab; -- Asg eligibility history
27: --
28: g_package constant varchar2 (32) := 'pay_asg_link_usages_pkg.';
29:
30: --------------------------------------------------------------------------------
31: --
32: procedure INSERT_ALU (

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 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 262: ('PAY_ASG_LINK_USAGES_PKG.upload_alus. no upload needed',20);

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:
266: else

Line 269: ('PAY_ASG_LINK_USAGES_PKG.upload_alus. upload needed. newcount'||v_asg_id_tab.count,30);

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;
273: l_upload_needed := TRUE;

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 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 1444: end PAY_ASG_LINK_USAGES_PKG;

1440: end rebuild_alus;
1441: --
1442: --------------------------------------------------------------------------------
1443: --
1444: end PAY_ASG_LINK_USAGES_PKG;