[Home] [Help]
108: begin
109:
110: hr_utility.trace('In: ' || l_procedure_name) ;
111: hr_utility.trace(' p_business_group_id: ' || to_char(p_business_group_id)) ;
112: hr_utility.trace(' p_effective_date: ' || fnd_date.date_to_canonical(p_effective_date)) ;
113: hr_utility.trace(' p_process_id: ' || to_char(p_process_id)) ;
114: hr_utility.trace(' p_assignment_action_id: ' || to_char(p_assignment_action_id)) ;
115:
116: -- check that there's a record in fnd_sessions (the Oracle
137: ,p_assignment_action_id) ;
138:
139: store_variable('EFFECTIVE_DATE'
140: ,'DATE'
141: ,fnd_date.date_to_canonical(p_effective_date)) ;
142:
143: -- get the legislation code we're working under and store it
144:
145: open c_legislation_code(p_business_group_id) ;
684: elsif l_parameter_store(i).data_type = 'DATE'
685: then
686:
687: l_sql_stmt := l_sql_stmt || l_parameter_store(i).external_name
688: || ' => fnd_date.cannonical_to_date(''' || l_parameter_store(i).constant_value || ''')' ;
689:
690: else
691:
692: raise e_bad_data_type ;
819: -- bind an in or in/out date bind variable
820:
821: dbms_sql.bind_variable(l_cursor_id
822: ,':' || l_parameter_store(i).internal_name
823: ,fnd_date.canonical_to_date(l_variable_value)) ;
824:
825: end if ;
826:
827: else
886: dbms_sql.variable_value(l_cursor_id
887: ,':' || l_parameter_store(i).internal_name
888: ,l_date_variable_value) ;
889:
890: l_variable_value := fnd_date.date_to_canonical(l_date_variable_value) ;
891:
892: else
893:
894: raise e_bad_data_type ;
1174: hr_utility.set_location(l_procedure_name, 180) ;
1175: per_formula_functions.run_formula
1176: (p_formula_name => p_formula_name
1177: ,p_business_group_id => l_business_group_id
1178: ,p_calculation_date => fnd_date.canonical_to_date(l_effective_date)
1179: ,p_inputs => l_ff_inputs
1180: ,p_outputs => l_ff_outputs) ;
1181:
1182: -- check the outputs