eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_AU_GENERIC_CODE_CALLER dependencies on PAY_AU_MODULE_PARAMETERS

Line 40: l_parameter_value pay_au_module_parameters.constant_value%type ;

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:
44: e_missing_process_parameter exception ;

Line 42: l_legislation_code pay_au_module_parameters.constant_value%type ;

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:
44: e_missing_process_parameter exception ;
45: e_bad_module_type exception ;
46: e_missing_legislation_code exception ;

Line 392: l_variable_value pay_au_module_parameters.constant_value%type := null ;

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:
396: e_data_type_mismatch exception ;

Line 522: l_text_out_bind_var_init pay_au_module_parameters.constant_value%type := ' ' ;

518: ,p_package_name in varchar2
519: ,p_procedure_function_name in varchar2
520: ,p_mode in varchar2) is
521:
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' ;

Line 530: l_variable_value pay_au_module_parameters.constant_value%type ;

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 ;
531: l_return_code integer ;
532: l_number_variable_value number ;
533: l_date_variable_value date ;
534: l_function_return_found_flag boolean := false ;

Line 537: l_module pay_au_module_parameters.constant_value%type ;

533: l_date_variable_value date ;
534: l_function_return_found_flag boolean := false ;
535: l_no_parameters_flag boolean := true ;
536: l_first_parameter_flag boolean := true ;
537: l_module pay_au_module_parameters.constant_value%type ;
538: l_error pay_au_module_parameters.constant_value%type ;
539:
540: e_bad_mode exception ;
541: e_bad_data_type exception ;

Line 538: l_error pay_au_module_parameters.constant_value%type ;

534: l_function_return_found_flag boolean := false ;
535: l_no_parameters_flag boolean := true ;
536: l_first_parameter_flag boolean := true ;
537: l_module pay_au_module_parameters.constant_value%type ;
538: l_error pay_au_module_parameters.constant_value%type ;
539:
540: e_bad_mode exception ;
541: e_bad_data_type exception ;
542: e_missing_function_return exception ;

Line 558: -- data from the pay_au_module_parameters table for the module

554:
555: end if ;
556:
557: -- call get_module_parameters to populate a PL/SQL table with the
558: -- data from the pay_au_module_parameters table for the module
559: -- beinmg executed. This saves on database table accesses.
560:
561: get_module_parameters(p_module_id, l_parameter_store) ;
562:

Line 999: l_parameter_value pay_au_module_parameters.constant_value%type ;

995: l_inputs_counter number := 1 ;
996: l_outputs_counter number := 1 ;
997: l_ff_inputs ff_exec.inputs_t ;
998: l_ff_outputs ff_exec.outputs_t ;
999: l_parameter_value pay_au_module_parameters.constant_value%type ;
1000: l_effective_date pay_au_module_parameters.constant_value%type ;
1001: l_module pay_au_module_parameters.constant_value%type ;
1002: l_error pay_au_module_parameters.constant_value%type ;
1003: l_sqlerrm varchar2(255) ;

Line 1000: l_effective_date pay_au_module_parameters.constant_value%type ;

996: l_outputs_counter number := 1 ;
997: l_ff_inputs ff_exec.inputs_t ;
998: l_ff_outputs ff_exec.outputs_t ;
999: l_parameter_value pay_au_module_parameters.constant_value%type ;
1000: l_effective_date pay_au_module_parameters.constant_value%type ;
1001: l_module pay_au_module_parameters.constant_value%type ;
1002: l_error pay_au_module_parameters.constant_value%type ;
1003: l_sqlerrm varchar2(255) ;
1004:

Line 1001: l_module pay_au_module_parameters.constant_value%type ;

997: l_ff_inputs ff_exec.inputs_t ;
998: l_ff_outputs ff_exec.outputs_t ;
999: l_parameter_value pay_au_module_parameters.constant_value%type ;
1000: l_effective_date pay_au_module_parameters.constant_value%type ;
1001: l_module pay_au_module_parameters.constant_value%type ;
1002: l_error pay_au_module_parameters.constant_value%type ;
1003: l_sqlerrm varchar2(255) ;
1004:
1005: e_bad_formula exception ;

Line 1002: l_error pay_au_module_parameters.constant_value%type ;

998: l_ff_outputs ff_exec.outputs_t ;
999: l_parameter_value pay_au_module_parameters.constant_value%type ;
1000: l_effective_date pay_au_module_parameters.constant_value%type ;
1001: l_module pay_au_module_parameters.constant_value%type ;
1002: l_error pay_au_module_parameters.constant_value%type ;
1003: l_sqlerrm varchar2(255) ;
1004:
1005: e_bad_formula exception ;
1006: e_module_error exception ;

Line 1025: l_output_value pay_au_module_parameters.constant_value%type := null ;

1021: -- local function to loop through the FF inputs PL/SQL table
1022: -- looking for a output name
1023:
1024: l_procedure_name varchar2(61) := 'get_ff_output' ;
1025: l_output_value pay_au_module_parameters.constant_value%type := null ;
1026:
1027: begin
1028:
1029: hr_utility.trace(' In: ' || l_procedure_name) ;

Line 1083: -- data from the pay_au_module_parameters table for the module

1079: end if ;
1080: close c_formula ;
1081:
1082: -- call get_module_parameters to populate a PL/SQL table with the
1083: -- data from the pay_au_module_parameters table for the module
1084: -- beinmg executed. This saves on database table accesses.
1085:
1086: hr_utility.set_location(l_procedure_name, 40) ;
1087: get_module_parameters(p_module_id, l_parameter_store) ;

Line 1285: l_variable_value pay_au_module_parameters.constant_value%type ;

1281: l_legislation_code ff_user_entities.legislation_code%type ;
1282: l_object_version_number ff_archive_items.object_version_number%type ;
1283: l_some_warning boolean ;
1284: l_context_store t_context_store_tab ;
1285: l_variable_value pay_au_module_parameters.constant_value%type ;
1286: l_counter integer := 1 ;
1287:
1288: e_bad_user_entity exception ;
1289:

Line 1490: from pay_au_module_parameters mp

1486: , mp.function_return_flag
1487: , mp.external_name
1488: , mp.database_item_name
1489: , mp.constant_value
1490: from pay_au_module_parameters mp
1491: where mp.module_id = p_module_id
1492: and mp.enabled_flag = 'Y' ;
1493:
1494: begin