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.PAYPLNK dependencies on HR_ENTRY

Line 21: g_line_id_tbl hr_entry.number_table;

17: g_process_mode varchar2(50);
18: g_user_status pay_batch_headers.batch_status%TYPE;
19: g_count binary_integer := 0;
20: --
21: g_line_id_tbl hr_entry.number_table;
22: g_status_tbl hr_entry.varchar2_table;
23: g_message_tbl varchar2_table2;
24: --
25: g_control_count number :=0;

Line 22: g_status_tbl hr_entry.varchar2_table;

18: g_user_status pay_batch_headers.batch_status%TYPE;
19: g_count binary_integer := 0;
20: --
21: g_line_id_tbl hr_entry.number_table;
22: g_status_tbl hr_entry.varchar2_table;
23: g_message_tbl varchar2_table2;
24: --
25: g_control_count number :=0;
26: g_ctl_id_tbl hr_entry.number_table;

Line 26: g_ctl_id_tbl hr_entry.number_table;

22: g_status_tbl hr_entry.varchar2_table;
23: g_message_tbl varchar2_table2;
24: --
25: g_control_count number :=0;
26: g_ctl_id_tbl hr_entry.number_table;
27: g_ctl_stat_tbl hr_entry.varchar2_table;
28: g_ctl_mess_tbl varchar2_table2;
29: --
30: g_head_err_msg pay_message_lines.line_text%TYPE := null;

Line 27: g_ctl_stat_tbl hr_entry.varchar2_table;

23: g_message_tbl varchar2_table2;
24: --
25: g_control_count number :=0;
26: g_ctl_id_tbl hr_entry.number_table;
27: g_ctl_stat_tbl hr_entry.varchar2_table;
28: g_ctl_mess_tbl varchar2_table2;
29: --
30: g_head_err_msg pay_message_lines.line_text%TYPE := null;
31: g_head_err_stat varchar(1) := null;

Line 109: -- p_line_id_tbl in out hr_entry.number_table,

105: --This is now included within the package header.
106: -- procedure validate_lines
107: -- (
108: -- p_process_mode in varchar,
109: -- p_line_id_tbl in out hr_entry.number_table,
110: -- p_status_tbl in out hr_entry.varchar2_table,
111: -- p_message_tbl in out varchar2_table2,
112: -- p_batch_id in number,
113: -- p_business_group_id in number

Line 110: -- p_status_tbl in out hr_entry.varchar2_table,

106: -- procedure validate_lines
107: -- (
108: -- p_process_mode in varchar,
109: -- p_line_id_tbl in out hr_entry.number_table,
110: -- p_status_tbl in out hr_entry.varchar2_table,
111: -- p_message_tbl in out varchar2_table2,
112: -- p_batch_id in number,
113: -- p_business_group_id in number
114: -- p_leg_line_check in boolean

Line 131: p_passed_inp_tbl in hr_entry.number_table,

127: p_asg_act_id in number,
128: p_creator_type in varchar2,
129: p_absence_attendance_id in number,
130: p_entry_values_count in number,
131: p_passed_inp_tbl in hr_entry.number_table,
132: p_passed_val_tbl in hr_entry.varchar2_table
133: );
134: --
135: procedure update_element_entry

Line 132: p_passed_val_tbl in hr_entry.varchar2_table

128: p_creator_type in varchar2,
129: p_absence_attendance_id in number,
130: p_entry_values_count in number,
131: p_passed_inp_tbl in hr_entry.number_table,
132: p_passed_val_tbl in hr_entry.varchar2_table
133: );
134: --
135: procedure update_element_entry
136: (

Line 145: p_passed_inp_tbl in hr_entry.number_table,

141: p_allow_rollback in boolean,
142: p_asg_act_id in number,
143: l_line_record in csr_all_lines%ROWTYPE,
144: p_entry_values_count in number,
145: p_passed_inp_tbl in hr_entry.number_table,
146: p_passed_val_tbl in hr_entry.varchar2_table
147: );
148: --
149: -- -------------------------------------------------------------------------

Line 146: p_passed_val_tbl in hr_entry.varchar2_table

142: p_asg_act_id in number,
143: l_line_record in csr_all_lines%ROWTYPE,
144: p_entry_values_count in number,
145: p_passed_inp_tbl in hr_entry.number_table,
146: p_passed_val_tbl in hr_entry.varchar2_table
147: );
148: --
149: -- -------------------------------------------------------------------------
150: -- Procedure to convert input values from internal format to display format.

