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_DEL dependencies on PER_QAT_SHD

Line 52: (p_rec in per_qat_shd.g_rec_type

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

Line 76: per_qat_shd.constraint_error

72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: per_qat_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;

Line 115: Procedure pre_delete(p_rec in per_qat_shd.g_rec_type) is

111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in per_qat_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin

Line 157: Procedure post_delete(p_rec in per_qat_shd.g_rec_type) is

153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in per_qat_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin

Line 171: => per_qat_shd.g_old_rec.source_lang

167: => p_rec.qualification_id
168: ,p_language
169: => p_rec.language
170: ,p_source_lang_o
171: => per_qat_shd.g_old_rec.source_lang
172: ,p_title_o
173: => per_qat_shd.g_old_rec.title
174: ,p_group_ranking_o
175: => per_qat_shd.g_old_rec.group_ranking

Line 173: => per_qat_shd.g_old_rec.title

169: => p_rec.language
170: ,p_source_lang_o
171: => per_qat_shd.g_old_rec.source_lang
172: ,p_title_o
173: => per_qat_shd.g_old_rec.title
174: ,p_group_ranking_o
175: => per_qat_shd.g_old_rec.group_ranking
176: ,p_license_restrictions_o
177: => per_qat_shd.g_old_rec.license_restrictions

Line 175: => per_qat_shd.g_old_rec.group_ranking

171: => per_qat_shd.g_old_rec.source_lang
172: ,p_title_o
173: => per_qat_shd.g_old_rec.title
174: ,p_group_ranking_o
175: => per_qat_shd.g_old_rec.group_ranking
176: ,p_license_restrictions_o
177: => per_qat_shd.g_old_rec.license_restrictions
178: ,p_awarding_body_o
179: => per_qat_shd.g_old_rec.awarding_body

Line 177: => per_qat_shd.g_old_rec.license_restrictions

173: => per_qat_shd.g_old_rec.title
174: ,p_group_ranking_o
175: => per_qat_shd.g_old_rec.group_ranking
176: ,p_license_restrictions_o
177: => per_qat_shd.g_old_rec.license_restrictions
178: ,p_awarding_body_o
179: => per_qat_shd.g_old_rec.awarding_body
180: ,p_grade_attained_o
181: => per_qat_shd.g_old_rec.grade_attained

Line 179: => per_qat_shd.g_old_rec.awarding_body

175: => per_qat_shd.g_old_rec.group_ranking
176: ,p_license_restrictions_o
177: => per_qat_shd.g_old_rec.license_restrictions
178: ,p_awarding_body_o
179: => per_qat_shd.g_old_rec.awarding_body
180: ,p_grade_attained_o
181: => per_qat_shd.g_old_rec.grade_attained
182: ,p_reimbursement_arrangements_o
183: => per_qat_shd.g_old_rec.reimbursement_arrangements

Line 181: => per_qat_shd.g_old_rec.grade_attained

177: => per_qat_shd.g_old_rec.license_restrictions
178: ,p_awarding_body_o
179: => per_qat_shd.g_old_rec.awarding_body
180: ,p_grade_attained_o
181: => per_qat_shd.g_old_rec.grade_attained
182: ,p_reimbursement_arrangements_o
183: => per_qat_shd.g_old_rec.reimbursement_arrangements
184: ,p_training_completed_units_o
185: => per_qat_shd.g_old_rec.training_completed_units

Line 183: => per_qat_shd.g_old_rec.reimbursement_arrangements

179: => per_qat_shd.g_old_rec.awarding_body
180: ,p_grade_attained_o
181: => per_qat_shd.g_old_rec.grade_attained
182: ,p_reimbursement_arrangements_o
183: => per_qat_shd.g_old_rec.reimbursement_arrangements
184: ,p_training_completed_units_o
185: => per_qat_shd.g_old_rec.training_completed_units
186: ,p_membership_category_o
187: => per_qat_shd.g_old_rec.membership_category

Line 185: => per_qat_shd.g_old_rec.training_completed_units

181: => per_qat_shd.g_old_rec.grade_attained
182: ,p_reimbursement_arrangements_o
183: => per_qat_shd.g_old_rec.reimbursement_arrangements
184: ,p_training_completed_units_o
185: => per_qat_shd.g_old_rec.training_completed_units
186: ,p_membership_category_o
187: => per_qat_shd.g_old_rec.membership_category
188: );
189:

Line 187: => per_qat_shd.g_old_rec.membership_category

183: => per_qat_shd.g_old_rec.reimbursement_arrangements
184: ,p_training_completed_units_o
185: => per_qat_shd.g_old_rec.training_completed_units
186: ,p_membership_category_o
187: => per_qat_shd.g_old_rec.membership_category
188: );
189:
190: exception
191: --

Line 207: (p_rec in per_qat_shd.g_rec_type

203: -- ----------------------------------------------------------------------------
204: -- |---------------------------------< del >----------------------------------|
205: -- ----------------------------------------------------------------------------
206: Procedure del
207: (p_rec in per_qat_shd.g_rec_type
208: ) is
209: --
210: l_proc varchar2(72) := g_package||'del';
211: --

Line 217: per_qat_shd.lck

213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: -- We must lock the row which we need to delete.
216: --
217: per_qat_shd.lck
218: (p_rec.qualification_id
219: ,p_rec.language
220: );
221: --

Line 254: l_rec per_qat_shd.g_rec_type;

250: (p_qualification_id in number
251: ,p_language in varchar2
252: ) is
253: --
254: l_rec per_qat_shd.g_rec_type;
255: l_proc varchar2(72) := g_package||'del';
256: --
257: Begin
258: hr_utility.set_location('Entering:'||l_proc, 5);