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_LPT_UPD dependencies on OTA_LPT_SHD

Line 55: (p_rec in out nocopy ota_lpt_shd.g_rec_type

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

Line 89: ota_lpt_shd.constraint_error

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

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

Line 184: ,p_rec in ota_lpt_shd.g_rec_type

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

Line 212: => ota_lpt_shd.g_old_rec.name

208: => p_rec.keywords
209: ,p_source_lang
210: => p_rec.source_lang
211: ,p_name_o
212: => ota_lpt_shd.g_old_rec.name
213: ,p_description_o
214: => ota_lpt_shd.g_old_rec.description
215: ,p_objectives_o
216: => ota_lpt_shd.g_old_rec.objectives

Line 214: => ota_lpt_shd.g_old_rec.description

210: => p_rec.source_lang
211: ,p_name_o
212: => ota_lpt_shd.g_old_rec.name
213: ,p_description_o
214: => ota_lpt_shd.g_old_rec.description
215: ,p_objectives_o
216: => ota_lpt_shd.g_old_rec.objectives
217: ,p_purpose_o
218: => ota_lpt_shd.g_old_rec.purpose

Line 216: => ota_lpt_shd.g_old_rec.objectives

212: => ota_lpt_shd.g_old_rec.name
213: ,p_description_o
214: => ota_lpt_shd.g_old_rec.description
215: ,p_objectives_o
216: => ota_lpt_shd.g_old_rec.objectives
217: ,p_purpose_o
218: => ota_lpt_shd.g_old_rec.purpose
219: ,p_keywords_o
220: => ota_lpt_shd.g_old_rec.keywords

Line 218: => ota_lpt_shd.g_old_rec.purpose

214: => ota_lpt_shd.g_old_rec.description
215: ,p_objectives_o
216: => ota_lpt_shd.g_old_rec.objectives
217: ,p_purpose_o
218: => ota_lpt_shd.g_old_rec.purpose
219: ,p_keywords_o
220: => ota_lpt_shd.g_old_rec.keywords
221: ,p_source_lang_o
222: => ota_lpt_shd.g_old_rec.source_lang

Line 220: => ota_lpt_shd.g_old_rec.keywords

216: => ota_lpt_shd.g_old_rec.objectives
217: ,p_purpose_o
218: => ota_lpt_shd.g_old_rec.purpose
219: ,p_keywords_o
220: => ota_lpt_shd.g_old_rec.keywords
221: ,p_source_lang_o
222: => ota_lpt_shd.g_old_rec.source_lang
223: );
224: --

Line 222: => ota_lpt_shd.g_old_rec.source_lang

218: => ota_lpt_shd.g_old_rec.purpose
219: ,p_keywords_o
220: => ota_lpt_shd.g_old_rec.keywords
221: ,p_source_lang_o
222: => ota_lpt_shd.g_old_rec.source_lang
223: );
224: --
225: exception
226: --

Line 282: (p_rec in out nocopy ota_lpt_shd.g_rec_type

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

Line 294: ota_lpt_shd.g_old_rec.name;

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

Line 298: ota_lpt_shd.g_old_rec.description;

294: ota_lpt_shd.g_old_rec.name;
295: End If;
296: If (p_rec.description = hr_api.g_varchar2) then
297: p_rec.description :=
298: ota_lpt_shd.g_old_rec.description;
299: End If;
300: If (p_rec.objectives = hr_api.g_varchar2) then
301: p_rec.objectives :=
302: ota_lpt_shd.g_old_rec.objectives;

Line 302: ota_lpt_shd.g_old_rec.objectives;

298: ota_lpt_shd.g_old_rec.description;
299: End If;
300: If (p_rec.objectives = hr_api.g_varchar2) then
301: p_rec.objectives :=
302: ota_lpt_shd.g_old_rec.objectives;
303: End If;
304: If (p_rec.purpose = hr_api.g_varchar2) then
305: p_rec.purpose :=
306: ota_lpt_shd.g_old_rec.purpose;

Line 306: ota_lpt_shd.g_old_rec.purpose;

302: ota_lpt_shd.g_old_rec.objectives;
303: End If;
304: If (p_rec.purpose = hr_api.g_varchar2) then
305: p_rec.purpose :=
306: ota_lpt_shd.g_old_rec.purpose;
307: End If;
308: If (p_rec.keywords = hr_api.g_varchar2) then
309: p_rec.keywords :=
310: ota_lpt_shd.g_old_rec.keywords;

Line 310: ota_lpt_shd.g_old_rec.keywords;

306: ota_lpt_shd.g_old_rec.purpose;
307: End If;
308: If (p_rec.keywords = hr_api.g_varchar2) then
309: p_rec.keywords :=
310: ota_lpt_shd.g_old_rec.keywords;
311: End If;
312: If (p_rec.source_lang = hr_api.g_varchar2) then
313: p_rec.source_lang :=
314: ota_lpt_shd.g_old_rec.source_lang;

Line 314: ota_lpt_shd.g_old_rec.source_lang;

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

Line 324: ,p_rec in out nocopy ota_lpt_shd.g_rec_type

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

Line 334: ota_lpt_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_lpt_shd.lck
335: (p_rec.learning_path_id
336: ,p_rec.language
337: );
338: --

Line 388: l_rec ota_lpt_shd.g_rec_type;

384: ,p_keywords in varchar2 default hr_api.g_varchar2
385: ,p_source_lang in varchar2 default hr_api.g_varchar2
386: ) is
387: --
388: l_rec ota_lpt_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_lpt_shd.convert_args

394: -- Call conversion function to turn arguments into the
395: -- l_rec structure.
396: --
397: l_rec :=
398: ota_lpt_shd.convert_args
399: (p_learning_path_id
400: ,p_language
401: ,p_name
402: ,p_description