[Home] [Help]
306: -- Added function get_employee_status,procedures create_entries and create_entry_for_assignment
307: -- to enhance the function of PAYKRSEP.fmb.
308: -- Added a pl/sql table to hold assignment_id's.
309: -------------------------------------------------------------------------------------------------------------+
310: type assignment_id_tbl is table of pay_assignment_actions.assignment_id%type index by binary_integer;
311: g_assignment_id_tbl assignment_id_tbl;
312: -------------------------------------------------------------------------------------------------------------+
313: procedure create_entries(
314: p_assignment_id_tbl in g_assignment_id_tbl%type,
325: p_payroll_id in hr_assignment_sets.payroll_id%type,
326: p_session_date in date);
327: -------------------------------------------------------------------------------------------------------------+
328: procedure create_entry_for_assignment(
329: p_assignment_id in pay_assignment_actions.assignment_id%type,
330: p_element_type_id in pay_element_types.element_type_id%type,
331: p_business_group_id in pay_element_types.business_group_id%type,
332: p_entry_type in pay_element_entries_f.entry_type%type,
333: p_effective_date in date,
336: p_element_entry_id out NOCOPY pay_element_entries_f.element_entry_id%type,
337: p_object_version_number out NOCOPY number);
338: -------------------------------------------------------------------------------------------------------------+
339: function get_employee_status(
340: p_assignment_id in pay_assignment_actions.assignment_id%type,
341: p_run_type_name in pay_run_types.run_type_name%type,
342: p_date_earned in date) return varchar2;
343: -------------------------------------------------------------------------------------------------------------+
344: -- Bug# 2425705