[Home] [Help]
PACKAGE: APPS.PAY_JP_BALANCE_PKG
Source
4 RETURN VARCHAR2;
1 PACKAGE PAY_JP_BALANCE_PKG AUTHID CURRENT_USER AS
2 /* $Header: pyjpblnc.pkh 120.0.12000000.1 2007/01/17 21:29:45 appldev noship $ */
3 FUNCTION get_legislation_code(p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)
5 -- pragma restrict_references(GET_LEGISLATION_CODE,WNDS,WNPS);
6 --
7 FUNCTION GET_BALANCE_VALUE(
8 P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
9 P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
10 P_ASSIGNMENT_ACTION_ID IN NUMBER)
11 RETURN NUMBER;
12 --
13 FUNCTION GET_BALANCE_VALUE(
14 P_DEFINED_BALANCE_ID IN NUMBER,
15 P_ASSIGNMENT_ACTION_ID IN NUMBER)
16 RETURN NUMBER;
17 --
18 FUNCTION GET_BALANCE_VALUE(
19 P_BALANCE_NAME IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
20 P_DIMENSION_NAME IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
21 P_ASSIGNMENT_ID IN NUMBER,
22 P_EFFECTIVE_DATE IN DATE)
23 RETURN NUMBER;
24 --
25 FUNCTION GET_BALANCE_VALUE(
26 P_DEFINED_BALANCE_ID IN NUMBER,
27 P_ASSIGNMENT_ID IN NUMBER,
28 P_EFFECTIVE_DATE IN DATE)
29 RETURN NUMBER;
30 --
31 FUNCTION GET_BALANCE_VALUE_ASG_RUN(
32 P_BALANCE_TYPE_ID IN NUMBER,
33 P_ASSIGNMENT_ACTION_ID IN NUMBER)
34 RETURN NUMBER;
35 -- pragma restrict_references(GET_BALANCE_VALUE_ASG_RUN,WNDS,WNPS);
36 --
37 FUNCTION GET_RESULT_VALUE_PAY_VALUE(
38 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
39 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
40 RETURN NUMBER;
41 -- pragma restrict_references(GET_RESULT_VALUE_PAY_VALUE,WNDS,WNPS);
42 --
43 FUNCTION GET_RESULT_VALUE_PAY_VALUE(
44 P_ELEMENT_TYPE_ID IN NUMBER,
45 P_INPUT_VALUE_ID IN NUMBER,
46 P_ASSIGNMENT_ACTION_ID IN NUMBER)
47 RETURN NUMBER;
48 -- pragma restrict_references(GET_RESULT_VALUE_PAY_VALUE,WNDS,WNPS);
49 --
50 FUNCTION GET_RESULT_VALUE_CHAR(
51 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
52 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
53 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
54 RETURN VARCHAR2;
55 -- pragma restrict_references(GET_RESULT_VALUE_CHAR,WNDS,WNPS);
56 --
57 -- Never remove p_element_type_id which makes performance worse.
58 FUNCTION GET_RESULT_VALUE_CHAR(
59 P_ELEMENT_TYPE_ID IN NUMBER,
60 P_INPUT_VALUE_ID IN NUMBER,
61 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
62 RETURN VARCHAR2;
63 -- pragma restrict_references(GET_RESULT_VALUE_CHAR,WNDS,WNPS);
64 --
65 FUNCTION GET_RESULT_VALUE_NUMBER(
66 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
67 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
68 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
69 RETURN NUMBER;
70 -- pragma restrict_references(GET_RESULT_VALUE_NUMBER,WNDS,WNPS);
71 --
72 -- Never remove p_element_type_id which makes performance worse.
73 FUNCTION GET_RESULT_VALUE_NUMBER(
74 P_ELEMENT_TYPE_ID IN NUMBER,
75 P_INPUT_VALUE_ID IN NUMBER,
76 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
77 RETURN NUMBER;
78 -- pragma restrict_references(GET_RESULT_VALUE_NUMBER,WNDS,WNPS);
79 --
80 FUNCTION GET_RESULT_VALUE_DATE(
81 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
82 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
83 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
84 RETURN DATE;
85 -- pragma restrict_references(GET_RESULT_VALUE_DATE,WNDS,WNPS);
86 --
87 -- Never remove p_element_type_id which makes performance worse.
88 FUNCTION GET_RESULT_VALUE_DATE(
89 P_ELEMENT_TYPE_ID IN NUMBER,
90 P_INPUT_VALUE_ID IN NUMBER,
91 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
92 RETURN DATE;
93 -- pragma restrict_references(GET_RESULT_VALUE_DATE,WNDS,WNPS);
94 --
95 FUNCTION GET_ENTRY_VALUE_CHAR(
96 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
97 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
98 P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
99 P_EFFECTIVE_DATE IN DATE)
103 FUNCTION GET_ENTRY_VALUE_CHAR(
100 RETURN VARCHAR2;
101 -- pragma restrict_references(GET_ENTRY_VALUE_CHAR,WNDS,WNPS);
102 --
104 P_INPUT_VALUE_ID IN NUMBER,
105 P_ASSIGNMENT_ID IN NUMBER,
106 P_EFFECTIVE_DATE IN DATE)
107 RETURN VARCHAR2;
108 -- pragma restrict_references(GET_ENTRY_VALUE_CHAR,WNDS,WNPS);
109 --
110 FUNCTION GET_ENTRY_VALUE_NUMBER(
111 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
112 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
113 P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
114 P_EFFECTIVE_DATE IN DATE)
115 RETURN NUMBER;
116 -- pragma restrict_references(GET_ENTRY_VALUE_NUMBER,WNDS,WNPS);
117 --
118 FUNCTION GET_ENTRY_VALUE_NUMBER(
119 P_INPUT_VALUE_ID IN NUMBER,
120 P_ASSIGNMENT_ID IN NUMBER,
121 P_EFFECTIVE_DATE IN DATE)
122 RETURN NUMBER;
123 -- pragma restrict_references(GET_ENTRY_VALUE_NUMBER,WNDS,WNPS);
124 --
125 FUNCTION GET_ENTRY_VALUE_DATE(
126 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
127 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
128 P_ASSIGNMENT_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
129 P_EFFECTIVE_DATE IN DATE)
130 RETURN DATE;
131 -- pragma restrict_references(GET_ENTRY_VALUE_DATE,WNDS,WNPS);
132 --
133 FUNCTION GET_ENTRY_VALUE_DATE(
134 P_INPUT_VALUE_ID IN NUMBER,
135 P_ASSIGNMENT_ID IN NUMBER,
136 P_EFFECTIVE_DATE IN DATE)
137 RETURN DATE;
138 -- pragma restrict_references(GET_ENTRY_VALUE_DATE,WNDS,WNPS);
139 --
140 FUNCTION GET_ELEMENT_TYPE_ID(
141 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
142 P_BUSINESS_GROUP_ID IN NUMBER,
143 P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
144 RETURN NUMBER;
145 -- pragma restrict_references(GET_ELEMENT_TYPE_ID,WNDS,WNPS);
146 --
147 PROCEDURE get_element_input_id(
148 p_element_name IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
149 p_input_value_name IN PAY_INPUT_VALUES_F.NAME%TYPE,
150 p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
151 p_element_type_id IN OUT NOCOPY NUMBER,
152 p_input_value_id IN OUT NOCOPY NUMBER);
153 -- pragma restrict_references(GET_ELEMENT_INPUT_ID,WNDS,WNPS);
154 --
155 FUNCTION GET_INPUT_VALUE_ID(
156 P_ELEMENT_TYPE_ID IN NUMBER,
157 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE)
158 RETURN NUMBER;
159 -- pragma restrict_references(GET_INPUT_VALUE_ID,WNDS,WNPS);
160 --
161 FUNCTION GET_INPUT_VALUE_ID(
162 P_ELEMENT_NAME IN PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE,
163 P_INPUT_VALUE_NAME IN PAY_INPUT_VALUES_F.NAME%TYPE,
164 P_BUSINESS_GROUP_ID IN NUMBER,
165 P_LEGISLATION_CODE IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
166 RETURN NUMBER;
167 -- pragma restrict_references(GET_INPUT_VALUE_ID,WNDS,WNPS);
168 --
169 FUNCTION get_loc_uni_seq_input_value_id(
170 p_element_name in pay_element_types_f.element_name%type,
171 p_input_value_disp_seq in pay_input_values_f.display_sequence%type,
172 p_business_group_id in number,
173 p_legislation_code in per_business_groups.legislation_code%type)
174 RETURN number;
175 -- pragma restrict_references(get_loc_uni_seq_input_value_id,WNDS,WNPS);
176 --
177 FUNCTION get_defined_balance_id(p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
178 p_dimension_name IN PAY_BALANCE_DIMENSIONS.DIMENSION_NAME%TYPE,
179 p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE)
180 RETURN NUMBER;
181 -- pragma restrict_references(GET_DEFINED_BALANCE_ID,WNDS,WNPS);
182 --
183 FUNCTION GET_BALANCE_TYPE_ID(
184 p_balance_name IN PAY_BALANCE_TYPES.BALANCE_NAME%TYPE,
185 p_business_group_id IN PER_BUSINESS_GROUPS.BUSINESS_GROUP_ID%TYPE,
186 p_legislation_code IN PER_BUSINESS_GROUPS.LEGISLATION_CODE%TYPE)
187 RETURN NUMBER;
188 -- pragma restrict_references(GET_BALANCE_TYPE_ID,WNDS,WNPS);
189 --
190 FUNCTION GET_DEFINED_BALANCE_ID(
191 P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
192 P_ASSIGNMENT_ID IN PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE,
193 P_EFFECTIVE_DATE IN DATE)
194 RETURN NUMBER;
195 -- pragma restrict_references(GET_DEFINED_BALANCE_ID,WNDS,WNPS);
196 --
197 FUNCTION GET_DEFINED_BALANCE_ID(
198 P_BALANCE_TYPE_ID IN PAY_BALANCE_TYPES.BALANCE_TYPE_ID%TYPE,
199 P_ASSIGNMENT_ACTION_ID IN PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ACTION_ID%TYPE)
200 RETURN NUMBER;
201 -- pragma restrict_references(GET_DEFINED_BALANCE_ID,WNDS,WNPS);
202 END PAY_JP_BALANCE_PKG;