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.HR_DTY_UPD dependencies on HR_DTY_SHD

Line 49: (p_rec in out nocopy hr_dty_shd.g_rec_type

45: --
46: -- {End Of Comments}
47: -- ----------------------------------------------------------------------------
48: Procedure update_dml
49: (p_rec in out nocopy hr_dty_shd.g_rec_type
50: ) is
51: --
52: l_proc varchar2(72) := g_package||'update_dml';
53: --

Line 89: hr_dty_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: hr_dty_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --

Line 94: hr_dty_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: --
94: hr_dty_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --

Line 99: hr_dty_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: --
99: hr_dty_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: --
103: Raise;

Line 139: (p_rec in hr_dty_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in hr_dty_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 184: ,p_rec in hr_dty_shd.g_rec_type

180: -- {End Of Comments}
181: -- ----------------------------------------------------------------------------
182: Procedure post_update
183: (p_effective_date in date
184: ,p_rec in hr_dty_shd.g_rec_type
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'post_update';
188: --

Line 222: => hr_dty_shd.g_old_rec.category_code

218: => p_rec.program_update_date
219: ,p_object_version_number
220: => p_rec.object_version_number
221: ,p_category_code_o
222: => hr_dty_shd.g_old_rec.category_code
223: ,p_sub_category_code_o
224: => hr_dty_shd.g_old_rec.sub_category_code
225: ,p_active_inactive_flag_o
226: => hr_dty_shd.g_old_rec.active_inactive_flag

Line 224: => hr_dty_shd.g_old_rec.sub_category_code

220: => p_rec.object_version_number
221: ,p_category_code_o
222: => hr_dty_shd.g_old_rec.category_code
223: ,p_sub_category_code_o
224: => hr_dty_shd.g_old_rec.sub_category_code
225: ,p_active_inactive_flag_o
226: => hr_dty_shd.g_old_rec.active_inactive_flag
227: ,p_multiple_occurences_flag_o
228: => hr_dty_shd.g_old_rec.multiple_occurences_flag

Line 226: => hr_dty_shd.g_old_rec.active_inactive_flag

222: => hr_dty_shd.g_old_rec.category_code
223: ,p_sub_category_code_o
224: => hr_dty_shd.g_old_rec.sub_category_code
225: ,p_active_inactive_flag_o
226: => hr_dty_shd.g_old_rec.active_inactive_flag
227: ,p_multiple_occurences_flag_o
228: => hr_dty_shd.g_old_rec.multiple_occurences_flag
229: ,p_legislation_code_o
230: => hr_dty_shd.g_old_rec.legislation_code

Line 228: => hr_dty_shd.g_old_rec.multiple_occurences_flag

224: => hr_dty_shd.g_old_rec.sub_category_code
225: ,p_active_inactive_flag_o
226: => hr_dty_shd.g_old_rec.active_inactive_flag
227: ,p_multiple_occurences_flag_o
228: => hr_dty_shd.g_old_rec.multiple_occurences_flag
229: ,p_legislation_code_o
230: => hr_dty_shd.g_old_rec.legislation_code
231: ,p_authorization_required_o
232: => hr_dty_shd.g_old_rec.authorization_required

Line 230: => hr_dty_shd.g_old_rec.legislation_code

226: => hr_dty_shd.g_old_rec.active_inactive_flag
227: ,p_multiple_occurences_flag_o
228: => hr_dty_shd.g_old_rec.multiple_occurences_flag
229: ,p_legislation_code_o
230: => hr_dty_shd.g_old_rec.legislation_code
231: ,p_authorization_required_o
232: => hr_dty_shd.g_old_rec.authorization_required
233: ,p_warning_period_o
234: => hr_dty_shd.g_old_rec.warning_period

Line 232: => hr_dty_shd.g_old_rec.authorization_required

228: => hr_dty_shd.g_old_rec.multiple_occurences_flag
229: ,p_legislation_code_o
230: => hr_dty_shd.g_old_rec.legislation_code
231: ,p_authorization_required_o
232: => hr_dty_shd.g_old_rec.authorization_required
233: ,p_warning_period_o
234: => hr_dty_shd.g_old_rec.warning_period
235: ,p_request_id_o
236: => hr_dty_shd.g_old_rec.request_id

Line 234: => hr_dty_shd.g_old_rec.warning_period

230: => hr_dty_shd.g_old_rec.legislation_code
231: ,p_authorization_required_o
232: => hr_dty_shd.g_old_rec.authorization_required
233: ,p_warning_period_o
234: => hr_dty_shd.g_old_rec.warning_period
235: ,p_request_id_o
236: => hr_dty_shd.g_old_rec.request_id
237: ,p_program_application_id_o
238: => hr_dty_shd.g_old_rec.program_application_id

Line 236: => hr_dty_shd.g_old_rec.request_id

232: => hr_dty_shd.g_old_rec.authorization_required
233: ,p_warning_period_o
234: => hr_dty_shd.g_old_rec.warning_period
235: ,p_request_id_o
236: => hr_dty_shd.g_old_rec.request_id
237: ,p_program_application_id_o
238: => hr_dty_shd.g_old_rec.program_application_id
239: ,p_program_id_o
240: => hr_dty_shd.g_old_rec.program_id

Line 238: => hr_dty_shd.g_old_rec.program_application_id

234: => hr_dty_shd.g_old_rec.warning_period
235: ,p_request_id_o
236: => hr_dty_shd.g_old_rec.request_id
237: ,p_program_application_id_o
238: => hr_dty_shd.g_old_rec.program_application_id
239: ,p_program_id_o
240: => hr_dty_shd.g_old_rec.program_id
241: ,p_program_update_date_o
242: => hr_dty_shd.g_old_rec.program_update_date

Line 240: => hr_dty_shd.g_old_rec.program_id

236: => hr_dty_shd.g_old_rec.request_id
237: ,p_program_application_id_o
238: => hr_dty_shd.g_old_rec.program_application_id
239: ,p_program_id_o
240: => hr_dty_shd.g_old_rec.program_id
241: ,p_program_update_date_o
242: => hr_dty_shd.g_old_rec.program_update_date
243: ,p_object_version_number_o
244: => hr_dty_shd.g_old_rec.object_version_number

Line 242: => hr_dty_shd.g_old_rec.program_update_date

238: => hr_dty_shd.g_old_rec.program_application_id
239: ,p_program_id_o
240: => hr_dty_shd.g_old_rec.program_id
241: ,p_program_update_date_o
242: => hr_dty_shd.g_old_rec.program_update_date
243: ,p_object_version_number_o
244: => hr_dty_shd.g_old_rec.object_version_number
245: );
246: --

Line 244: => hr_dty_shd.g_old_rec.object_version_number

240: => hr_dty_shd.g_old_rec.program_id
241: ,p_program_update_date_o
242: => hr_dty_shd.g_old_rec.program_update_date
243: ,p_object_version_number_o
244: => hr_dty_shd.g_old_rec.object_version_number
245: );
246: --
247: exception
248: --

Line 304: (p_rec in out nocopy hr_dty_shd.g_rec_type

300: --
301: -- {End Of Comments}
302: -- ----------------------------------------------------------------------------
303: Procedure convert_defs
304: (p_rec in out nocopy hr_dty_shd.g_rec_type
305: ) is
306: --
307: Begin
308: --

Line 316: hr_dty_shd.g_old_rec.category_code;

312: -- is being used then we must set to the 'current' argument value.
313: --
314: If (p_rec.category_code = hr_api.g_varchar2) then
315: p_rec.category_code :=
316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;

Line 320: hr_dty_shd.g_old_rec.sub_category_code;

316: hr_dty_shd.g_old_rec.category_code;
317: End If;
318: If (p_rec.sub_category_code = hr_api.g_varchar2) then
319: p_rec.sub_category_code :=
320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;

Line 324: hr_dty_shd.g_old_rec.active_inactive_flag;

320: hr_dty_shd.g_old_rec.sub_category_code;
321: End If;
322: If (p_rec.active_inactive_flag = hr_api.g_varchar2) then
323: p_rec.active_inactive_flag :=
324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;

Line 328: hr_dty_shd.g_old_rec.multiple_occurences_flag;

324: hr_dty_shd.g_old_rec.active_inactive_flag;
325: End If;
326: If (p_rec.multiple_occurences_flag = hr_api.g_varchar2) then
327: p_rec.multiple_occurences_flag :=
328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;

Line 332: hr_dty_shd.g_old_rec.legislation_code;

328: hr_dty_shd.g_old_rec.multiple_occurences_flag;
329: End If;
330: If (p_rec.legislation_code = hr_api.g_varchar2) then
331: p_rec.legislation_code :=
332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;

Line 336: hr_dty_shd.g_old_rec.authorization_required;

332: hr_dty_shd.g_old_rec.legislation_code;
333: End If;
334: If (p_rec.authorization_required = hr_api.g_varchar2) then
335: p_rec.authorization_required :=
336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;

Line 340: hr_dty_shd.g_old_rec.warning_period;

336: hr_dty_shd.g_old_rec.authorization_required;
337: End If;
338: If (p_rec.warning_period = hr_api.g_number) then
339: p_rec.warning_period :=
340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;

Line 344: hr_dty_shd.g_old_rec.request_id;

340: hr_dty_shd.g_old_rec.warning_period;
341: End If;
342: If (p_rec.request_id = hr_api.g_number) then
343: p_rec.request_id :=
344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;

Line 348: hr_dty_shd.g_old_rec.program_application_id;

344: hr_dty_shd.g_old_rec.request_id;
345: End If;
346: If (p_rec.program_application_id = hr_api.g_number) then
347: p_rec.program_application_id :=
348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;

Line 352: hr_dty_shd.g_old_rec.program_id;

348: hr_dty_shd.g_old_rec.program_application_id;
349: End If;
350: If (p_rec.program_id = hr_api.g_number) then
351: p_rec.program_id :=
352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then
355: p_rec.program_update_date :=
356: hr_dty_shd.g_old_rec.program_update_date;

Line 356: hr_dty_shd.g_old_rec.program_update_date;

352: hr_dty_shd.g_old_rec.program_id;
353: End If;
354: If (p_rec.program_update_date = hr_api.g_date) then
355: p_rec.program_update_date :=
356: hr_dty_shd.g_old_rec.program_update_date;
357: End If;
358: --
359: End convert_defs;
360: --

Line 366: ,p_rec in out nocopy hr_dty_shd.g_rec_type

362: -- |---------------------------------< upd >----------------------------------|
363: -- ----------------------------------------------------------------------------
364: Procedure upd
365: (p_effective_date in date
366: ,p_rec in out nocopy hr_dty_shd.g_rec_type
367: ) is
368: --
369: l_proc varchar2(72) := g_package||'upd';
370: --

Line 377: hr_dty_shd.lck

373: --
374:
375: -- We must lock the row which we need to update.
376: --
377: hr_dty_shd.lck
378: (p_rec.document_type_id
379: ,p_rec.object_version_number
380: );
381: --

Line 440: l_rec hr_dty_shd.g_rec_type;

436: ,p_program_id in number default hr_api.g_number
437: ,p_program_update_date in date default hr_api.g_date
438: ) is
439: --
440: l_rec hr_dty_shd.g_rec_type;
441: l_proc varchar2(72) := g_package||'upd';
442: --
443: Begin
444: hr_utility.set_location('Entering:'||l_proc, 5);

Line 451: hr_dty_shd.convert_args

447: -- l_rec structure.
448:
449: --
450: l_rec :=
451: hr_dty_shd.convert_args
452: (p_document_type_id
453: ,null
454: ,p_category_code
455: ,p_sub_category_code