[Home] [Help]
1: package body pay_au_generic_code_caller as
2: -- $Header: pyaugcc.pkb 115.3 2002/12/04 06:16:15 ragovind ship $
3:
4: -- Copyright (C) 1999 Oracle Corporation
5: -- All Rights Reserved
35: ,p_process_id in number
36: ,p_assignment_action_id in number
37: ,p_input_store in t_variable_store_tab) is
38:
39: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_process' ;
40: l_parameter_value pay_au_module_parameters.constant_value%type ;
41: l_dummy varchar2(2) ;
42: l_legislation_code pay_au_module_parameters.constant_value%type ;
43:
300: (p_name in varchar2
301: ,p_data_type in varchar2
302: ,p_value in varchar2) is
303:
304: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.store_variable' ;
305: l_variable_notfound_flag boolean := true ;
306: l_counter number := 1 ;
307:
308: e_data_type_mismatch exception ;
387: (p_name in varchar2
388: ,p_data_type in varchar2
389: ,p_value out NOCOPY varchar2) is
390:
391: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.retrieve_variable' ;
392: l_variable_value pay_au_module_parameters.constant_value%type := null ;
393: l_variable_notfound_flag boolean := true ;
394: l_counter number := 1 ;
395:
461: (p_module_id in number
462: ,p_package_name in varchar2
463: ,p_procedure_name in varchar2) is
464:
465: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_procedure' ;
466:
467: begin
468:
469: hr_utility.trace('In: ' || l_procedure_name) ;
489: (p_module_id in number
490: ,p_package_name in varchar2
491: ,p_function_name in varchar2) is
492:
493: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_procedure_function' ;
494:
495: begin
496:
497: hr_utility.trace('In: ' || l_procedure_name) ;
522: l_text_out_bind_var_init pay_au_module_parameters.constant_value%type := ' ' ;
523: l_date_out_bind_var_init date := to_date('31/12/4712', 'dd/mm/yyyy') ;
524: l_num_out_bind_var_init number := 999 ;
525:
526: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_procedure_function' ;
527: l_parameter_store t_parameter_store_tab ;
528: l_sql_stmt varchar2(4000) ;
529: l_cursor_id integer ;
530: l_variable_value pay_au_module_parameters.constant_value%type ;
986: procedure execute_formula
987: (p_module_id in number
988: ,p_formula_name in varchar2) is
989:
990: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_formula' ;
991: l_formula_id ff_formulas_f.formula_id%type ;
992: l_business_group_id ff_formulas_f.business_group_id%type ;
993: l_legislation_code ff_formulas_f.legislation_code%type ;
994: l_parameter_store t_parameter_store_tab ;
1273: type t_context_store_tab
1274: is table of t_context_store_rec
1275: index by binary_integer ;
1276:
1277: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.save_result' ;
1278: l_archive_item_id ff_archive_items.archive_item_id%type ;
1279: l_user_entity_id ff_user_entities.user_entity_id%type ;
1280: l_assignment_action_id pay_assignment_actions.assignment_action_id%type ;
1281: l_legislation_code ff_user_entities.legislation_code%type ;
1471: procedure get_module_parameters
1472: (p_module_id in number
1473: ,p_parameters out NOCOPY t_parameter_store_tab) is
1474:
1475: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.get_module_parameters' ;
1476: l_counter number := 1 ;
1477:
1478: cursor c_module_parameters(p_module_id number) is
1479: select mp.internal_name
1517: hr_utility.trace('Out: ' || l_procedure_name) ;
1518:
1519: end get_module_parameters ;
1520:
1521: end pay_au_generic_code_caller ;