15: -- p_business_group_id NUMBER --
16: -- p_actual_termination_date DATE --
17: -- p_calling_procedure VARCHAR2 --
18: -- OUT : p_message_name VARCHAR2 --
19: -- p_token_name pay_in_utils.char_tab_type--
20: -- p_token_value pay_in_utils.char_tab_type--
21: --------------------------------------------------------------------------
22: PROCEDURE create_termination_elements
23: (p_period_of_service_id IN NUMBER
16: -- p_actual_termination_date DATE --
17: -- p_calling_procedure VARCHAR2 --
18: -- OUT : p_message_name VARCHAR2 --
19: -- p_token_name pay_in_utils.char_tab_type--
20: -- p_token_value pay_in_utils.char_tab_type--
21: --------------------------------------------------------------------------
22: PROCEDURE create_termination_elements
23: (p_period_of_service_id IN NUMBER
24: ,p_business_group_id IN NUMBER
24: ,p_business_group_id IN NUMBER
25: ,p_actual_termination_date IN DATE
26: ,p_calling_procedure IN VARCHAR2
27: ,p_message_name OUT NOCOPY VARCHAR2
28: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
29: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
30: );
31:
32: --------------------------------------------------------------------------
25: ,p_actual_termination_date IN DATE
26: ,p_calling_procedure IN VARCHAR2
27: ,p_message_name OUT NOCOPY VARCHAR2
28: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
29: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
30: );
31:
32: --------------------------------------------------------------------------
33: -- --
42: -- p_business_group_id NUMBER --
43: -- p_actual_termination_date DATE --
44: -- p_calling_procedure VARCHAR2 --
45: -- OUT : p_message_name VARCHAR2 --
46: -- p_token_name pay_in_utils.char_tab_type--
47: -- p_token_value pay_in_utils.char_tab_type--
48: --------------------------------------------------------------------------
49: PROCEDURE delete_termination_elements
50: (p_period_of_service_id IN NUMBER
43: -- p_actual_termination_date DATE --
44: -- p_calling_procedure VARCHAR2 --
45: -- OUT : p_message_name VARCHAR2 --
46: -- p_token_name pay_in_utils.char_tab_type--
47: -- p_token_value pay_in_utils.char_tab_type--
48: --------------------------------------------------------------------------
49: PROCEDURE delete_termination_elements
50: (p_period_of_service_id IN NUMBER
51: ,p_business_group_id IN NUMBER
51: ,p_business_group_id IN NUMBER
52: ,p_actual_termination_date IN DATE
53: ,p_calling_procedure IN VARCHAR2
54: ,p_message_name OUT NOCOPY VARCHAR2
55: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
56: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
57: );
58:
59: --------------------------------------------------------------------------
52: ,p_actual_termination_date IN DATE
53: ,p_calling_procedure IN VARCHAR2
54: ,p_message_name OUT NOCOPY VARCHAR2
55: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
56: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
57: );
58:
59: --------------------------------------------------------------------------
60: -- --
113: -- p_emp_category VARCHAR2 --
114: -- p_notice_period VARCHAR2 --
115: -- p_calling_procedure VARCHAR2 --
116: -- OUT : p_message_name VARCHAR2 --
117: -- p_token_name pay_in_utils.char_tab_type --
118: -- p_token_value pay_in_utils.char_tab_type --
119: --------------------------------------------------------------------------
120: PROCEDURE check_notice_period
121: (p_organization_id IN NUMBER
114: -- p_notice_period VARCHAR2 --
115: -- p_calling_procedure VARCHAR2 --
116: -- OUT : p_message_name VARCHAR2 --
117: -- p_token_name pay_in_utils.char_tab_type --
118: -- p_token_value pay_in_utils.char_tab_type --
119: --------------------------------------------------------------------------
120: PROCEDURE check_notice_period
121: (p_organization_id IN NUMBER
122: ,p_org_information_id IN NUMBER
124: ,p_emp_category IN VARCHAR2
125: ,p_notice_period IN VARCHAR2
126: ,p_calling_procedure IN VARCHAR2
127: ,p_message_name OUT NOCOPY VARCHAR2
128: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
129: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
130:
131: --------------------------------------------------------------------------
132: -- --
125: ,p_notice_period IN VARCHAR2
126: ,p_calling_procedure IN VARCHAR2
127: ,p_message_name OUT NOCOPY VARCHAR2
128: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
129: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
130:
131: --------------------------------------------------------------------------
132: -- --
133: -- Name : CHECK_GRATUITY --
140: -- IN : p_element_entry_id NUMBER --
141: -- p_effective_date DATE --
142: -- p_calling_procedure VARCHAR2 --
143: -- OUT : p_message_name VARCHAR2 --
144: -- p_token_name pay_in_utils.char_tab_type--
145: -- p_token_value pay_in_utils.char_tab_type--
146: --------------------------------------------------------------------------
147: PROCEDURE check_gratuity
148: (p_element_entry_id IN NUMBER
141: -- p_effective_date DATE --
142: -- p_calling_procedure VARCHAR2 --
143: -- OUT : p_message_name VARCHAR2 --
144: -- p_token_name pay_in_utils.char_tab_type--
145: -- p_token_value pay_in_utils.char_tab_type--
146: --------------------------------------------------------------------------
147: PROCEDURE check_gratuity
148: (p_element_entry_id IN NUMBER
149: ,p_effective_date IN DATE
148: (p_element_entry_id IN NUMBER
149: ,p_effective_date IN DATE
150: ,p_calling_procedure IN VARCHAR2
151: ,p_message_name OUT NOCOPY VARCHAR2
152: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
153: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
154:
155: --------------------------------------------------------------------------
156: -- --
149: ,p_effective_date IN DATE
150: ,p_calling_procedure IN VARCHAR2
151: ,p_message_name OUT NOCOPY VARCHAR2
152: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
153: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type);
154:
155: --------------------------------------------------------------------------
156: -- --
157: -- Name : CREATE_GRATUITY_ENTRY --
166: -- p_business_group_id NUMBER --
167: -- p_actual_termination_date DATE --
168: -- p_calling_procedure VARCHAR2 --
169: -- OUT : p_message_name VARCHAR2 --
170: -- p_token_name pay_in_utils.char_tab_type--
171: -- p_token_value pay_in_utils.char_tab_type--
172: -- Change History : --
173: --------------------------------------------------------------------------
174: -- Rev# Date Userid Description --
167: -- p_actual_termination_date DATE --
168: -- p_calling_procedure VARCHAR2 --
169: -- OUT : p_message_name VARCHAR2 --
170: -- p_token_name pay_in_utils.char_tab_type--
171: -- p_token_value pay_in_utils.char_tab_type--
172: -- Change History : --
173: --------------------------------------------------------------------------
174: -- Rev# Date Userid Description --
175: --------------------------------------------------------------------------
180: ,p_business_group_id IN NUMBER
181: ,p_actual_termination_date IN DATE
182: ,p_calling_procedure IN VARCHAR2
183: ,p_message_name OUT NOCOPY VARCHAR2
184: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
185: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
186: );
187:
188: --------------------------------------------------------------------------
181: ,p_actual_termination_date IN DATE
182: ,p_calling_procedure IN VARCHAR2
183: ,p_message_name OUT NOCOPY VARCHAR2
184: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
185: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
186: );
187:
188: --------------------------------------------------------------------------
189: -- --
198: -- p_business_group_id NUMBER --
199: -- p_actual_termination_date DATE --
200: -- p_calling_procedure VARCHAR2 --
201: -- OUT : p_message_name VARCHAR2 --
202: -- p_token_name pay_in_utils.char_tab_type--
203: -- p_token_value pay_in_utils.char_tab_type--
204: -- Change History : --
205: --------------------------------------------------------------------------
206: -- Rev# Date Userid Description --
199: -- p_actual_termination_date DATE --
200: -- p_calling_procedure VARCHAR2 --
201: -- OUT : p_message_name VARCHAR2 --
202: -- p_token_name pay_in_utils.char_tab_type--
203: -- p_token_value pay_in_utils.char_tab_type--
204: -- Change History : --
205: --------------------------------------------------------------------------
206: -- Rev# Date Userid Description --
207: --------------------------------------------------------------------------
212: ,p_business_group_id IN NUMBER
213: ,p_actual_termination_date IN DATE
214: ,p_calling_procedure IN VARCHAR2
215: ,p_message_name OUT NOCOPY VARCHAR2
216: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
217: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
218: ) ;
219:
220: --------------------------------------------------------------------------
213: ,p_actual_termination_date IN DATE
214: ,p_calling_procedure IN VARCHAR2
215: ,p_message_name OUT NOCOPY VARCHAR2
216: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
217: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
218: ) ;
219:
220: --------------------------------------------------------------------------
221: -- --