APPS.PQH_FR_STAT_SITUATIONS_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_statutory_situation
27: (p_validate in number default hr_api.g_false_num
28: ,p_effective_date in date default null
29: ,p_business_group_id in number
30: ,p_situation_name in varchar2
31: ,p_type_of_ps in varchar2

Line 88: (p_validate in number default hr_api.g_false_num

84: --
85: -- {End of comments}
86: -- ----------------------------------------------------------------------------
87: PROCEDURE delete_statutory_situation
88: (p_validate in number default hr_api.g_false_num
89: ,p_statutory_situation_id in number
90: ,p_object_version_number in number
91: ,p_return_status out nocopy varchar2
92: );

Line 117: (p_validate in number default hr_api.g_false_num

113: --
114: -- {End of comments}
115: -- ----------------------------------------------------------------------------
116: PROCEDURE update_statutory_situation
117: (p_validate in number default hr_api.g_false_num
118: ,p_effective_date in date default hr_api.g_date
119: ,p_statutory_situation_id in number
120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number

Line 118: ,p_effective_date in date default hr_api.g_date

114: -- {End of comments}
115: -- ----------------------------------------------------------------------------
116: PROCEDURE update_statutory_situation
117: (p_validate in number default hr_api.g_false_num
118: ,p_effective_date in date default hr_api.g_date
119: ,p_statutory_situation_id in number
120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2

Line 121: ,p_business_group_id in number default hr_api.g_number

117: (p_validate in number default hr_api.g_false_num
118: ,p_effective_date in date default hr_api.g_date
119: ,p_statutory_situation_id in number
120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2

Line 122: ,p_situation_name in varchar2 default hr_api.g_varchar2

118: ,p_effective_date in date default hr_api.g_date
119: ,p_statutory_situation_id in number
120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2

Line 123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2

119: ,p_statutory_situation_id in number
120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2

Line 124: ,p_situation_type in varchar2 default hr_api.g_varchar2

120: ,p_object_version_number in out nocopy number
121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2

Line 125: ,p_sub_type in varchar2 default hr_api.g_varchar2

121: ,p_business_group_id in number default hr_api.g_number
122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2

Line 126: ,p_source in varchar2 default hr_api.g_varchar2

122: ,p_situation_name in varchar2 default hr_api.g_varchar2
123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date

Line 127: ,p_location in varchar2 default hr_api.g_varchar2

123: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date

Line 128: ,p_reason in varchar2 default hr_api.g_varchar2

124: ,p_situation_type in varchar2 default hr_api.g_varchar2
125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2

Line 129: ,p_is_default in varchar2 default hr_api.g_varchar2

125: ,p_sub_type in varchar2 default hr_api.g_varchar2
126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

Line 130: ,p_date_from in date default hr_api.g_date

126: ,p_source in varchar2 default hr_api.g_varchar2
127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

Line 131: ,p_date_to in date default hr_api.g_date

127: ,p_location in varchar2 default hr_api.g_varchar2
128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2

Line 132: ,p_request_type in varchar2 default hr_api.g_varchar2

128: ,p_reason in varchar2 default hr_api.g_varchar2
129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2

Line 133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2

129: ,p_is_default in varchar2 default hr_api.g_varchar2
130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

Line 134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2

130: ,p_date_from in date default hr_api.g_date
131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

Line 135: ,p_print_arrette in varchar2 default hr_api.g_varchar2

131: ,p_date_to in date default hr_api.g_date
132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

Line 136: ,p_reserve_position in varchar2 default hr_api.g_varchar2

132: ,p_request_type in varchar2 default hr_api.g_varchar2
133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number

Line 137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2

133: ,p_employee_agreement_needed in varchar2 default hr_api.g_varchar2
134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number

Line 138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2

134: ,p_manager_agreement_needed in varchar2 default hr_api.g_varchar2
135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2

135: ,p_print_arrette in varchar2 default hr_api.g_varchar2
136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number

Line 140: ,p_pay_share in number default hr_api.g_number

136: ,p_reserve_position in varchar2 default hr_api.g_varchar2
137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number

Line 141: ,p_pay_periods in number default hr_api.g_number

137: ,p_allow_progressions in varchar2 default hr_api.g_varchar2
138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number

Line 142: ,p_frequency in varchar2 default hr_api.g_varchar2

138: ,p_extend_probation_period in varchar2 default hr_api.g_varchar2
139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number

Line 143: ,p_first_period_max_duration in number default hr_api.g_number

139: ,p_remuneration_paid in varchar2 default hr_api.g_varchar2
140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

Line 144: ,p_min_duration_per_request in number default hr_api.g_number

140: ,p_pay_share in number default hr_api.g_number
141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number

Line 145: ,p_max_duration_per_request in number default hr_api.g_number

141: ,p_pay_periods in number default hr_api.g_number
142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number

Line 146: ,p_max_duration_whole_career in number default hr_api.g_number

142: ,p_frequency in varchar2 default hr_api.g_varchar2
143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number

Line 147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2

143: ,p_first_period_max_duration in number default hr_api.g_number
144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number
151: ,p_remunerate_assign_status_id in number default hr_api.g_number

Line 148: ,p_max_no_of_renewals in number default hr_api.g_number

144: ,p_min_duration_per_request in number default hr_api.g_number
145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number
151: ,p_remunerate_assign_status_id in number default hr_api.g_number
152: ,p_return_status out nocopy varchar2

Line 149: ,p_max_duration_per_renewal in number default hr_api.g_number

145: ,p_max_duration_per_request in number default hr_api.g_number
146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number
151: ,p_remunerate_assign_status_id in number default hr_api.g_number
152: ,p_return_status out nocopy varchar2
153: );

Line 150: ,p_max_tot_continuous_duration in number default hr_api.g_number

146: ,p_max_duration_whole_career in number default hr_api.g_number
147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number
151: ,p_remunerate_assign_status_id in number default hr_api.g_number
152: ,p_return_status out nocopy varchar2
153: );
154: end pqh_fr_stat_situations_swi;

Line 151: ,p_remunerate_assign_status_id in number default hr_api.g_number

147: ,p_renewable_allowed in varchar2 default hr_api.g_varchar2
148: ,p_max_no_of_renewals in number default hr_api.g_number
149: ,p_max_duration_per_renewal in number default hr_api.g_number
150: ,p_max_tot_continuous_duration in number default hr_api.g_number
151: ,p_remunerate_assign_status_id in number default hr_api.g_number
152: ,p_return_status out nocopy varchar2
153: );
154: end pqh_fr_stat_situations_swi;