71: --
72: -- {End of comments}
73: -- ----------------------------------------------------------------------------
74: PROCEDURE create_rate_value
75: (p_validate in number default hr_api.g_false_num
76: ,p_effective_date in date
77: ,p_business_group_id in number
78: ,p_rate_id in number
79: ,p_grade_or_spinal_point_id in number
119: (p_validate in boolean default false
120: ,p_grade_rule_id in number
121: ,p_effective_date in date
122: ,p_datetrack_mode in varchar2
123: ,p_currency_code in varchar2 default hr_api.g_varchar2
124: ,p_value in varchar2 default hr_api.g_varchar2
125: ,p_object_version_number in out nocopy number
126: ,p_effective_start_date out nocopy date
127: ,p_effective_end_date out nocopy date
120: ,p_grade_rule_id in number
121: ,p_effective_date in date
122: ,p_datetrack_mode in varchar2
123: ,p_currency_code in varchar2 default hr_api.g_varchar2
124: ,p_value in varchar2 default hr_api.g_varchar2
125: ,p_object_version_number in out nocopy number
126: ,p_effective_start_date out nocopy date
127: ,p_effective_end_date out nocopy date
128: ,p_return_status out nocopy varchar2
150: --
151: -- {End of comments}
152: -- ----------------------------------------------------------------------------
153: PROCEDURE update_rate_value
154: (p_validate in number default hr_api.g_false_num
155: ,p_grade_rule_id in number
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
154: (p_validate in number default hr_api.g_false_num
155: ,p_grade_rule_id in number
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
155: ,p_grade_rule_id in number
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
163: ,p_value in varchar2 default hr_api.g_varchar2
156: ,p_effective_date in date
157: ,p_datetrack_mode in varchar2
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
163: ,p_value in varchar2 default hr_api.g_varchar2
164: ,p_object_version_number in out nocopy number
157: ,p_datetrack_mode in varchar2
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
163: ,p_value in varchar2 default hr_api.g_varchar2
164: ,p_object_version_number in out nocopy number
165: ,p_effective_start_date out nocopy date
158: ,p_currency_code in varchar2 default hr_api.g_varchar2
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
163: ,p_value in varchar2 default hr_api.g_varchar2
164: ,p_object_version_number in out nocopy number
165: ,p_effective_start_date out nocopy date
166: ,p_effective_end_date out nocopy date
159: ,p_maximum in varchar2 default hr_api.g_varchar2
160: ,p_mid_value in varchar2 default hr_api.g_varchar2
161: ,p_minimum in varchar2 default hr_api.g_varchar2
162: ,p_sequence in number default hr_api.g_number
163: ,p_value in varchar2 default hr_api.g_varchar2
164: ,p_object_version_number in out nocopy number
165: ,p_effective_start_date out nocopy date
166: ,p_effective_end_date out nocopy date
167: ,p_return_status out nocopy varchar2
222: --
223: -- {End of comments}
224: -- ----------------------------------------------------------------------------
225: PROCEDURE delete_rate_value
226: (p_validate in number default hr_api.g_false_num
227: ,p_grade_rule_id in number
228: ,p_datetrack_mode in varchar2
229: ,p_effective_date in date
230: ,p_object_version_number in out nocopy number
278:
279: PROCEDURE process_save
280: (p_mode in VARCHAR2 default '#'
281: ,p_flow_mode in VARCHAR2 default NULL
282: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
283: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
284: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
285: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
286: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
279: PROCEDURE process_save
280: (p_mode in VARCHAR2 default '#'
281: ,p_flow_mode in VARCHAR2 default NULL
282: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
283: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
284: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
285: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
286: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
287: ,p_return_status out nocopy VARCHAR2
280: (p_mode in VARCHAR2 default '#'
281: ,p_flow_mode in VARCHAR2 default NULL
282: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
283: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
284: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
285: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
286: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
287: ,p_return_status out nocopy VARCHAR2
288: ,p_transaction_step_id out nocopy NUMBER
281: ,p_flow_mode in VARCHAR2 default NULL
282: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
283: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
284: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
285: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
286: ,p_asg_rate_tab in HR_ASG_RATE_TABLE
287: ,p_return_status out nocopy VARCHAR2
288: ,p_transaction_step_id out nocopy NUMBER
289: );
326:
327: PROCEDURE po_process_save
328: (p_mode in VARCHAR2 default '#'
329: ,p_flow_mode in VARCHAR2 default NULL
330: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
331: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
332: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
333: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
334: ,p_po_line_id in NUMBER
327: PROCEDURE po_process_save
328: (p_mode in VARCHAR2 default '#'
329: ,p_flow_mode in VARCHAR2 default NULL
330: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
331: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
332: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
333: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
334: ,p_po_line_id in NUMBER
335: ,p_return_status out nocopy VARCHAR2
328: (p_mode in VARCHAR2 default '#'
329: ,p_flow_mode in VARCHAR2 default NULL
330: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
331: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
332: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
333: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
334: ,p_po_line_id in NUMBER
335: ,p_return_status out nocopy VARCHAR2
336: ,p_transaction_step_id out nocopy NUMBER
329: ,p_flow_mode in VARCHAR2 default NULL
330: ,p_item_type in VARCHAR2 default hr_api.g_varchar2
331: ,p_item_key in VARCHAR2 default hr_api.g_varchar2
332: ,p_activity_id in VARCHAR2 default hr_api.g_varchar2
333: ,p_effective_date_option in VARCHAR2 default hr_api.g_varchar2
334: ,p_po_line_id in NUMBER
335: ,p_return_status out nocopy VARCHAR2
336: ,p_transaction_step_id out nocopy NUMBER
337: );