[Home] [Help]
PACKAGE: APPS.PAY_AU_GENERIC_CODE_CALLER
Source
1 package pay_au_generic_code_caller AUTHID CURRENT_USER as
2 -- $Header: pyaugcc.pkh 115.3 2002/12/04 06:15:02 ragovind ship $
3
4 -- Copyright (C) 1999 Oracle Corporation
5 -- All Rights Reserved
6 --
7 -- Script to create AU HRMS generic code caller package.
8 --
9 -- Change List
10 -- ===========
11 --
12 -- Date Author Reference Description
13 -- -----------+--------+---------+-------------
14 -- 03 Dec 2002 Ragovind 2689226 Added NOCOPY for the functions get_module_parameters, retrieve_variable and added dbdrv command
15 -- 28 Feb 2000 JTurner Renamed script and objects to use country
16 -- identifier of "AU" instead of "NZ"
17 -- 30 NOV 1999 JTURNER N/A Created
18
19 -----------------------------------------------------------------------------
20 -- public global declarations
21 -----------------------------------------------------------------------------
22
23 type t_variable_store_rec is record
24 (name pay_au_module_parameters.internal_name%type
25 ,data_type pay_au_module_parameters.data_type%type
26 ,value pay_au_module_parameters.constant_value%type) ;
27
28 type t_variable_store_tab
29 is table of t_variable_store_rec
30 index by binary_integer ;
31
32 v_variable_store t_variable_store_tab ;
33
34 type t_parameter_store_rec is record
35 (internal_name pay_au_module_parameters.internal_name%type
36 ,data_type pay_au_module_parameters.data_type%type
37 ,input_flag pay_au_module_parameters.input_flag%type
38 ,context_flag pay_au_module_parameters.context_flag%type
39 ,output_flag pay_au_module_parameters.output_flag%type
40 ,result_flag pay_au_module_parameters.result_flag%type
41 ,error_message_flag pay_au_module_parameters.error_message_flag%type
42 ,function_return_flag pay_au_module_parameters.function_return_flag%type
43 ,external_name pay_au_module_parameters.external_name%type
44 ,database_item_name pay_au_module_parameters.database_item_name%type
45 ,constant_value pay_au_module_parameters.constant_value%type) ;
46
47 type t_parameter_store_tab
48 is table of t_parameter_store_rec
49 index by binary_integer ;
50
51 -----------------------------------------------------------------------------
52 -- execute_process procedure
53 -----------------------------------------------------------------------------
54
55 procedure execute_process
56 (p_business_group_id in number
57 ,p_effective_date in date
58 ,p_process_id in number
59 ,p_assignment_action_id in number
60 ,p_input_store in t_variable_store_tab) ;
61
62 -----------------------------------------------------------------------------
63 -- store_variable procedure
64 -----------------------------------------------------------------------------
65
66 procedure store_variable
67 (p_name in varchar2
68 ,p_data_type in varchar2
69 ,p_value in varchar2) ;
70
71 -----------------------------------------------------------------------------
72 -- retrieve_variable procedure
73 -----------------------------------------------------------------------------
74
75 procedure retrieve_variable
76 (p_name in varchar2
77 ,p_data_type in varchar2
78 ,p_value out NOCOPY varchar2) ;
79
80 -----------------------------------------------------------------------------
81 -- execute_procedure procedure
82 -----------------------------------------------------------------------------
83
84 procedure execute_procedure
85 (p_module_id in number
86 ,p_package_name in varchar2
87 ,p_procedure_name in varchar2) ;
88
89 -----------------------------------------------------------------------------
90 -- execute_function procedure
91 -----------------------------------------------------------------------------
92
93 procedure execute_function
94 (p_module_id in number
95 ,p_package_name in varchar2
96 ,p_function_name in varchar2) ;
97
98 -----------------------------------------------------------------------------
99 -- execute_procedure_function procedure
100 -----------------------------------------------------------------------------
101
102 procedure execute_procedure_function
103 (p_module_id in number
104 ,p_package_name in varchar2
105 ,p_procedure_function_name in varchar2
106 ,p_mode in varchar2) ;
107
108 -----------------------------------------------------------------------------
109 -- execute_formula procedure
110 -----------------------------------------------------------------------------
111
112 procedure execute_formula
113 (p_module_id in number
114 ,p_formula_name in varchar2) ;
115
116 -----------------------------------------------------------------------------
117 -- save_result procedure
118 -----------------------------------------------------------------------------
119
120 procedure save_result
121 (p_database_item_name in varchar2
122 ,p_result_value in varchar2) ;
123
124 -----------------------------------------------------------------------------
125 -- get_module_parameters procedure
126 -----------------------------------------------------------------------------
127
128 procedure get_module_parameters
129 (p_module_id in number
130 ,p_parameters out NOCOPY t_parameter_store_tab) ;
131
132 end pay_au_generic_code_caller ;