[Home] [Help]
PACKAGE: APPS.PAY_IN_ETW_STRUCT
Source
1 PACKAGE pay_in_etw_struct AS
2 /* $Header: pyinetst.pkh 120.0.12010000.1 2008/07/27 22:53:18 appldev ship $ */
3 g_package CONSTANT VARCHAR2(20) := 'pay_in_etw_struct.';
4 --------------------------------------------------------------------------
5 -- TYPE Definitions used in ETW
6 --------------------------------------------------------------------------
7
8 TYPE t_input_values_rec IS RECORD
9 (input_value_name pay_input_values_f.name%TYPE
10 ,input_value_id pay_input_values_f.input_value_id%TYPE
11 ,uom pay_input_values_f.uom%TYPE
12 ,mandatory_flag pay_input_values_f.mandatory_flag%TYPE
13 ,lookup_type pay_input_values_f.lookup_type%TYPE
14 ,default_value pay_input_values_f.default_value%TYPE
15 ,def_value_column pay_shadow_input_values.default_value_column%type
16 ,min_value pay_input_values_f.min_value%TYPE
17 ,warn_or_error pay_input_values_f.warning_or_error%TYPE
18 ,balance_name pay_balance_types.balance_name%TYPE
19 ,exclusion_tag VARCHAR2(10)
20 );
21
22 TYPE t_input_values_tab IS TABLE OF t_input_values_rec
23 INDEX BY BINARY_INTEGER;
24
25 TYPE t_formula_results_rec IS RECORD
26 (result_name pay_formula_result_rules_f.result_name%TYPE
27 ,result_rule_type pay_formula_result_rules_f.result_rule_type%TYPE
28 ,input_value_name pay_input_values_f.name%TYPE
29 ,element_name pay_element_types_f.element_name%TYPE
30 ,severity_level pay_formula_result_rules_f.severity_level%TYPE
31 ,exclusion_tag VARCHAR2(10)
32 );
33
34 TYPE t_formula_results_tab IS TABLE OF t_formula_results_rec
35 INDEX BY BINARY_INTEGER;
36
37 TYPE t_formula_setup_rec IS RECORD
38 (formula_name ff_formulas_f.formula_name%TYPE
39 ,status_rule_id pay_status_processing_rules_f.status_processing_rule_id%TYPE
40 ,formula_id ff_formulas_f.formula_id%TYPE
41 ,description ff_formulas_f.description%TYPE
42 ,frs_setup t_formula_results_tab
43 );
44
45 TYPE t_formula_setup_tab IS TABLE OF t_formula_setup_rec
46 INDEX BY BINARY_INTEGER;
47
48 TYPE t_user_formula_rec IS RECORD
49 (name VARCHAR2(15)
50 ,text VARCHAR2(10000)
51 );
52
53 TYPE t_user_formula_tab IS TABLE OF t_user_formula_rec
54 INDEX BY BINARY_INTEGER;
55
56 TYPE t_excl_rules_rec IS RECORD
57 (ff_column pay_template_exclusion_rules.flexfield_column%TYPE
58 ,value pay_template_exclusion_rules.exclusion_value%TYPE
59 ,descr pay_template_exclusion_rules.description%TYPE
60 ,rule_id pay_template_exclusion_rules.exclusion_rule_id%TYPE
61 ,tag VARCHAR2(10)
62 );
63
64 TYPE t_excl_rules_tab IS TABLE OF t_excl_rules_rec
65 INDEX BY BINARY_INTEGER;
66
67 TYPE t_balance_feeds_rec IS RECORD
68 (balance_name pay_balance_types.balance_name%TYPE
69 ,iv_name pay_input_values_f.name%TYPE
70 ,scale pay_balance_feeds_f.scale%TYPE
71 ,exclusion_tag VARCHAR2(10)
72 );
73
74 TYPE t_balance_feeds_tab IS TABLE OF t_balance_feeds_rec
75 INDEX BY BINARY_INTEGER;
76
77 TYPE t_add_elmt_setup_rec IS RECORD
78 (element_name pay_element_types_f.element_name%TYPE
79 ,classification pay_element_classifications.classification_name%TYPE
80 ,exclusion_tag VARCHAR2(10)
81 ,priority pay_shadow_element_types.relative_processing_priority%TYPE
82 ,element_id pay_shadow_element_types.element_type_id%TYPE
83 ,iv_setup t_input_values_tab
84 ,bf_setup t_balance_feeds_tab
85 ,uf_setup t_formula_setup_rec
86 );
87
88 TYPE t_add_elmt_setup_tab IS TABLE OF t_add_elmt_setup_rec
89 INDEX BY BINARY_INTEGER;
90
91 TYPE t_template_setup_rec IS RECORD
92 (template_name pay_element_templates.template_name%TYPE
93 ,category pay_element_classifications.classification_name%TYPE
94 ,priority pay_element_types_f.processing_priority%TYPE
95 ,template_id pay_element_templates.template_id%TYPE
96 ,base_element_id pay_element_types_f.element_type_id%TYPE
97 ,er_setup t_excl_rules_tab
98 ,uf_setup t_formula_setup_rec
99 ,iv_setup t_input_values_tab
100 ,bf_setup t_balance_feeds_tab
101 ,sf_setup t_formula_setup_rec
102 ,ae_setup t_add_elmt_setup_tab
103 );
104
105 TYPE t_template_setup_tab IS TABLE OF t_template_setup_rec
106 INDEX BY BINARY_INTEGER;
107
108 --------------------------------------------------------------------------
109 -- Global/Public Variables required in ETW
110 --------------------------------------------------------------------------
111 g_template_obj t_template_setup_tab;
112 g_formula_obj t_user_formula_tab;
113 g_max_length CONSTANT NUMBER := 50;
114 g_template_type CONSTANT VARCHAR2(1) := 'T';
115 g_legislation_code CONSTANT VARCHAR2(2) := 'IN';
116 g_currency_code CONSTANT VARCHAR2(3) := 'INR';
117
118 --------------------------------------------------------------------------
119 -- Name : INIT_CODE --
120 -- Type : PROCEDURE --
121 -- Access : Public --
122 -- Description : Procedure to initialize the templates for ETW --
123 -- Parameters : --
124 -- IN : N/A --
125 -- OUT : N/A --
126 -- RETURN : N/A --
127 --------------------------------------------------------------------------
128 PROCEDURE init_code ;
129
130 --------------------------------------------------------------------------
131 -- Name : INIT_FORMULA --
132 -- Type : PROCEDURE --
133 -- Access : Public --
134 -- Description : Procedure to initialize the user-formula texts --
135 -- Parameters : --
136 -- IN : N/A --
137 -- OUT : N/A --
138 -- RETURN : N/A --
139 --------------------------------------------------------------------------
140 PROCEDURE init_formula;
141
142 END pay_in_etw_struct;