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_ASSIGNMENT_LINK_USAGES_F

Line 271: delete from pay_assignment_link_usages_f

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;
274: end if;
275: -- reset the collections

Line 284: insert into pay_assignment_link_usages_f

280:
281: if l_count > 0 and l_upload_needed then
282:
283: forall i in 1..l_count
284: insert into pay_assignment_link_usages_f
285: (assignment_link_usage_id
286: ,effective_start_date
287: ,effective_end_date
288: ,element_link_id

Line 325: from pay_assignment_link_usages_f

321: v_end_date_tab := t_date_tab();
322: select assignment_id, effective_start_date, effective_end_date
323: bulk collect into
324: v_old_asg_id_tab, v_old_start_date_tab, v_old_end_date_tab
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);

Line 555: from pay_assignment_link_usages_f

551: --
552: v_session_date := p_validation_start_date -1;
553: --
554: delete
555: from pay_assignment_link_usages_f
556: where element_link_id = p_element_link_id
557: and effective_start_date >= p_validation_start_date;
558: --
559: if p_delete_mode = 'DELETE' then

Line 561: update pay_assignment_link_usages_f

557: and effective_start_date >= p_validation_start_date;
558: --
559: if p_delete_mode = 'DELETE' then
560: --
561: update pay_assignment_link_usages_f
562: set effective_end_date = v_session_date
563: where element_link_id = p_element_link_id
564: and v_session_date between effective_start_date
565: and effective_end_date;

Line 573: from pay_assignment_link_usages_f

569: --
570: if p_delete_mode in ('ZAP') then
571: --
572: delete
573: from pay_assignment_link_usages_f
574: where element_link_id = p_element_link_id;
575: --
576: end if;
577: --

Line 899: select 1 from pay_assignment_link_usages_f

895: --
896: cursor csr_alu_exists
897: (p_element_link_id in number)
898: is
899: select 1 from pay_assignment_link_usages_f
900: where assignment_id = p_assignment_id
901: and element_link_id = p_element_link_id;
902: --
903: l_proc varchar2(72) := g_package||'create_alu_asg_pg';

Line 1030: insert into pay_assignment_link_usages_f

1026: --
1027: -- Upload ALUs
1028: --
1029: forall i in 1..l_alu_start_date_tab.count
1030: insert into pay_assignment_link_usages_f
1031: (assignment_link_usage_id
1032: ,effective_start_date
1033: ,effective_end_date
1034: ,element_link_id

Line 1202: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type

1198: effective_end_date date,
1199: business_group_id number,
1200: element_link_id number);
1201: --
1202: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
1203: index by binary_integer;
1204: --
1205: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1206: index by binary_integer;

Line 1205: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type

1201: --
1202: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
1203: index by binary_integer;
1204: --
1205: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1206: index by binary_integer;
1207: --
1208: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
1209: index by binary_integer;

Line 1208: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type

1204: --
1205: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1206: index by binary_integer;
1207: --
1208: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
1209: index by binary_integer;
1210: --
1211: type t_alu_char_tab is table of varchar2(80);
1212: --

Line 1290: from pay_assignment_link_usages_f

1286: (
1287: p_assignment_id number)
1288: is
1289: select effective_start_date, effective_end_date, element_link_id
1290: from pay_assignment_link_usages_f
1291: where assignment_id = p_assignment_id
1292: order by 3,1;
1293: --
1294: -- local variables

Line 1409: delete from pay_assignment_link_usages_f alu

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
1413: forall i in 1..v_counter

Line 1415: insert into pay_assignment_link_usages_f

1411:
1412: -- Create the ALUs in bulk
1413: forall i in 1..v_counter
1414:
1415: insert into pay_assignment_link_usages_f
1416: (assignment_link_usage_id,
1417: effective_start_date,
1418: effective_end_date,
1419: element_link_id,