Line 405: l_line_id_tbl hr_entry.number_table;

401: --
402: l_error_count binary_integer :=0;
403: l_line_match boolean := false;
404: --
405: l_line_id_tbl hr_entry.number_table;
406: l_status_tbl hr_entry.varchar2_table;
407: l_message_tbl varchar2_table2;
408: --
409: sql_curs number;

Line 406: l_status_tbl hr_entry.varchar2_table;

402: l_error_count binary_integer :=0;
403: l_line_match boolean := false;
404: --
405: l_line_id_tbl hr_entry.number_table;
406: l_status_tbl hr_entry.varchar2_table;
407: l_message_tbl varchar2_table2;
408: --
409: sql_curs number;
410: rows_processed integer;

Line 2775: -- p_line_id_tbl in out hr_entry.number_table,

2771: procedure validate_lines (
2772: p_asg_id in number,
2773: p_asg_act_id in number,
2774: p_process_mode in varchar,
2775: -- p_line_id_tbl in out hr_entry.number_table,
2776: -- p_status_tbl in out hr_entry.varchar2_table,
2777: -- p_message_tbl in out varchar2_table2,
2778: p_batch_id in number,
2779: p_business_group_id in number

Line 2776: -- p_status_tbl in out hr_entry.varchar2_table,

2772: p_asg_id in number,
2773: p_asg_act_id in number,
2774: p_process_mode in varchar,
2775: -- p_line_id_tbl in out hr_entry.number_table,
2776: -- p_status_tbl in out hr_entry.varchar2_table,
2777: -- p_message_tbl in out varchar2_table2,
2778: p_batch_id in number,
2779: p_business_group_id in number
2780: --p_leg_line_check in boolean

Line 2858: l_passed_val_tbl hr_entry.varchar2_table;

2854: l binary_integer :=0;
2855: t binary_integer :=0;
2856: --
2857: l_entry_value_tbl varchar2_table80;
2858: l_passed_val_tbl hr_entry.varchar2_table;
2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;

Line 2859: l_passed_inp_tbl hr_entry.number_table;

2855: t binary_integer :=0;
2856: --
2857: l_entry_value_tbl varchar2_table80;
2858: l_passed_val_tbl hr_entry.varchar2_table;
2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;

Line 2860: l_inpv_uom_tbl hr_entry.varchar2_table;

2856: --
2857: l_entry_value_tbl varchar2_table80;
2858: l_passed_val_tbl hr_entry.varchar2_table;
2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;

Line 2861: l_abs_type_tbl hr_entry.number_table;

2857: l_entry_value_tbl varchar2_table80;
2858: l_passed_val_tbl hr_entry.varchar2_table;
2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;

Line 2862: l_abs_hod_tbl hr_entry.varchar2_table;

2858: l_passed_val_tbl hr_entry.varchar2_table;
2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;
2866: l_error_table per_absence_attendances_pkg3.t_message_table;

Line 2863: l_line_id_tbl hr_entry.number_table;

2859: l_passed_inp_tbl hr_entry.number_table;
2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;
2866: l_error_table per_absence_attendances_pkg3.t_message_table;
2867: l_warning_table per_absence_attendances_pkg3.t_message_table;

Line 2864: l_status_tbl hr_entry.varchar2_table;

2860: l_inpv_uom_tbl hr_entry.varchar2_table;
2861: l_abs_type_tbl hr_entry.number_table;
2862: l_abs_hod_tbl hr_entry.varchar2_table;
2863: l_line_id_tbl hr_entry.number_table;
2864: l_status_tbl hr_entry.varchar2_table;
2865: l_message_tbl varchar2_table2;
2866: l_error_table per_absence_attendances_pkg3.t_message_table;
2867: l_warning_table per_absence_attendances_pkg3.t_message_table;
2868: l_error_num number;

Line 3664: l_link_id := hr_entry_api.get_link(g_line_record.assignment_id,

3660: hr_utility.trace('EDT: '||g_line_record.effective_date);
3661: hr_utility.trace('LLI: '||l_link_id);
3662: hr_utility.trace('END');
3663: --
3664: l_link_id := hr_entry_api.get_link(g_line_record.assignment_id,
3665: g_line_record.element_type_id,
3666: g_line_record.effective_date);
3667: --
3668: hr_utility.set_location('payplnk.validate_lines',55);

Line 3835: hr_entry.maintain_cost_keyflex(

3831: --
3832: hr_utility.set_location('payplnk.validate_lines',60);
3833: --
3834: g_line_record.cost_allocation_keyflex_id :=
3835: hr_entry.maintain_cost_keyflex(
3836: l_cost_allocation_structure,
3837: -1,
3838: g_line_record.concatenated_segments,
3839: 'N',

Line 4864: p_passed_inp_tbl in hr_entry.number_table,

4860: p_asg_act_id in number,
4861: p_creator_type in varchar2,
4862: p_absence_attendance_id in number,
4863: p_entry_values_count in number,
4864: p_passed_inp_tbl in hr_entry.number_table,
4865: p_passed_val_tbl in hr_entry.varchar2_table
4866: ) is
4867: --
4868: l_effective_end_date date := null;

Line 4865: p_passed_val_tbl in hr_entry.varchar2_table

4861: p_creator_type in varchar2,
4862: p_absence_attendance_id in number,
4863: p_entry_values_count in number,
4864: p_passed_inp_tbl in hr_entry.number_table,
4865: p_passed_val_tbl in hr_entry.varchar2_table
4866: ) is
4867: --
4868: l_effective_end_date date := null;
4869: l_effective_start_date date := null;

Line 4873: c_passed_inp_tbl hr_entry.number_table;

4869: l_effective_start_date date := null;
4870: l_element_entry_id number := null;
4871: l_reason hr_lookups.lookup_code%TYPE := null;
4872: l_creator_id number;
4873: c_passed_inp_tbl hr_entry.number_table;
4874: c_passed_val_tbl hr_entry.varchar2_table;
4875: i binary_integer :=0;
4876: j number;
4877: --

Line 4874: c_passed_val_tbl hr_entry.varchar2_table;

4870: l_element_entry_id number := null;
4871: l_reason hr_lookups.lookup_code%TYPE := null;
4872: l_creator_id number;
4873: c_passed_inp_tbl hr_entry.number_table;
4874: c_passed_val_tbl hr_entry.varchar2_table;
4875: i binary_integer :=0;
4876: j number;
4877: --
4878: cursor csr_check_classification is

Line 4967: hr_entry_api.insert_element_entry(

4963: if (l_time_out) then
4964: savepoint INS_EE;
4965: end if;
4966: --
4967: hr_entry_api.insert_element_entry(
4968: p_effective_start_date => l_effective_start_date,
4969: p_effective_end_date => l_effective_end_date,
4970: p_element_entry_id => l_element_entry_id,
4971: p_assignment_id => l_line_record.assignment_id,

Line 5082: hr_entry_api.delete_element_entry(p_dt_delete_mode => 'DELETE',

5078: open csr_check_classification;
5079: fetch csr_check_classification into l_dummy_chk;
5080: if (csr_check_classification%found and l_line_record.effective_end_date is not null and l_element_entry_id is not null) then
5081: l_effective_end_date := l_line_record.effective_end_date;
5082: hr_entry_api.delete_element_entry(p_dt_delete_mode => 'DELETE',
5083: p_session_date => l_effective_end_date,
5084: p_element_entry_id =>l_element_entry_id);
5085: end if;
5086: close csr_check_classification;

Line 5118: p_passed_inp_tbl in hr_entry.number_table,

5114: p_allow_rollback in boolean,
5115: p_asg_act_id in number,
5116: l_line_record in csr_all_lines%ROWTYPE,
5117: p_entry_values_count in number,
5118: p_passed_inp_tbl in hr_entry.number_table,
5119: p_passed_val_tbl in hr_entry.varchar2_table
5120: ) is
5121: --
5122: l_reason hr_lookups.lookup_code%TYPE := null;

Line 5119: p_passed_val_tbl in hr_entry.varchar2_table

5115: p_asg_act_id in number,
5116: l_line_record in csr_all_lines%ROWTYPE,
5117: p_entry_values_count in number,
5118: p_passed_inp_tbl in hr_entry.number_table,
5119: p_passed_val_tbl in hr_entry.varchar2_table
5120: ) is
5121: --
5122: l_reason hr_lookups.lookup_code%TYPE := null;
5123: --

Line 5166: hr_entry_api.update_element_entry(

5162: if (l_time_out) then
5163: savepoint UPD_EE;
5164: end if;
5165: --
5166: hr_entry_api.update_element_entry(
5167: p_dt_update_mode => p_update_mode,
5168: p_session_date => l_line_record.effective_date,
5169: p_element_entry_id => p_element_entry_id,
5170: p_cost_allocation_keyflex_id =>