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 104: -- p_line_id_tbl in out hr_entry.number_table,

100: --This is now included within the package header.
101: -- procedure validate_lines
102: -- (
103: -- p_process_mode in varchar,
104: -- p_line_id_tbl in out hr_entry.number_table,
105: -- p_status_tbl in out hr_entry.varchar2_table,
106: -- p_message_tbl in out varchar2_table2,
107: -- p_batch_id in number,
108: -- p_business_group_id in number

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

101: -- procedure validate_lines
102: -- (
103: -- p_process_mode in varchar,
104: -- p_line_id_tbl in out hr_entry.number_table,
105: -- p_status_tbl in out hr_entry.varchar2_table,
106: -- p_message_tbl in out varchar2_table2,
107: -- p_batch_id in number,
108: -- p_business_group_id in number
109: -- p_leg_line_check in boolean

Line 126: p_passed_inp_tbl in hr_entry.number_table,

122: p_asg_act_id in number,
123: p_creator_type in varchar2,
124: p_absence_attendance_id in number,
125: p_entry_values_count in number,
126: p_passed_inp_tbl in hr_entry.number_table,
127: p_passed_val_tbl in hr_entry.varchar2_table
128: );
129: --
130: procedure update_element_entry

Line 127: p_passed_val_tbl in hr_entry.varchar2_table

123: p_creator_type in varchar2,
124: p_absence_attendance_id in number,
125: p_entry_values_count in number,
126: p_passed_inp_tbl in hr_entry.number_table,
127: p_passed_val_tbl in hr_entry.varchar2_table
128: );
129: --
130: procedure update_element_entry
131: (

Line 140: p_passed_inp_tbl in hr_entry.number_table,

136: p_allow_rollback in boolean,
137: p_asg_act_id in number,
138: l_line_record in csr_all_lines%ROWTYPE,
139: p_entry_values_count in number,
140: p_passed_inp_tbl in hr_entry.number_table,
141: p_passed_val_tbl in hr_entry.varchar2_table
142: );
143: --
144: -- -------------------------------------------------------------------------

Line 141: p_passed_val_tbl in hr_entry.varchar2_table

137: p_asg_act_id in number,
138: l_line_record in csr_all_lines%ROWTYPE,
139: p_entry_values_count in number,
140: p_passed_inp_tbl in hr_entry.number_table,
141: p_passed_val_tbl in hr_entry.varchar2_table
142: );
143: --
144: -- -------------------------------------------------------------------------
145: -- Procedure to convert input values from internal format to display format.

Line 407: l_line_id_tbl hr_entry.number_table;

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

Line 408: l_status_tbl hr_entry.varchar2_table;

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

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

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

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

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

Line 2861: l_passed_val_tbl hr_entry.varchar2_table;

2857: t binary_integer :=0;
2858: --
2859: --l_entry_value_tbl varchar2_table80; for bug9350651
2860: l_entry_value_tbl varchar2_table2;
2861: l_passed_val_tbl hr_entry.varchar2_table;
2862: --l_passed_val_tbl varchar2_table2;
2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;

Line 2863: l_passed_inp_tbl hr_entry.number_table;

2859: --l_entry_value_tbl varchar2_table80; for bug9350651
2860: l_entry_value_tbl varchar2_table2;
2861: l_passed_val_tbl hr_entry.varchar2_table;
2862: --l_passed_val_tbl varchar2_table2;
2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;

Line 2864: l_inpv_uom_tbl hr_entry.varchar2_table;

2860: l_entry_value_tbl varchar2_table2;
2861: l_passed_val_tbl hr_entry.varchar2_table;
2862: --l_passed_val_tbl varchar2_table2;
2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;

Line 2865: l_abs_type_tbl hr_entry.number_table;

2861: l_passed_val_tbl hr_entry.varchar2_table;
2862: --l_passed_val_tbl varchar2_table2;
2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;

Line 2866: l_abs_hod_tbl hr_entry.varchar2_table;

2862: --l_passed_val_tbl varchar2_table2;
2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;
2870: l_error_table per_absence_attendances_pkg3.t_message_table;

Line 2867: l_line_id_tbl hr_entry.number_table;

2863: l_passed_inp_tbl hr_entry.number_table;
2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;
2870: l_error_table per_absence_attendances_pkg3.t_message_table;
2871: l_warning_table per_absence_attendances_pkg3.t_message_table;

Line 2868: l_status_tbl hr_entry.varchar2_table;

2864: l_inpv_uom_tbl hr_entry.varchar2_table;
2865: l_abs_type_tbl hr_entry.number_table;
2866: l_abs_hod_tbl hr_entry.varchar2_table;
2867: l_line_id_tbl hr_entry.number_table;
2868: l_status_tbl hr_entry.varchar2_table;
2869: l_message_tbl varchar2_table2;
2870: l_error_table per_absence_attendances_pkg3.t_message_table;
2871: l_warning_table per_absence_attendances_pkg3.t_message_table;
2872: l_error_num number;

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

