24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE approve_salary_proposal
27: (p_pay_proposal_id in number
28: ,p_change_date in date default hr_api.g_date
29: ,p_proposed_salary_n in number default hr_api.g_number
30: ,p_object_version_number in out nocopy number
31: ,p_validate in number default hr_api.g_false_num
32: ,p_error_text out nocopy varchar2
25: -- ----------------------------------------------------------------------------
26: PROCEDURE approve_salary_proposal
27: (p_pay_proposal_id in number
28: ,p_change_date in date default hr_api.g_date
29: ,p_proposed_salary_n in number default hr_api.g_number
30: ,p_object_version_number in out nocopy number
31: ,p_validate in number default hr_api.g_false_num
32: ,p_error_text out nocopy varchar2
33: ,p_return_status out nocopy varchar2
27: (p_pay_proposal_id in number
28: ,p_change_date in date default hr_api.g_date
29: ,p_proposed_salary_n in number default hr_api.g_number
30: ,p_object_version_number in out nocopy number
31: ,p_validate in number default hr_api.g_false_num
32: ,p_error_text out nocopy varchar2
33: ,p_return_status out nocopy varchar2
34: );
35: -- ----------------------------------------------------------------------------
55: --
56: -- {End of comments}
57: -- ----------------------------------------------------------------------------
58: PROCEDURE cre_or_upd_salary_proposal
59: (p_validate in number default hr_api.g_false_num
60: ,p_pay_proposal_id in out nocopy number
61: ,p_object_version_number in out nocopy number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
58: PROCEDURE cre_or_upd_salary_proposal
59: (p_validate in number default hr_api.g_false_num
60: ,p_pay_proposal_id in out nocopy number
61: ,p_object_version_number in out nocopy number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
59: (p_validate in number default hr_api.g_false_num
60: ,p_pay_proposal_id in out nocopy number
61: ,p_object_version_number in out nocopy number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
60: ,p_pay_proposal_id in out nocopy number
61: ,p_object_version_number in out nocopy number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
61: ,p_object_version_number in out nocopy number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
62: ,p_business_group_id in number default hr_api.g_number
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
63: ,p_assignment_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
64: ,p_change_date in date default hr_api.g_date
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
65: ,p_comments in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
66: ,p_next_sal_review_date in date default hr_api.g_date
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
67: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
68: ,p_proposed_salary_n in number default hr_api.g_number
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
69: ,p_forced_ranking in number default hr_api.g_number
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
70: ,p_date_to in date default hr_api.g_date
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
71: ,p_performance_review_id in number default hr_api.g_number
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
72: ,p_attribute_category in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
73: ,p_attribute1 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
74: ,p_attribute2 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
75: ,p_attribute3 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
76: ,p_attribute4 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
77: ,p_attribute5 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
78: ,p_attribute6 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
79: ,p_attribute7 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
80: ,p_attribute8 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
81: ,p_attribute9 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
82: ,p_attribute10 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
83: ,p_attribute11 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
84: ,p_attribute12 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
85: ,p_attribute13 in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
86: ,p_attribute14 in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
94: ,p_approved in varchar2 default hr_api.g_varchar2
87: ,p_attribute15 in varchar2 default hr_api.g_varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
94: ,p_approved in varchar2 default hr_api.g_varchar2
95: ,p_return_status out nocopy varchar2
88: ,p_attribute16 in varchar2 default hr_api.g_varchar2
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
94: ,p_approved in varchar2 default hr_api.g_varchar2
95: ,p_return_status out nocopy varchar2
96: );
89: ,p_attribute17 in varchar2 default hr_api.g_varchar2
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
94: ,p_approved in varchar2 default hr_api.g_varchar2
95: ,p_return_status out nocopy varchar2
96: );
97: -- ----------------------------------------------------------------------------
90: ,p_attribute18 in varchar2 default hr_api.g_varchar2
91: ,p_attribute19 in varchar2 default hr_api.g_varchar2
92: ,p_attribute20 in varchar2 default hr_api.g_varchar2
93: ,p_multiple_components in varchar2 default hr_api.g_varchar2
94: ,p_approved in varchar2 default hr_api.g_varchar2
95: ,p_return_status out nocopy varchar2
96: );
97: -- ----------------------------------------------------------------------------
98: -- |-----------------------< delete_proposal_component >----------------------|
118: -- {End of comments}
119: -- ----------------------------------------------------------------------------
120: PROCEDURE delete_proposal_component
121: (p_component_id in number
122: ,p_validation_strength in varchar2 default hr_api.g_varchar2
123: ,p_object_version_number in number
124: ,p_validate in number default hr_api.g_false_num
125: ,p_return_status out nocopy varchar2
126: );
120: PROCEDURE delete_proposal_component
121: (p_component_id in number
122: ,p_validation_strength in varchar2 default hr_api.g_varchar2
123: ,p_object_version_number in number
124: ,p_validate in number default hr_api.g_false_num
125: ,p_return_status out nocopy varchar2
126: );
127: -- ----------------------------------------------------------------------------
128: -- |------------------------< delete_salary_proposal >------------------------|
150: PROCEDURE delete_salary_proposal
151: (p_pay_proposal_id in number
152: ,p_business_group_id in number
153: ,p_object_version_number in number
154: ,p_validate in number default hr_api.g_false_num
155: ,p_return_status out nocopy varchar2
156: );
157: -- ----------------------------------------------------------------------------
158: -- |-----------------------< insert_proposal_component >----------------------|
182: ,p_pay_proposal_id in number
183: ,p_business_group_id in number
184: ,p_approved in varchar2
185: ,p_component_reason in varchar2
186: ,p_change_amount_n in number default hr_api.g_number
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
183: ,p_business_group_id in number
184: ,p_approved in varchar2
185: ,p_component_reason in varchar2
186: ,p_change_amount_n in number default hr_api.g_number
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
184: ,p_approved in varchar2
185: ,p_component_reason in varchar2
186: ,p_change_amount_n in number default hr_api.g_number
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
185: ,p_component_reason in varchar2
186: ,p_change_amount_n in number default hr_api.g_number
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
186: ,p_change_amount_n in number default hr_api.g_number
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
187: ,p_change_percentage in number default hr_api.g_number
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
188: ,p_comments in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
189: ,p_attribute_category in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
190: ,p_attribute1 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
191: ,p_attribute2 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
192: ,p_attribute3 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
193: ,p_attribute4 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
194: ,p_attribute5 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
195: ,p_attribute6 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
196: ,p_attribute7 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
197: ,p_attribute8 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
198: ,p_attribute9 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
199: ,p_attribute10 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
200: ,p_attribute11 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
201: ,p_attribute12 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
202: ,p_attribute13 in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
203: ,p_attribute14 in varchar2 default hr_api.g_varchar2
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
211: ,p_object_version_number out nocopy number
204: ,p_attribute15 in varchar2 default hr_api.g_varchar2
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
211: ,p_object_version_number out nocopy number
212: ,p_validate in number default hr_api.g_false_num
205: ,p_attribute16 in varchar2 default hr_api.g_varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
211: ,p_object_version_number out nocopy number
212: ,p_validate in number default hr_api.g_false_num
213: ,p_return_status out nocopy varchar2
206: ,p_attribute17 in varchar2 default hr_api.g_varchar2
207: ,p_attribute18 in varchar2 default hr_api.g_varchar2
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
211: ,p_object_version_number out nocopy number
212: ,p_validate in number default hr_api.g_false_num
213: ,p_return_status out nocopy varchar2
214: );
208: ,p_attribute19 in varchar2 default hr_api.g_varchar2
209: ,p_attribute20 in varchar2 default hr_api.g_varchar2
210: ,p_validation_strength in varchar2 default hr_api.g_varchar2
211: ,p_object_version_number out nocopy number
212: ,p_validate in number default hr_api.g_false_num
213: ,p_return_status out nocopy varchar2
214: );
215: -- ----------------------------------------------------------------------------
216: -- |------------------------< insert_salary_proposal >------------------------|
238: PROCEDURE insert_salary_proposal
239: (p_pay_proposal_id in number
240: ,p_assignment_id in number
241: ,p_business_group_id in number
242: ,p_change_date in date default hr_api.g_date
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
239: (p_pay_proposal_id in number
240: ,p_assignment_id in number
241: ,p_business_group_id in number
242: ,p_change_date in date default hr_api.g_date
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
240: ,p_assignment_id in number
241: ,p_business_group_id in number
242: ,p_change_date in date default hr_api.g_date
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
241: ,p_business_group_id in number
242: ,p_change_date in date default hr_api.g_date
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
242: ,p_change_date in date default hr_api.g_date
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
243: ,p_comments in varchar2 default hr_api.g_varchar2
244: ,p_next_sal_review_date in date default hr_api.g_date
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
245: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
246: ,p_proposed_salary_n in number default hr_api.g_number
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
247: ,p_forced_ranking in number default hr_api.g_number
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
248: ,p_date_to in date default hr_general.end_of_time
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
249: ,p_performance_review_id in number default hr_api.g_number
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
250: ,p_attribute_category in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
251: ,p_attribute1 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
252: ,p_attribute2 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
253: ,p_attribute3 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
254: ,p_attribute4 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
255: ,p_attribute5 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
256: ,p_attribute6 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
257: ,p_attribute7 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
258: ,p_attribute8 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
259: ,p_attribute9 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
260: ,p_attribute10 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
261: ,p_attribute11 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
262: ,p_attribute12 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
263: ,p_attribute13 in varchar2 default hr_api.g_varchar2
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
264: ,p_attribute14 in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
265: ,p_attribute15 in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
273: ,p_approved in varchar2 default hr_api.g_varchar2
266: ,p_attribute16 in varchar2 default hr_api.g_varchar2
267: ,p_attribute17 in varchar2 default hr_api.g_varchar2
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
273: ,p_approved in varchar2 default hr_api.g_varchar2
274: ,p_validate in number default hr_api.g_false_num
268: ,p_attribute18 in varchar2 default hr_api.g_varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
273: ,p_approved in varchar2 default hr_api.g_varchar2
274: ,p_validate in number default hr_api.g_false_num
275: ,p_element_entry_id in out nocopy number
276: ,p_return_status out nocopy varchar2
269: ,p_attribute19 in varchar2 default hr_api.g_varchar2
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
273: ,p_approved in varchar2 default hr_api.g_varchar2
274: ,p_validate in number default hr_api.g_false_num
275: ,p_element_entry_id in out nocopy number
276: ,p_return_status out nocopy varchar2
277: );
270: ,p_attribute20 in varchar2 default hr_api.g_varchar2
271: ,p_object_version_number out nocopy number
272: ,p_multiple_components in varchar2 default hr_api.g_varchar2
273: ,p_approved in varchar2 default hr_api.g_varchar2
274: ,p_validate in number default hr_api.g_false_num
275: ,p_element_entry_id in out nocopy number
276: ,p_return_status out nocopy varchar2
277: );
278: -- ----------------------------------------------------------------------------
299: -- {End of comments}
300: -- ----------------------------------------------------------------------------
301: PROCEDURE update_proposal_component
302: (p_component_id in number
303: ,p_approved in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
300: -- ----------------------------------------------------------------------------
301: PROCEDURE update_proposal_component
302: (p_component_id in number
303: ,p_approved in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
301: PROCEDURE update_proposal_component
302: (p_component_id in number
303: ,p_approved in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
302: (p_component_id in number
303: ,p_approved in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
303: ,p_approved in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
304: ,p_component_reason in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
305: ,p_change_amount_n in number default hr_api.g_number
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
306: ,p_change_percentage in number default hr_api.g_number
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
307: ,p_comments in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
308: ,p_attribute_category in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
309: ,p_attribute1 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
310: ,p_attribute2 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
311: ,p_attribute3 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
312: ,p_attribute4 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
313: ,p_attribute5 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
314: ,p_attribute6 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
315: ,p_attribute7 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
316: ,p_attribute8 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
317: ,p_attribute9 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
318: ,p_attribute10 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
319: ,p_attribute11 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
320: ,p_attribute12 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
321: ,p_attribute13 in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
322: ,p_attribute14 in varchar2 default hr_api.g_varchar2
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
330: ,p_object_version_number in out nocopy number
323: ,p_attribute15 in varchar2 default hr_api.g_varchar2
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
330: ,p_object_version_number in out nocopy number
331: ,p_validate in number default hr_api.g_false_num
324: ,p_attribute16 in varchar2 default hr_api.g_varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
330: ,p_object_version_number in out nocopy number
331: ,p_validate in number default hr_api.g_false_num
332: ,p_return_status out nocopy varchar2
325: ,p_attribute17 in varchar2 default hr_api.g_varchar2
326: ,p_attribute18 in varchar2 default hr_api.g_varchar2
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
330: ,p_object_version_number in out nocopy number
331: ,p_validate in number default hr_api.g_false_num
332: ,p_return_status out nocopy varchar2
333: );
327: ,p_attribute19 in varchar2 default hr_api.g_varchar2
328: ,p_attribute20 in varchar2 default hr_api.g_varchar2
329: ,p_validation_strength in varchar2 default hr_api.g_varchar2
330: ,p_object_version_number in out nocopy number
331: ,p_validate in number default hr_api.g_false_num
332: ,p_return_status out nocopy varchar2
333: );
334: -- ----------------------------------------------------------------------------
335: -- |------------------------< update_salary_proposal >------------------------|
355: -- {End of comments}
356: -- ----------------------------------------------------------------------------
357: PROCEDURE update_salary_proposal
358: (p_pay_proposal_id in number
359: ,p_change_date in date default hr_api.g_date
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
356: -- ----------------------------------------------------------------------------
357: PROCEDURE update_salary_proposal
358: (p_pay_proposal_id in number
359: ,p_change_date in date default hr_api.g_date
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
357: PROCEDURE update_salary_proposal
358: (p_pay_proposal_id in number
359: ,p_change_date in date default hr_api.g_date
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
358: (p_pay_proposal_id in number
359: ,p_change_date in date default hr_api.g_date
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
359: ,p_change_date in date default hr_api.g_date
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
360: ,p_comments in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
361: ,p_next_sal_review_date in date default hr_api.g_date
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
362: ,p_proposal_reason in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
363: ,p_proposed_salary_n in number default hr_api.g_number
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
364: ,p_forced_ranking in number default hr_api.g_number
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
365: ,p_date_to in date default hr_api.g_date
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
366: ,p_performance_review_id in number default hr_api.g_number
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
367: ,p_attribute_category in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
368: ,p_attribute1 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
369: ,p_attribute2 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
370: ,p_attribute3 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
371: ,p_attribute4 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
372: ,p_attribute5 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
373: ,p_attribute6 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
374: ,p_attribute7 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
375: ,p_attribute8 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
376: ,p_attribute9 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
377: ,p_attribute10 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
378: ,p_attribute11 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
379: ,p_attribute12 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
380: ,p_attribute13 in varchar2 default hr_api.g_varchar2
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
381: ,p_attribute14 in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
382: ,p_attribute15 in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
390: ,p_approved in varchar2 default hr_api.g_varchar2
383: ,p_attribute16 in varchar2 default hr_api.g_varchar2
384: ,p_attribute17 in varchar2 default hr_api.g_varchar2
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
390: ,p_approved in varchar2 default hr_api.g_varchar2
391: ,p_validate in number default hr_api.g_false_num
385: ,p_attribute18 in varchar2 default hr_api.g_varchar2
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
390: ,p_approved in varchar2 default hr_api.g_varchar2
391: ,p_validate in number default hr_api.g_false_num
392: ,p_return_status out nocopy varchar2
393: );
386: ,p_attribute19 in varchar2 default hr_api.g_varchar2
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
390: ,p_approved in varchar2 default hr_api.g_varchar2
391: ,p_validate in number default hr_api.g_false_num
392: ,p_return_status out nocopy varchar2
393: );
394: -- ----------------------------------------------------------------------------
387: ,p_attribute20 in varchar2 default hr_api.g_varchar2
388: ,p_object_version_number in out nocopy number
389: ,p_multiple_components in varchar2 default hr_api.g_varchar2
390: ,p_approved in varchar2 default hr_api.g_varchar2
391: ,p_validate in number default hr_api.g_false_num
392: ,p_return_status out nocopy varchar2
393: );
394: -- ----------------------------------------------------------------------------
395: -- |----------------------------< process_api >-------------------------------|
397: procedure process_api
398: (
399: p_document in CLOB
400: ,p_return_status out nocopy VARCHAR2
401: ,p_validate in number default hr_api.g_false_num
402: ,p_effective_date in date default null
403: );
404:
405: end hr_maintain_proposal_swi;