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_SRT_UPD dependencies on OTA_SRT_SHD

Line 55: (p_rec in out nocopy ota_srt_shd.g_rec_type

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

Line 86: ota_srt_shd.constraint_error

82: Exception
83: When hr_api.check_integrity_violated Then
84: -- A check constraint has been violated
85: --
86: ota_srt_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_srt_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_srt_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_srt_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_srt_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_srt_shd.g_rec_type

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

Line 181: ,p_rec in ota_srt_shd.g_rec_type

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

Line 203: => ota_srt_shd.g_old_rec.name

199: => p_rec.special_instruction
200: ,p_source_lang
201: => p_rec.source_lang
202: ,p_name_o
203: => ota_srt_shd.g_old_rec.name
204: ,p_special_instruction_o
205: => ota_srt_shd.g_old_rec.special_instruction
206: ,p_source_lang_o
207: => ota_srt_shd.g_old_rec.source_lang

Line 205: => ota_srt_shd.g_old_rec.special_instruction

201: => p_rec.source_lang
202: ,p_name_o
203: => ota_srt_shd.g_old_rec.name
204: ,p_special_instruction_o
205: => ota_srt_shd.g_old_rec.special_instruction
206: ,p_source_lang_o
207: => ota_srt_shd.g_old_rec.source_lang
208: );
209: --

Line 207: => ota_srt_shd.g_old_rec.source_lang

203: => ota_srt_shd.g_old_rec.name
204: ,p_special_instruction_o
205: => ota_srt_shd.g_old_rec.special_instruction
206: ,p_source_lang_o
207: => ota_srt_shd.g_old_rec.source_lang
208: );
209: --
210: exception
211: --

Line 267: (p_rec in out nocopy ota_srt_shd.g_rec_type

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

Line 279: ota_srt_shd.g_old_rec.name;

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

Line 283: ota_srt_shd.g_old_rec.special_instruction;

279: ota_srt_shd.g_old_rec.name;
280: End If;
281: If (p_rec.special_instruction = hr_api.g_varchar2) then
282: p_rec.special_instruction :=
283: ota_srt_shd.g_old_rec.special_instruction;
284: End If;
285: If (p_rec.source_lang = hr_api.g_varchar2) then
286: p_rec.source_lang :=
287: ota_srt_shd.g_old_rec.source_lang;

Line 287: ota_srt_shd.g_old_rec.source_lang;

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

Line 297: ,p_rec in out nocopy ota_srt_shd.g_rec_type

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

Line 307: ota_srt_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_srt_shd.lck
308: (p_rec.supplied_resource_id
309: ,p_rec.language
310: );
311: --

Line 358: l_rec ota_srt_shd.g_rec_type;

354: ,p_name in varchar2 default hr_api.g_varchar2
355: ,p_special_instruction in varchar2 default hr_api.g_varchar2
356: ) is
357: --
358: l_rec ota_srt_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_srt_shd.convert_args

364: -- Call conversion function to turn arguments into the
365: -- l_rec structure.
366: --
367: l_rec :=
368: ota_srt_shd.convert_args
369: (p_supplied_resource_id
370: ,p_language
371: ,p_name
372: ,p_special_instruction

Line 460: l_srt_rec ota_srt_shd.g_rec_type;

456:
457: --
458: l_userenv_language_code FND_LANGUAGES.LANGUAGE_CODE%TYPE := userenv('LANG');
459: --
460: l_srt_rec ota_srt_shd.g_rec_type;
461: --
462: l_proc varchar2(72) := g_package||'upd_key_flex_meanings';
463: --
464: Begin

Line 472: ota_srt_shd.lck( p_supplied_resource_id => p_supplied_resource_id

468: For l_language IN csr_languages Loop
469: --
470: -- Lock the existing record (which may already be updated)
471: --
472: ota_srt_shd.lck( p_supplied_resource_id => p_supplied_resource_id
473: , p_language => l_language.language_code);
474: --
475: -- Get the local record values from the locked record
476: --

Line 477: l_srt_rec := ota_srt_shd.g_old_rec;

473: , p_language => l_language.language_code);
474: --
475: -- Get the local record values from the locked record
476: --
477: l_srt_rec := ota_srt_shd.g_old_rec;
478:
479: --
480: -- Set the session language
481: --

Line 487: l_srt_rec.name := fnd_flex_ext.get_segs(ota_srt_shd.g_app_code

483:
484: --
485: --Populate the local record with translated key flex meanings
486: --
487: l_srt_rec.name := fnd_flex_ext.get_segs(ota_srt_shd.g_app_code
488: , ota_srt_shd.g_flex_code
489: , l_language.id_flex_num
490: , l_language.resource_definition_id);
491: --

Line 488: , ota_srt_shd.g_flex_code

484: --
485: --Populate the local record with translated key flex meanings
486: --
487: l_srt_rec.name := fnd_flex_ext.get_segs(ota_srt_shd.g_app_code
488: , ota_srt_shd.g_flex_code
489: , l_language.id_flex_num
490: , l_language.resource_definition_id);
491: --
492: --Update the record