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_AVT_UPD dependencies on OTA_AVT_SHD

Line 55: (p_rec in out nocopy ota_avt_shd.g_rec_type

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

Line 89: ota_avt_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: --
89: ota_avt_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: ota_avt_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: ota_avt_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: ota_avt_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: ota_avt_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 ota_avt_shd.g_rec_type

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

Line 184: ,p_rec in ota_avt_shd.g_rec_type

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

Line 212: => ota_avt_shd.g_old_rec.source_lang

208: => p_rec.objectives
209: ,p_keywords
210: => p_rec.keywords
211: ,p_source_lang_o
212: => ota_avt_shd.g_old_rec.source_lang
213: ,p_version_name_o
214: => ota_avt_shd.g_old_rec.version_name
215: ,p_description_o
216: => ota_avt_shd.g_old_rec.description

Line 214: => ota_avt_shd.g_old_rec.version_name

210: => p_rec.keywords
211: ,p_source_lang_o
212: => ota_avt_shd.g_old_rec.source_lang
213: ,p_version_name_o
214: => ota_avt_shd.g_old_rec.version_name
215: ,p_description_o
216: => ota_avt_shd.g_old_rec.description
217: ,p_intended_audience_o
218: => ota_avt_shd.g_old_rec.intended_audience

Line 216: => ota_avt_shd.g_old_rec.description

212: => ota_avt_shd.g_old_rec.source_lang
213: ,p_version_name_o
214: => ota_avt_shd.g_old_rec.version_name
215: ,p_description_o
216: => ota_avt_shd.g_old_rec.description
217: ,p_intended_audience_o
218: => ota_avt_shd.g_old_rec.intended_audience
219: ,p_objectives_o
220: => ota_avt_shd.g_old_rec.objectives

Line 218: => ota_avt_shd.g_old_rec.intended_audience

214: => ota_avt_shd.g_old_rec.version_name
215: ,p_description_o
216: => ota_avt_shd.g_old_rec.description
217: ,p_intended_audience_o
218: => ota_avt_shd.g_old_rec.intended_audience
219: ,p_objectives_o
220: => ota_avt_shd.g_old_rec.objectives
221: ,p_keywords_o
222: => ota_avt_shd.g_old_rec.keywords

Line 220: => ota_avt_shd.g_old_rec.objectives

216: => ota_avt_shd.g_old_rec.description
217: ,p_intended_audience_o
218: => ota_avt_shd.g_old_rec.intended_audience
219: ,p_objectives_o
220: => ota_avt_shd.g_old_rec.objectives
221: ,p_keywords_o
222: => ota_avt_shd.g_old_rec.keywords
223: );
224: --

Line 222: => ota_avt_shd.g_old_rec.keywords

218: => ota_avt_shd.g_old_rec.intended_audience
219: ,p_objectives_o
220: => ota_avt_shd.g_old_rec.objectives
221: ,p_keywords_o
222: => ota_avt_shd.g_old_rec.keywords
223: );
224: --
225: exception
226: --

Line 282: (p_rec in out nocopy ota_avt_shd.g_rec_type

278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure convert_defs
282: (p_rec in out nocopy ota_avt_shd.g_rec_type
283: ) is
284: --
285: Begin
286: --

Line 294: ota_avt_shd.g_old_rec.source_lang;

290: -- is being used then we must set to the 'current' argument value.
291: --
292: If (p_rec.source_lang = hr_api.g_varchar2) then
293: p_rec.source_lang :=
294: ota_avt_shd.g_old_rec.source_lang;
295: End If;
296: If (p_rec.version_name = hr_api.g_varchar2) then
297: p_rec.version_name :=
298: ota_avt_shd.g_old_rec.version_name;

Line 298: ota_avt_shd.g_old_rec.version_name;

294: ota_avt_shd.g_old_rec.source_lang;
295: End If;
296: If (p_rec.version_name = hr_api.g_varchar2) then
297: p_rec.version_name :=
298: ota_avt_shd.g_old_rec.version_name;
299: End If;
300: If (p_rec.description = hr_api.g_varchar2) then
301: p_rec.description :=
302: ota_avt_shd.g_old_rec.description;

Line 302: ota_avt_shd.g_old_rec.description;

298: ota_avt_shd.g_old_rec.version_name;
299: End If;
300: If (p_rec.description = hr_api.g_varchar2) then
301: p_rec.description :=
302: ota_avt_shd.g_old_rec.description;
303: End If;
304: If (p_rec.intended_audience = hr_api.g_varchar2) then
305: p_rec.intended_audience :=
306: ota_avt_shd.g_old_rec.intended_audience;

Line 306: ota_avt_shd.g_old_rec.intended_audience;

302: ota_avt_shd.g_old_rec.description;
303: End If;
304: If (p_rec.intended_audience = hr_api.g_varchar2) then
305: p_rec.intended_audience :=
306: ota_avt_shd.g_old_rec.intended_audience;
307: End If;
308: If (p_rec.objectives = hr_api.g_varchar2) then
309: p_rec.objectives :=
310: ota_avt_shd.g_old_rec.objectives;

Line 310: ota_avt_shd.g_old_rec.objectives;

306: ota_avt_shd.g_old_rec.intended_audience;
307: End If;
308: If (p_rec.objectives = hr_api.g_varchar2) then
309: p_rec.objectives :=
310: ota_avt_shd.g_old_rec.objectives;
311: End If;
312: If (p_rec.keywords = hr_api.g_varchar2) then
313: p_rec.keywords :=
314: ota_avt_shd.g_old_rec.keywords;

Line 314: ota_avt_shd.g_old_rec.keywords;

310: ota_avt_shd.g_old_rec.objectives;
311: End If;
312: If (p_rec.keywords = hr_api.g_varchar2) then
313: p_rec.keywords :=
314: ota_avt_shd.g_old_rec.keywords;
315: End If;
316: --
317: End convert_defs;
318: --

Line 324: ,p_rec in out nocopy ota_avt_shd.g_rec_type

320: -- |---------------------------------< upd >----------------------------------|
321: -- ----------------------------------------------------------------------------
322: Procedure upd
323: (p_effective_date in date
324: ,p_rec in out nocopy ota_avt_shd.g_rec_type
325: ) is
326: --
327: l_proc varchar2(72) := g_package||'upd';
328: --

Line 334: ota_avt_shd.lck

330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: -- We must lock the row which we need to update.
333: --
334: ota_avt_shd.lck
335: (p_rec.activity_version_id
336: ,p_rec.language
337: );
338: --

Line 388: l_rec ota_avt_shd.g_rec_type;

384: ,p_objectives in varchar2 default hr_api.g_varchar2
385: ,p_keywords in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec ota_avt_shd.g_rec_type;
389: l_proc varchar2(72) := g_package||'upd';
390: --
391: Begin
392: hr_utility.set_location('Entering:'||l_proc, 5);

Line 398: ota_avt_shd.convert_args

394: -- Call conversion function to turn arguments into the
395: -- l_rec structure.
396: --
397: l_rec :=
398: ota_avt_shd.convert_args
399: (p_activity_version_id
400: ,p_language
401: ,p_source_lang
402: ,p_version_name