79: hr_utility.set_message(800,'HR_NL_INVALID_FORMULA');
80: hr_utility.raise_error;
81: end;
82: --insert into fnd_sessions values (userenv('sessionid'),p_session_date);
83: ff_client_engine.init_formula(l_formula_id,l_effective_start_date);
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
80: hr_utility.raise_error;
81: end;
82: --insert into fnd_sessions values (userenv('sessionid'),p_session_date);
83: ff_client_engine.init_formula(l_formula_id,l_effective_start_date);
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
81: end;
82: --insert into fnd_sessions values (userenv('sessionid'),p_session_date);
83: ff_client_engine.init_formula(l_formula_id,l_effective_start_date);
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
89: ff_client_engine.get_output('RETURN_VALUE',l_target_group);
82: --insert into fnd_sessions values (userenv('sessionid'),p_session_date);
83: ff_client_engine.init_formula(l_formula_id,l_effective_start_date);
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
89: ff_client_engine.get_output('RETURN_VALUE',l_target_group);
90:
83: ff_client_engine.init_formula(l_formula_id,l_effective_start_date);
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
89: ff_client_engine.get_output('RETURN_VALUE',l_target_group);
90:
91: return l_target_group;
84: ff_client_engine.set_input('BIRTH_COUNTRY_EMP', NVL(p_country_of_birth_emp,' '));
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
89: ff_client_engine.get_output('RETURN_VALUE',l_target_group);
90:
91: return l_target_group;
92: end;
85: ff_client_engine.set_input('BIRTH_COUNTRY_FATHER',p_country_of_birth_fth);
86: ff_client_engine.set_input('BIRTH_COUNTRY_MOTHER',p_country_of_birth_mth);
87: ff_client_engine.set_input('BUSINESS_GROUP_ID',p_business_group_id);
88: ff_client_engine.run_formula;
89: ff_client_engine.get_output('RETURN_VALUE',l_target_group);
90:
91: return l_target_group;
92: end;
93: --