eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_STS_DEL dependencies on PQH_STS_SHD

Line 53: (p_rec in pqh_sts_shd.g_rec_type

49: --
50: -- {End Of Comments}
51: -- ----------------------------------------------------------------------------
52: Procedure delete_dml
53: (p_rec in pqh_sts_shd.g_rec_type
54: ) is
55: --
56: l_proc varchar2(72) := g_package||'delete_dml';
57: --

Line 85: pqh_sts_shd.constraint_error

81: Exception
82: When hr_api.child_integrity_violated then
83: -- Child integrity has been violated
84: --
85: pqh_sts_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When Others Then
88: --
89: Raise;

Line 124: Procedure pre_delete(p_rec in pqh_sts_shd.g_rec_type) is

120: -- Internal Row Handler Use Only.
121: --
122: -- {End Of Comments}
123: -- ----------------------------------------------------------------------------
124: Procedure pre_delete(p_rec in pqh_sts_shd.g_rec_type) is
125: --
126: l_proc varchar2(72) := g_package||'pre_delete';
127: --
128: Begin

Line 171: Procedure post_delete(p_rec in pqh_sts_shd.g_rec_type) is

167: -- Internal Row Handler Use Only.
168: --
169: -- {End Of Comments}
170: -- -----------------------------------------------------------------------------
171: Procedure post_delete(p_rec in pqh_sts_shd.g_rec_type) is
172: --
173: l_proc varchar2(72) := g_package||'post_delete';
174: --
175: Begin

Line 190: => pqh_sts_shd.g_old_rec.business_group_id

186: pqh_sts_rkd.after_delete
187: (p_statutory_situation_id
188: => p_rec.statutory_situation_id
189: ,p_business_group_id_o
190: => pqh_sts_shd.g_old_rec.business_group_id
191: ,p_situation_name_o
192: => pqh_sts_shd.g_old_rec.situation_name
193: ,p_type_of_ps_o
194: => pqh_sts_shd.g_old_rec.type_of_ps

Line 192: => pqh_sts_shd.g_old_rec.situation_name

188: => p_rec.statutory_situation_id
189: ,p_business_group_id_o
190: => pqh_sts_shd.g_old_rec.business_group_id
191: ,p_situation_name_o
192: => pqh_sts_shd.g_old_rec.situation_name
193: ,p_type_of_ps_o
194: => pqh_sts_shd.g_old_rec.type_of_ps
195: ,p_situation_type_o
196: => pqh_sts_shd.g_old_rec.situation_type

Line 194: => pqh_sts_shd.g_old_rec.type_of_ps

190: => pqh_sts_shd.g_old_rec.business_group_id
191: ,p_situation_name_o
192: => pqh_sts_shd.g_old_rec.situation_name
193: ,p_type_of_ps_o
194: => pqh_sts_shd.g_old_rec.type_of_ps
195: ,p_situation_type_o
196: => pqh_sts_shd.g_old_rec.situation_type
197: ,p_sub_type_o
198: => pqh_sts_shd.g_old_rec.sub_type

Line 196: => pqh_sts_shd.g_old_rec.situation_type

192: => pqh_sts_shd.g_old_rec.situation_name
193: ,p_type_of_ps_o
194: => pqh_sts_shd.g_old_rec.type_of_ps
195: ,p_situation_type_o
196: => pqh_sts_shd.g_old_rec.situation_type
197: ,p_sub_type_o
198: => pqh_sts_shd.g_old_rec.sub_type
199: ,p_source_o
200: => pqh_sts_shd.g_old_rec.source

Line 198: => pqh_sts_shd.g_old_rec.sub_type

194: => pqh_sts_shd.g_old_rec.type_of_ps
195: ,p_situation_type_o
196: => pqh_sts_shd.g_old_rec.situation_type
197: ,p_sub_type_o
198: => pqh_sts_shd.g_old_rec.sub_type
199: ,p_source_o
200: => pqh_sts_shd.g_old_rec.source
201: ,p_location_o
202: => pqh_sts_shd.g_old_rec.location

Line 200: => pqh_sts_shd.g_old_rec.source

196: => pqh_sts_shd.g_old_rec.situation_type
197: ,p_sub_type_o
198: => pqh_sts_shd.g_old_rec.sub_type
199: ,p_source_o
200: => pqh_sts_shd.g_old_rec.source
201: ,p_location_o
202: => pqh_sts_shd.g_old_rec.location
203: ,p_reason_o
204: => pqh_sts_shd.g_old_rec.reason

Line 202: => pqh_sts_shd.g_old_rec.location

198: => pqh_sts_shd.g_old_rec.sub_type
199: ,p_source_o
200: => pqh_sts_shd.g_old_rec.source
201: ,p_location_o
202: => pqh_sts_shd.g_old_rec.location
203: ,p_reason_o
204: => pqh_sts_shd.g_old_rec.reason
205: ,p_is_default_o
206: => pqh_sts_shd.g_old_rec.is_default

Line 204: => pqh_sts_shd.g_old_rec.reason

200: => pqh_sts_shd.g_old_rec.source
201: ,p_location_o
202: => pqh_sts_shd.g_old_rec.location
203: ,p_reason_o
204: => pqh_sts_shd.g_old_rec.reason
205: ,p_is_default_o
206: => pqh_sts_shd.g_old_rec.is_default
207: ,p_date_from_o
208: => pqh_sts_shd.g_old_rec.date_from

Line 206: => pqh_sts_shd.g_old_rec.is_default

202: => pqh_sts_shd.g_old_rec.location
203: ,p_reason_o
204: => pqh_sts_shd.g_old_rec.reason
205: ,p_is_default_o
206: => pqh_sts_shd.g_old_rec.is_default
207: ,p_date_from_o
208: => pqh_sts_shd.g_old_rec.date_from
209: ,p_date_to_o
210: => pqh_sts_shd.g_old_rec.date_to

Line 208: => pqh_sts_shd.g_old_rec.date_from

204: => pqh_sts_shd.g_old_rec.reason
205: ,p_is_default_o
206: => pqh_sts_shd.g_old_rec.is_default
207: ,p_date_from_o
208: => pqh_sts_shd.g_old_rec.date_from
209: ,p_date_to_o
210: => pqh_sts_shd.g_old_rec.date_to
211: ,p_request_type_o
212: => pqh_sts_shd.g_old_rec.request_type

Line 210: => pqh_sts_shd.g_old_rec.date_to

206: => pqh_sts_shd.g_old_rec.is_default
207: ,p_date_from_o
208: => pqh_sts_shd.g_old_rec.date_from
209: ,p_date_to_o
210: => pqh_sts_shd.g_old_rec.date_to
211: ,p_request_type_o
212: => pqh_sts_shd.g_old_rec.request_type
213: ,p_employee_agreement_needed_o
214: => pqh_sts_shd.g_old_rec.employee_agreement_needed

Line 212: => pqh_sts_shd.g_old_rec.request_type

208: => pqh_sts_shd.g_old_rec.date_from
209: ,p_date_to_o
210: => pqh_sts_shd.g_old_rec.date_to
211: ,p_request_type_o
212: => pqh_sts_shd.g_old_rec.request_type
213: ,p_employee_agreement_needed_o
214: => pqh_sts_shd.g_old_rec.employee_agreement_needed
215: ,p_manager_agreement_needed_o
216: => pqh_sts_shd.g_old_rec.manager_agreement_needed

Line 214: => pqh_sts_shd.g_old_rec.employee_agreement_needed

210: => pqh_sts_shd.g_old_rec.date_to
211: ,p_request_type_o
212: => pqh_sts_shd.g_old_rec.request_type
213: ,p_employee_agreement_needed_o
214: => pqh_sts_shd.g_old_rec.employee_agreement_needed
215: ,p_manager_agreement_needed_o
216: => pqh_sts_shd.g_old_rec.manager_agreement_needed
217: ,p_print_arrette_o
218: => pqh_sts_shd.g_old_rec.print_arrette

Line 216: => pqh_sts_shd.g_old_rec.manager_agreement_needed

212: => pqh_sts_shd.g_old_rec.request_type
213: ,p_employee_agreement_needed_o
214: => pqh_sts_shd.g_old_rec.employee_agreement_needed
215: ,p_manager_agreement_needed_o
216: => pqh_sts_shd.g_old_rec.manager_agreement_needed
217: ,p_print_arrette_o
218: => pqh_sts_shd.g_old_rec.print_arrette
219: ,p_reserve_position_o
220: => pqh_sts_shd.g_old_rec.reserve_position

Line 218: => pqh_sts_shd.g_old_rec.print_arrette

214: => pqh_sts_shd.g_old_rec.employee_agreement_needed
215: ,p_manager_agreement_needed_o
216: => pqh_sts_shd.g_old_rec.manager_agreement_needed
217: ,p_print_arrette_o
218: => pqh_sts_shd.g_old_rec.print_arrette
219: ,p_reserve_position_o
220: => pqh_sts_shd.g_old_rec.reserve_position
221: ,p_allow_progressions_o
222: => pqh_sts_shd.g_old_rec.allow_progressions

Line 220: => pqh_sts_shd.g_old_rec.reserve_position

216: => pqh_sts_shd.g_old_rec.manager_agreement_needed
217: ,p_print_arrette_o
218: => pqh_sts_shd.g_old_rec.print_arrette
219: ,p_reserve_position_o
220: => pqh_sts_shd.g_old_rec.reserve_position
221: ,p_allow_progressions_o
222: => pqh_sts_shd.g_old_rec.allow_progressions
223: ,p_extend_probation_period_o
224: => pqh_sts_shd.g_old_rec.extend_probation_period

Line 222: => pqh_sts_shd.g_old_rec.allow_progressions

218: => pqh_sts_shd.g_old_rec.print_arrette
219: ,p_reserve_position_o
220: => pqh_sts_shd.g_old_rec.reserve_position
221: ,p_allow_progressions_o
222: => pqh_sts_shd.g_old_rec.allow_progressions
223: ,p_extend_probation_period_o
224: => pqh_sts_shd.g_old_rec.extend_probation_period
225: ,p_remuneration_paid_o
226: => pqh_sts_shd.g_old_rec.remuneration_paid

Line 224: => pqh_sts_shd.g_old_rec.extend_probation_period

220: => pqh_sts_shd.g_old_rec.reserve_position
221: ,p_allow_progressions_o
222: => pqh_sts_shd.g_old_rec.allow_progressions
223: ,p_extend_probation_period_o
224: => pqh_sts_shd.g_old_rec.extend_probation_period
225: ,p_remuneration_paid_o
226: => pqh_sts_shd.g_old_rec.remuneration_paid
227: ,p_pay_share_o
228: => pqh_sts_shd.g_old_rec.pay_share

Line 226: => pqh_sts_shd.g_old_rec.remuneration_paid

222: => pqh_sts_shd.g_old_rec.allow_progressions
223: ,p_extend_probation_period_o
224: => pqh_sts_shd.g_old_rec.extend_probation_period
225: ,p_remuneration_paid_o
226: => pqh_sts_shd.g_old_rec.remuneration_paid
227: ,p_pay_share_o
228: => pqh_sts_shd.g_old_rec.pay_share
229: ,p_pay_periods_o
230: => pqh_sts_shd.g_old_rec.pay_periods

Line 228: => pqh_sts_shd.g_old_rec.pay_share

224: => pqh_sts_shd.g_old_rec.extend_probation_period
225: ,p_remuneration_paid_o
226: => pqh_sts_shd.g_old_rec.remuneration_paid
227: ,p_pay_share_o
228: => pqh_sts_shd.g_old_rec.pay_share
229: ,p_pay_periods_o
230: => pqh_sts_shd.g_old_rec.pay_periods
231: ,p_frequency_o
232: => pqh_sts_shd.g_old_rec.frequency

Line 230: => pqh_sts_shd.g_old_rec.pay_periods

226: => pqh_sts_shd.g_old_rec.remuneration_paid
227: ,p_pay_share_o
228: => pqh_sts_shd.g_old_rec.pay_share
229: ,p_pay_periods_o
230: => pqh_sts_shd.g_old_rec.pay_periods
231: ,p_frequency_o
232: => pqh_sts_shd.g_old_rec.frequency
233: ,p_first_period_max_duration_o
234: => pqh_sts_shd.g_old_rec.first_period_max_duration

Line 232: => pqh_sts_shd.g_old_rec.frequency

228: => pqh_sts_shd.g_old_rec.pay_share
229: ,p_pay_periods_o
230: => pqh_sts_shd.g_old_rec.pay_periods
231: ,p_frequency_o
232: => pqh_sts_shd.g_old_rec.frequency
233: ,p_first_period_max_duration_o
234: => pqh_sts_shd.g_old_rec.first_period_max_duration
235: ,p_min_duration_per_request_o
236: => pqh_sts_shd.g_old_rec.min_duration_per_request

Line 234: => pqh_sts_shd.g_old_rec.first_period_max_duration

230: => pqh_sts_shd.g_old_rec.pay_periods
231: ,p_frequency_o
232: => pqh_sts_shd.g_old_rec.frequency
233: ,p_first_period_max_duration_o
234: => pqh_sts_shd.g_old_rec.first_period_max_duration
235: ,p_min_duration_per_request_o
236: => pqh_sts_shd.g_old_rec.min_duration_per_request
237: ,p_max_duration_per_request_o
238: => pqh_sts_shd.g_old_rec.max_duration_per_request

Line 236: => pqh_sts_shd.g_old_rec.min_duration_per_request

232: => pqh_sts_shd.g_old_rec.frequency
233: ,p_first_period_max_duration_o
234: => pqh_sts_shd.g_old_rec.first_period_max_duration
235: ,p_min_duration_per_request_o
236: => pqh_sts_shd.g_old_rec.min_duration_per_request
237: ,p_max_duration_per_request_o
238: => pqh_sts_shd.g_old_rec.max_duration_per_request
239: ,p_max_duration_whole_career_o
240: => pqh_sts_shd.g_old_rec.max_duration_whole_career

Line 238: => pqh_sts_shd.g_old_rec.max_duration_per_request

234: => pqh_sts_shd.g_old_rec.first_period_max_duration
235: ,p_min_duration_per_request_o
236: => pqh_sts_shd.g_old_rec.min_duration_per_request
237: ,p_max_duration_per_request_o
238: => pqh_sts_shd.g_old_rec.max_duration_per_request
239: ,p_max_duration_whole_career_o
240: => pqh_sts_shd.g_old_rec.max_duration_whole_career
241: ,p_renewable_allowed_o
242: => pqh_sts_shd.g_old_rec.renewable_allowed

Line 240: => pqh_sts_shd.g_old_rec.max_duration_whole_career

236: => pqh_sts_shd.g_old_rec.min_duration_per_request
237: ,p_max_duration_per_request_o
238: => pqh_sts_shd.g_old_rec.max_duration_per_request
239: ,p_max_duration_whole_career_o
240: => pqh_sts_shd.g_old_rec.max_duration_whole_career
241: ,p_renewable_allowed_o
242: => pqh_sts_shd.g_old_rec.renewable_allowed
243: ,p_max_no_of_renewals_o
244: => pqh_sts_shd.g_old_rec.max_no_of_renewals

Line 242: => pqh_sts_shd.g_old_rec.renewable_allowed

238: => pqh_sts_shd.g_old_rec.max_duration_per_request
239: ,p_max_duration_whole_career_o
240: => pqh_sts_shd.g_old_rec.max_duration_whole_career
241: ,p_renewable_allowed_o
242: => pqh_sts_shd.g_old_rec.renewable_allowed
243: ,p_max_no_of_renewals_o
244: => pqh_sts_shd.g_old_rec.max_no_of_renewals
245: ,p_max_duration_per_renewal_o
246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal

Line 244: => pqh_sts_shd.g_old_rec.max_no_of_renewals

240: => pqh_sts_shd.g_old_rec.max_duration_whole_career
241: ,p_renewable_allowed_o
242: => pqh_sts_shd.g_old_rec.renewable_allowed
243: ,p_max_no_of_renewals_o
244: => pqh_sts_shd.g_old_rec.max_no_of_renewals
245: ,p_max_duration_per_renewal_o
246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
247: ,p_max_tot_continuous_duratio_o
248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration

Line 246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal

242: => pqh_sts_shd.g_old_rec.renewable_allowed
243: ,p_max_no_of_renewals_o
244: => pqh_sts_shd.g_old_rec.max_no_of_renewals
245: ,p_max_duration_per_renewal_o
246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
247: ,p_max_tot_continuous_duratio_o
248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
249: ,p_object_version_number_o
250: => pqh_sts_shd.g_old_rec.object_version_number

Line 248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration

244: => pqh_sts_shd.g_old_rec.max_no_of_renewals
245: ,p_max_duration_per_renewal_o
246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
247: ,p_max_tot_continuous_duratio_o
248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
249: ,p_object_version_number_o
250: => pqh_sts_shd.g_old_rec.object_version_number
251: ,p_remunerate_assign_stat_id_o
252: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id

Line 250: => pqh_sts_shd.g_old_rec.object_version_number

246: => pqh_sts_shd.g_old_rec.max_duration_per_renewal
247: ,p_max_tot_continuous_duratio_o
248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
249: ,p_object_version_number_o
250: => pqh_sts_shd.g_old_rec.object_version_number
251: ,p_remunerate_assign_stat_id_o
252: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
253: );
254: --

Line 252: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id

248: => pqh_sts_shd.g_old_rec.max_tot_continuous_duration
249: ,p_object_version_number_o
250: => pqh_sts_shd.g_old_rec.object_version_number
251: ,p_remunerate_assign_stat_id_o
252: => pqh_sts_shd.g_old_rec.remunerate_assign_status_id
253: );
254: --
255: exception
256: --

Line 276: (p_rec in pqh_sts_shd.g_rec_type

272: -- ----------------------------------------------------------------------------
273: -- |---------------------------------< del >----------------------------------|
274: -- ----------------------------------------------------------------------------
275: Procedure del
276: (p_rec in pqh_sts_shd.g_rec_type
277: ) is
278: --
279: l_proc varchar2(72) := g_package||'del';
280: --

Line 290: pqh_sts_shd.lck

286: End if;
287: --
288: -- We must lock the row which we need to delete.
289: --
290: pqh_sts_shd.lck
291: (p_rec.statutory_situation_id
292: ,p_rec.object_version_number
293: );
294: --

Line 327: l_rec pqh_sts_shd.g_rec_type;

323: (p_statutory_situation_id in number
324: ,p_object_version_number in number
325: ) is
326: --
327: l_rec pqh_sts_shd.g_rec_type;
328: l_proc varchar2(72) := g_package||'del';
329: --
330: Begin
331: