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.OTA_CTT_UPD dependencies on OTA_CTT_SHD

Line 55: (p_rec in out nocopy ota_ctt_shd.g_rec_type

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

Line 86: ota_ctt_shd.constraint_error

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

Line 91: ota_ctt_shd.constraint_error

87: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
88: When hr_api.parent_integrity_violated Then
89: -- Parent integrity has been violated
90: --
91: ota_ctt_shd.constraint_error
92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --

Line 96: ota_ctt_shd.constraint_error

92: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
93: When hr_api.unique_integrity_violated Then
94: -- Unique integrity has been violated
95: --
96: ota_ctt_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When Others Then
99: --
100: Raise;

Line 136: (p_rec in ota_ctt_shd.g_rec_type

132: --
133: -- {End Of Comments}
134: -- ----------------------------------------------------------------------------
135: Procedure pre_update
136: (p_rec in ota_ctt_shd.g_rec_type
137: ) is
138: --
139: l_proc varchar2(72) := g_package||'pre_update';
140: --

Line 181: ,p_rec in ota_ctt_shd.g_rec_type

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

Line 203: => ota_ctt_shd.g_old_rec.source_lang

199: => p_rec.category
200: ,p_description
201: => p_rec.description
202: ,p_source_lang_o
203: => ota_ctt_shd.g_old_rec.source_lang
204: ,p_category_o
205: => ota_ctt_shd.g_old_rec.category
206: ,p_description_o
207: => ota_ctt_shd.g_old_rec.description

Line 205: => ota_ctt_shd.g_old_rec.category

201: => p_rec.description
202: ,p_source_lang_o
203: => ota_ctt_shd.g_old_rec.source_lang
204: ,p_category_o
205: => ota_ctt_shd.g_old_rec.category
206: ,p_description_o
207: => ota_ctt_shd.g_old_rec.description
208: );
209: --

Line 207: => ota_ctt_shd.g_old_rec.description

203: => ota_ctt_shd.g_old_rec.source_lang
204: ,p_category_o
205: => ota_ctt_shd.g_old_rec.category
206: ,p_description_o
207: => ota_ctt_shd.g_old_rec.description
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy ota_ctt_shd.g_rec_type

263: --
264: -- {End Of Comments}
265: -- ----------------------------------------------------------------------------
266: Procedure convert_defs
267: (p_rec in out nocopy ota_ctt_shd.g_rec_type
268: ) is
269: --
270: Begin
271: --

Line 279: ota_ctt_shd.g_old_rec.source_lang;

275: -- is being used then we must set to the 'current' argument value.
276: --
277: If (p_rec.source_lang = hr_api.g_varchar2) then
278: p_rec.source_lang :=
279: ota_ctt_shd.g_old_rec.source_lang;
280: End If;
281: If (p_rec.category = hr_api.g_varchar2) then
282: p_rec.category :=
283: ota_ctt_shd.g_old_rec.category;

Line 283: ota_ctt_shd.g_old_rec.category;

279: ota_ctt_shd.g_old_rec.source_lang;
280: End If;
281: If (p_rec.category = hr_api.g_varchar2) then
282: p_rec.category :=
283: ota_ctt_shd.g_old_rec.category;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ota_ctt_shd.g_old_rec.description;

Line 287: ota_ctt_shd.g_old_rec.description;

283: ota_ctt_shd.g_old_rec.category;
284: End If;
285: If (p_rec.description = hr_api.g_varchar2) then
286: p_rec.description :=
287: ota_ctt_shd.g_old_rec.description;
288: End If;
289: --
290: End convert_defs;
291: --

Line 297: ,p_rec in out nocopy ota_ctt_shd.g_rec_type

293: -- |---------------------------------< upd >----------------------------------|
294: -- ----------------------------------------------------------------------------
295: Procedure upd
296: (p_effective_date in date
297: ,p_rec in out nocopy ota_ctt_shd.g_rec_type
298: ) is
299: --
300: l_proc varchar2(72) := g_package||'upd';
301: --

Line 307: ota_ctt_shd.lck

303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- We must lock the row which we need to update.
306: --
307: ota_ctt_shd.lck
308: (p_rec.category_usage_id
309: ,p_rec.language
310: );
311: --

Line 358: l_rec ota_ctt_shd.g_rec_type;

354: ,p_category in varchar2 default hr_api.g_varchar2
355: ,p_description in varchar2 default hr_api.g_varchar2
356: ) is
357: --
358: l_rec ota_ctt_shd.g_rec_type;
359: l_proc varchar2(72) := g_package||'upd';
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);

Line 368: ota_ctt_shd.convert_args

364: -- Call conversion function to turn arguments into the
365: -- l_rec structure.
366: --
367: l_rec :=
368: ota_ctt_shd.convert_args
369: (p_category_usage_id
370: ,p_language
371: ,p_source_lang
372: ,p_category