DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on HR_JP_ID_PKG

Line 34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');

30: c_asg_run_dim constant varchar2(80) := '_ASG_RUN';
31: --
32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --

Line 35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);

31: --
32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');

Line 36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);

32: c_fuzzy_ele_class_trm constant varchar2(80) := 'TRM';
33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);

Line 37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);

33: --
34: c_com_si_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_si_info_elm,null,'JP');
35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --

Line 39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');

35: c_hi_card_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_hi_card_num_iv);
36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);

Line 40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);

36: c_basic_pension_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_basic_pension_num_iv);
37: c_wpf_members_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_si_info_elm_id,c_wpf_members_num_iv);
38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --

Line 42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');

38: --
39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);

Line 43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);

39: c_com_li_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_li_info_elm,null,'JP');
40: c_ei_num_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_li_info_elm_id,c_ei_num_iv);
41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --

Line 45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');

41: --
42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);

Line 46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);

42: c_com_hi_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_hi_quailfy_info_elm,null,'JP');
43: c_hi_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_hi_quailfy_info_elm_id,c_qualify_date_iv);
44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --

Line 48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');

44: --
45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);

Line 49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);

45: c_com_wp_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wp_quailfy_info_elm,null,'JP');
46: c_wp_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wp_quailfy_info_elm_id,c_qualify_date_iv);
47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --

Line 51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');

47: --
48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --

Line 52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);

48: c_com_wpf_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_wpf_quailfy_info_elm,null,'JP');
49: c_wpf_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_wpf_quailfy_info_elm_id,c_qualify_date_iv);
50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');

Line 54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');

50: --
51: c_com_ei_quailfy_info_elm_id constant number := hr_jp_id_pkg.element_type_id(c_com_ei_quailfy_info_elm,null,'JP');
52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');
57: --
58: c_jp_pea_flex_num number;

Line 56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');

52: c_ei_qualify_date_iv_id constant number := hr_jp_id_pkg.input_value_id(c_com_ei_quailfy_info_elm_id,c_qualify_date_iv);
53: --
54: c_b_trm_ern_bal_run_db_id constant number := hr_jp_id_pkg.defined_balance_id(c_b_trm_ern_bal,c_asg_run_dim,null,'JP');
55: --
56: c_trm_ele_set_id constant number := hr_jp_id_pkg.element_set_id(c_trm_ele_set,null,'JP');
57: --
58: c_jp_pea_flex_num number;
59: c_pai_max constant number := trunc(240/lengthb(to_multi_byte(' ')));
60: c_ext_proc_body varchar2(2000);