11: c_com_nres_info_elm constant varchar2(80) := 'COM_NRES_INFO';
12: c_non_res_date_iv constant varchar2(80) := 'NRES_START_DATE';
13: c_res_date_iv constant varchar2(80) := 'PROJECTED_RES_DATE';
14: --
15: c_com_ltx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ltx_info_elm,null,'JP');
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
12: c_non_res_date_iv constant varchar2(80) := 'NRES_START_DATE';
13: c_res_date_iv constant varchar2(80) := 'PROJECTED_RES_DATE';
14: --
15: c_com_ltx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ltx_info_elm,null,'JP');
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
13: c_res_date_iv constant varchar2(80) := 'PROJECTED_RES_DATE';
14: --
15: c_com_ltx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ltx_info_elm,null,'JP');
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
21: c_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_res_date_iv);
14: --
15: c_com_ltx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ltx_info_elm,null,'JP');
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
21: c_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_res_date_iv);
22: --
15: c_com_ltx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ltx_info_elm,null,'JP');
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
21: c_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_res_date_iv);
22: --
23: type t_file_rec is record(
16: c_com_itx_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_itx_info_elm,null,'JP');
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
21: c_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_res_date_iv);
22: --
23: type t_file_rec is record(
24: file_name varchar2(80),
17: c_itx_org_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_itx_org_iv);
18: c_non_res_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_itx_info_elm_id,c_non_res_iv);
19: c_com_nres_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_nres_info_elm,null,'JP');
20: c_non_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_non_res_date_iv);
21: c_res_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_nres_info_elm_id,c_res_date_iv);
22: --
23: type t_file_rec is record(
24: file_name varchar2(80),
25: file_out utl_file.file_type);