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.PER_QAT_UPD dependencies on PER_QAT_SHD

Line 55: (p_rec in out nocopy per_qat_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy per_qat_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 92: per_qat_shd.constraint_error

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

Line 97: per_qat_shd.constraint_error

93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: --
97: per_qat_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --

Line 102: per_qat_shd.constraint_error

98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: --
102: per_qat_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: --
106: Raise;

Line 142: (p_rec in per_qat_shd.g_rec_type

138: --
139: -- {End Of Comments}
140: -- ----------------------------------------------------------------------------
141: Procedure pre_update
142: (p_rec in per_qat_shd.g_rec_type
143: ) is
144: --
145: l_proc varchar2(72) := g_package||'pre_update';
146: --

Line 186: (p_rec in per_qat_shd.g_rec_type

182: --
183: -- {End Of Comments}
184: -- ----------------------------------------------------------------------------
185: Procedure post_update
186: (p_rec in per_qat_shd.g_rec_type
187: ) is
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: --

Line 219: => per_qat_shd.g_old_rec.source_lang

215: => p_rec.training_completed_units
216: ,p_membership_category
217: => p_rec.membership_category
218: ,p_source_lang_o
219: => per_qat_shd.g_old_rec.source_lang
220: ,p_title_o
221: => per_qat_shd.g_old_rec.title
222: ,p_group_ranking_o
223: => per_qat_shd.g_old_rec.group_ranking

Line 221: => per_qat_shd.g_old_rec.title

217: => p_rec.membership_category
218: ,p_source_lang_o
219: => per_qat_shd.g_old_rec.source_lang
220: ,p_title_o
221: => per_qat_shd.g_old_rec.title
222: ,p_group_ranking_o
223: => per_qat_shd.g_old_rec.group_ranking
224: ,p_license_restrictions_o
225: => per_qat_shd.g_old_rec.license_restrictions

Line 223: => per_qat_shd.g_old_rec.group_ranking

219: => per_qat_shd.g_old_rec.source_lang
220: ,p_title_o
221: => per_qat_shd.g_old_rec.title
222: ,p_group_ranking_o
223: => per_qat_shd.g_old_rec.group_ranking
224: ,p_license_restrictions_o
225: => per_qat_shd.g_old_rec.license_restrictions
226: ,p_awarding_body_o
227: => per_qat_shd.g_old_rec.awarding_body

Line 225: => per_qat_shd.g_old_rec.license_restrictions

221: => per_qat_shd.g_old_rec.title
222: ,p_group_ranking_o
223: => per_qat_shd.g_old_rec.group_ranking
224: ,p_license_restrictions_o
225: => per_qat_shd.g_old_rec.license_restrictions
226: ,p_awarding_body_o
227: => per_qat_shd.g_old_rec.awarding_body
228: ,p_grade_attained_o
229: => per_qat_shd.g_old_rec.grade_attained

Line 227: => per_qat_shd.g_old_rec.awarding_body

223: => per_qat_shd.g_old_rec.group_ranking
224: ,p_license_restrictions_o
225: => per_qat_shd.g_old_rec.license_restrictions
226: ,p_awarding_body_o
227: => per_qat_shd.g_old_rec.awarding_body
228: ,p_grade_attained_o
229: => per_qat_shd.g_old_rec.grade_attained
230: ,p_reimbursement_arrangements_o
231: => per_qat_shd.g_old_rec.reimbursement_arrangements

Line 229: => per_qat_shd.g_old_rec.grade_attained

225: => per_qat_shd.g_old_rec.license_restrictions
226: ,p_awarding_body_o
227: => per_qat_shd.g_old_rec.awarding_body
228: ,p_grade_attained_o
229: => per_qat_shd.g_old_rec.grade_attained
230: ,p_reimbursement_arrangements_o
231: => per_qat_shd.g_old_rec.reimbursement_arrangements
232: ,p_training_completed_units_o
233: => per_qat_shd.g_old_rec.training_completed_units

Line 231: => per_qat_shd.g_old_rec.reimbursement_arrangements

227: => per_qat_shd.g_old_rec.awarding_body
228: ,p_grade_attained_o
229: => per_qat_shd.g_old_rec.grade_attained
230: ,p_reimbursement_arrangements_o
231: => per_qat_shd.g_old_rec.reimbursement_arrangements
232: ,p_training_completed_units_o
233: => per_qat_shd.g_old_rec.training_completed_units
234: ,p_membership_category_o
235: => per_qat_shd.g_old_rec.membership_category

Line 233: => per_qat_shd.g_old_rec.training_completed_units

229: => per_qat_shd.g_old_rec.grade_attained
230: ,p_reimbursement_arrangements_o
231: => per_qat_shd.g_old_rec.reimbursement_arrangements
232: ,p_training_completed_units_o
233: => per_qat_shd.g_old_rec.training_completed_units
234: ,p_membership_category_o
235: => per_qat_shd.g_old_rec.membership_category
236: );
237: --

Line 235: => per_qat_shd.g_old_rec.membership_category

231: => per_qat_shd.g_old_rec.reimbursement_arrangements
232: ,p_training_completed_units_o
233: => per_qat_shd.g_old_rec.training_completed_units
234: ,p_membership_category_o
235: => per_qat_shd.g_old_rec.membership_category
236: );
237: --
238: exception
239: --

Line 295: (p_rec in out nocopy per_qat_shd.g_rec_type

291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure convert_defs
295: (p_rec in out nocopy per_qat_shd.g_rec_type
296: ) is
297: --
298: Begin
299: --

Line 307: per_qat_shd.g_old_rec.source_lang;

303: -- is being used then we must set to the 'current' argument value.
304: --
305: If (p_rec.source_lang = hr_api.g_varchar2) then
306: p_rec.source_lang :=
307: per_qat_shd.g_old_rec.source_lang;
308: End If;
309: If (p_rec.title = hr_api.g_varchar2) then
310: p_rec.title :=
311: per_qat_shd.g_old_rec.title;

Line 311: per_qat_shd.g_old_rec.title;

307: per_qat_shd.g_old_rec.source_lang;
308: End If;
309: If (p_rec.title = hr_api.g_varchar2) then
310: p_rec.title :=
311: per_qat_shd.g_old_rec.title;
312: End If;
313: If (p_rec.group_ranking = hr_api.g_varchar2) then
314: p_rec.group_ranking :=
315: per_qat_shd.g_old_rec.group_ranking;

Line 315: per_qat_shd.g_old_rec.group_ranking;

311: per_qat_shd.g_old_rec.title;
312: End If;
313: If (p_rec.group_ranking = hr_api.g_varchar2) then
314: p_rec.group_ranking :=
315: per_qat_shd.g_old_rec.group_ranking;
316: End If;
317: If (p_rec.license_restrictions = hr_api.g_varchar2) then
318: p_rec.license_restrictions :=
319: per_qat_shd.g_old_rec.license_restrictions;

Line 319: per_qat_shd.g_old_rec.license_restrictions;

315: per_qat_shd.g_old_rec.group_ranking;
316: End If;
317: If (p_rec.license_restrictions = hr_api.g_varchar2) then
318: p_rec.license_restrictions :=
319: per_qat_shd.g_old_rec.license_restrictions;
320: End If;
321: If (p_rec.awarding_body = hr_api.g_varchar2) then
322: p_rec.awarding_body :=
323: per_qat_shd.g_old_rec.awarding_body;

Line 323: per_qat_shd.g_old_rec.awarding_body;

319: per_qat_shd.g_old_rec.license_restrictions;
320: End If;
321: If (p_rec.awarding_body = hr_api.g_varchar2) then
322: p_rec.awarding_body :=
323: per_qat_shd.g_old_rec.awarding_body;
324: End If;
325: If (p_rec.grade_attained = hr_api.g_varchar2) then
326: p_rec.grade_attained :=
327: per_qat_shd.g_old_rec.grade_attained;

Line 327: per_qat_shd.g_old_rec.grade_attained;

323: per_qat_shd.g_old_rec.awarding_body;
324: End If;
325: If (p_rec.grade_attained = hr_api.g_varchar2) then
326: p_rec.grade_attained :=
327: per_qat_shd.g_old_rec.grade_attained;
328: End If;
329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
330: p_rec.reimbursement_arrangements :=
331: per_qat_shd.g_old_rec.reimbursement_arrangements;

Line 331: per_qat_shd.g_old_rec.reimbursement_arrangements;

327: per_qat_shd.g_old_rec.grade_attained;
328: End If;
329: If (p_rec.reimbursement_arrangements = hr_api.g_varchar2) then
330: p_rec.reimbursement_arrangements :=
331: per_qat_shd.g_old_rec.reimbursement_arrangements;
332: End If;
333: If (p_rec.training_completed_units = hr_api.g_varchar2) then
334: p_rec.training_completed_units :=
335: per_qat_shd.g_old_rec.training_completed_units;

Line 335: per_qat_shd.g_old_rec.training_completed_units;

331: per_qat_shd.g_old_rec.reimbursement_arrangements;
332: End If;
333: If (p_rec.training_completed_units = hr_api.g_varchar2) then
334: p_rec.training_completed_units :=
335: per_qat_shd.g_old_rec.training_completed_units;
336: End If;
337: If (p_rec.membership_category = hr_api.g_varchar2) then
338: p_rec.membership_category :=
339: per_qat_shd.g_old_rec.membership_category;

Line 339: per_qat_shd.g_old_rec.membership_category;

335: per_qat_shd.g_old_rec.training_completed_units;
336: End If;
337: If (p_rec.membership_category = hr_api.g_varchar2) then
338: p_rec.membership_category :=
339: per_qat_shd.g_old_rec.membership_category;
340: End If;
341: --
342: End convert_defs;
343: --

Line 348: (p_rec in out nocopy per_qat_shd.g_rec_type

344: -- ----------------------------------------------------------------------------
345: -- |---------------------------------< upd >----------------------------------|
346: -- ----------------------------------------------------------------------------
347: Procedure upd
348: (p_rec in out nocopy per_qat_shd.g_rec_type
349: ) is
350: --
351: l_proc varchar2(72) := g_package||'upd';
352: --

Line 358: per_qat_shd.lck

354: hr_utility.set_location('Entering:'||l_proc, 5);
355: --
356: -- We must lock the row which we need to update.
357: --
358: per_qat_shd.lck
359: (p_rec.qualification_id
360: ,p_rec.language
361: );
362: --

Line 412: l_rec per_qat_shd.g_rec_type;

408: ,p_training_completed_units in varchar2 default hr_api.g_varchar2
409: ,p_membership_category in varchar2 default hr_api.g_varchar2
410: ) is
411: --
412: l_rec per_qat_shd.g_rec_type;
413: l_proc varchar2(72) := g_package||'upd';
414: --
415: Begin
416: hr_utility.set_location('Entering:'||l_proc, 5);

Line 422: per_qat_shd.convert_args

418: -- Call conversion function to turn arguments into the
419: -- l_rec structure.
420: --
421: l_rec :=
422: per_qat_shd.convert_args
423: (p_qualification_id
424: ,p_language
425: ,p_source_lang
426: ,p_title