APPS.PAY_ASG_LINK_USAGES_PKG dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 158: insert into pay_assignment_link_usages_f

154:
155: if l_count > 0 then
156:
157: forall i in 1..l_count
158: insert into pay_assignment_link_usages_f
159: (assignment_link_usage_id
160: ,effective_start_date
161: ,effective_end_date
162: ,element_link_id

Line 377: from pay_assignment_link_usages_f

373: --
374: v_session_date := p_validation_start_date -1;
375: --
376: delete
377: from pay_assignment_link_usages_f
378: where element_link_id = p_element_link_id
379: and effective_start_date >= p_validation_start_date;
380: --
381: if p_delete_mode = 'DELETE' then

Line 383: update pay_assignment_link_usages_f

379: and effective_start_date >= p_validation_start_date;
380: --
381: if p_delete_mode = 'DELETE' then
382: --
383: update pay_assignment_link_usages_f
384: set effective_end_date = v_session_date
385: where element_link_id = p_element_link_id
386: and v_session_date between effective_start_date
387: and effective_end_date;

Line 394: from pay_assignment_link_usages_f

390: --
391: elsif p_delete_mode in ('ZAP', 'DELETE_NEXT_CHANGE') then
392: --
393: delete
394: from pay_assignment_link_usages_f
395: where element_link_id = p_element_link_id;
396: --
397: if p_delete_mode = 'DELETE_NEXT_CHANGE' then
398: --

Line 720: select 1 from pay_assignment_link_usages_f

716: --
717: cursor csr_alu_exists
718: (p_element_link_id in number)
719: is
720: select 1 from pay_assignment_link_usages_f
721: where assignment_id = p_assignment_id
722: and element_link_id = p_element_link_id;
723: --
724: l_proc varchar2(72) := g_package||'create_alu_asg_pg';

Line 851: insert into pay_assignment_link_usages_f

847: --
848: -- Upload ALUs
849: --
850: forall i in 1..l_alu_start_date_tab.count
851: insert into pay_assignment_link_usages_f
852: (assignment_link_usage_id
853: ,effective_start_date
854: ,effective_end_date
855: ,element_link_id

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

1020: business_group_id number,
1021: people_group_id number,
1022: id_flex_num number);
1023: --
1024: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
1025: index by binary_integer;
1026: --
1027: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1028: index by binary_integer;

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

1023: --
1024: type t_alu_start_date is table of pay_assignment_link_usages_f.effective_start_date%type
1025: index by binary_integer;
1026: --
1027: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1028: index by binary_integer;
1029: --
1030: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
1031: index by binary_integer;

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

1026: --
1027: type t_alu_end_date is table of pay_assignment_link_usages_f.effective_end_date%type
1028: index by binary_integer;
1029: --
1030: type t_alu_link_id is table of pay_assignment_link_usages_f.element_link_id%type
1031: index by binary_integer;
1032: --
1033: type t_alu_tab is record
1034: (start_date t_alu_start_date,

Line 1129: delete from pay_assignment_link_usages_f alu

1125: begin
1126: --
1127: -- Delete all the alus for the assignment
1128: --
1129: delete from pay_assignment_link_usages_f alu
1130: where alu.assignment_id = p_assignment_id;
1131: --
1132: --
1133: open csr_assignment(p_assignment_id);

Line 1240: insert into pay_assignment_link_usages_f

1236: --
1237: -- Create the ALUs in bulk
1238: --
1239: forall i in 1..v_counter
1240: insert into pay_assignment_link_usages_f
1241: (assignment_link_usage_id,
1242: effective_start_date,
1243: effective_end_date,
1244: element_link_id,