3678: hr_utility.trace('EDT: '||g_line_record.effective_date);
3679: hr_utility.trace('LLI: '||l_link_id);
3680: hr_utility.trace('END');
3681: --
3682: l_link_id := hr_entry_api.get_link(g_line_record.assignment_id,
3683: g_line_record.element_type_id,
3684: g_line_record.effective_date);
3685: --
3686: hr_utility.set_location('payplnk.validate_lines',55);

Line 3853: hr_entry.maintain_cost_keyflex(

3849: --
3850: hr_utility.set_location('payplnk.validate_lines',60);
3851: --
3852: g_line_record.cost_allocation_keyflex_id :=
3853: hr_entry.maintain_cost_keyflex(
3854: l_cost_allocation_structure,
3855: -1,
3856: g_line_record.concatenated_segments,
3857: 'N',

Line 4896: p_passed_inp_tbl in hr_entry.number_table,

4892: p_asg_act_id in number,
4893: p_creator_type in varchar2,
4894: p_absence_attendance_id in number,
4895: p_entry_values_count in number,
4896: p_passed_inp_tbl in hr_entry.number_table,
4897: p_passed_val_tbl in hr_entry.varchar2_table
4898: ) is
4899: --
4900: l_effective_end_date date := null;

Line 4897: p_passed_val_tbl in hr_entry.varchar2_table

4893: p_creator_type in varchar2,
4894: p_absence_attendance_id in number,
4895: p_entry_values_count in number,
4896: p_passed_inp_tbl in hr_entry.number_table,
4897: p_passed_val_tbl in hr_entry.varchar2_table
4898: ) is
4899: --
4900: l_effective_end_date date := null;
4901: l_effective_start_date date := null;

Line 4905: c_passed_inp_tbl hr_entry.number_table;

4901: l_effective_start_date date := null;
4902: l_element_entry_id number := null;
4903: l_reason hr_lookups.lookup_code%TYPE := null;
4904: l_creator_id number;
4905: c_passed_inp_tbl hr_entry.number_table;
4906: c_passed_val_tbl hr_entry.varchar2_table;
4907: i binary_integer :=0;
4908: j number;
4909: --

Line 4906: c_passed_val_tbl hr_entry.varchar2_table;

4902: l_element_entry_id number := null;
4903: l_reason hr_lookups.lookup_code%TYPE := null;
4904: l_creator_id number;
4905: c_passed_inp_tbl hr_entry.number_table;
4906: c_passed_val_tbl hr_entry.varchar2_table;
4907: i binary_integer :=0;
4908: j number;
4909: --
4910: cursor csr_check_classification is

Line 4999: hr_entry_api.insert_element_entry(

4995: if (l_time_out) then
4996: savepoint INS_EE;
4997: end if;
4998: --
4999: hr_entry_api.insert_element_entry(
5000: p_effective_start_date => l_effective_start_date,
5001: p_effective_end_date => l_effective_end_date,
5002: p_element_entry_id => l_element_entry_id,
5003: p_assignment_id => l_line_record.assignment_id,

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

5110: open csr_check_classification;
5111: fetch csr_check_classification into l_dummy_chk;
5112: if (csr_check_classification%found and l_line_record.effective_end_date is not null and l_element_entry_id is not null) then
5113: l_effective_end_date := l_line_record.effective_end_date;
5114: hr_entry_api.delete_element_entry(p_dt_delete_mode => 'DELETE',
5115: p_session_date => l_effective_end_date,
5116: p_element_entry_id =>l_element_entry_id);
5117: end if;
5118: close csr_check_classification;

Line 5150: p_passed_inp_tbl in hr_entry.number_table,

5146: p_allow_rollback in boolean,
5147: p_asg_act_id in number,
5148: l_line_record in csr_all_lines%ROWTYPE,
5149: p_entry_values_count in number,
5150: p_passed_inp_tbl in hr_entry.number_table,
5151: p_passed_val_tbl in hr_entry.varchar2_table
5152: ) is
5153: --
5154: l_reason hr_lookups.lookup_code%TYPE := null;

Line 5151: p_passed_val_tbl in hr_entry.varchar2_table

5147: p_asg_act_id in number,
5148: l_line_record in csr_all_lines%ROWTYPE,
5149: p_entry_values_count in number,
5150: p_passed_inp_tbl in hr_entry.number_table,
5151: p_passed_val_tbl in hr_entry.varchar2_table
5152: ) is
5153: --
5154: l_reason hr_lookups.lookup_code%TYPE := null;
5155: --

Line 5198: hr_entry_api.update_element_entry(

5194: if (l_time_out) then
5195: savepoint UPD_EE;
5196: end if;
5197: --
5198: hr_entry_api.update_element_entry(
5199: p_dt_update_mode => p_update_mode,
5200: p_session_date => l_line_record.effective_date,
5201: p_element_entry_id => p_element_entry_id,
5202: p_cost_allocation_keyflex_id =>