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.PQP_ERT_UPD dependencies on PQP_ERT_SHD

Line 55: (p_rec in out nocopy pqp_ert_shd.g_rec_type

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

Line 65: pqp_ert_shd.g_api_dml := true; -- Set the api dml status

61: hr_utility.set_location('Entering:'||l_proc, 5);
62: --
63: -- Increment the object version
64: --
65: pqp_ert_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the pqp_exception_reports_tl Row
68: --
69:

Line 99: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

95: END IF;
96:
97:
98: --
99: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 10);
102: --
103: Exception

Line 106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

102: --
103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated

Line 107: pqp_ert_shd.constraint_error

103: Exception
104: When hr_api.check_integrity_violated Then
105: -- A check constraint has been violated
106: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

107: pqp_ert_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated

Line 112: pqp_ert_shd.constraint_error

108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.parent_integrity_violated Then
110: -- Parent integrity has been violated
111: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

112: pqp_ert_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 117: pqp_ert_shd.constraint_error

113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.unique_integrity_violated Then
115: -- Unique integrity has been violated
116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;

Line 120: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

116: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
117: pqp_ert_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When Others Then
120: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status
121: Raise;
122: End update_dml;
123: --
124: -- ----------------------------------------------------------------------------

Line 157: (p_rec in pqp_ert_shd.g_rec_type

153: --
154: -- {End Of Comments}
155: -- ----------------------------------------------------------------------------
156: Procedure pre_update
157: (p_rec in pqp_ert_shd.g_rec_type
158: ) is
159: --
160: l_proc varchar2(72) := g_package||'pre_update';
161: --

Line 201: (p_rec in pqp_ert_shd.g_rec_type

197: --
198: -- {End Of Comments}
199: -- ----------------------------------------------------------------------------
200: Procedure post_update
201: (p_rec in pqp_ert_shd.g_rec_type
202: ) is
203: --
204: l_proc varchar2(72) := g_package||'post_update';
205: --

Line 220: => pqp_ert_shd.g_old_rec.exception_report_name

216: => p_rec.language
217: ,p_source_lang
218: => p_rec.source_lang
219: ,p_exception_report_name_o
220: => pqp_ert_shd.g_old_rec.exception_report_name
221: ,p_source_lang_o
222: => pqp_ert_shd.g_old_rec.source_lang
223: );
224: --

Line 222: => pqp_ert_shd.g_old_rec.source_lang

218: => p_rec.source_lang
219: ,p_exception_report_name_o
220: => pqp_ert_shd.g_old_rec.exception_report_name
221: ,p_source_lang_o
222: => pqp_ert_shd.g_old_rec.source_lang
223: );
224: --
225: exception
226: --

Line 282: (p_rec in out nocopy pqp_ert_shd.g_rec_type

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

Line 294: pqp_ert_shd.g_old_rec.exception_report_name;

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

Line 298: pqp_ert_shd.g_old_rec.source_lang;

294: pqp_ert_shd.g_old_rec.exception_report_name;
295: End If;
296: If (p_rec.source_lang = hr_api.g_varchar2) then
297: p_rec.source_lang :=
298: pqp_ert_shd.g_old_rec.source_lang;
299: End If;
300: --
301: End convert_defs;
302: --

Line 307: (p_rec in out nocopy pqp_ert_shd.g_rec_type

303: -- ----------------------------------------------------------------------------
304: -- |---------------------------------< upd >----------------------------------|
305: -- ----------------------------------------------------------------------------
306: Procedure upd
307: (p_rec in out nocopy pqp_ert_shd.g_rec_type
308: ) is
309: --
310: l_proc varchar2(72) := g_package||'upd';
311: --

Line 317: pqp_ert_shd.lck

313: hr_utility.set_location('Entering:'||l_proc, 5);
314: --
315: -- We must lock the row which we need to update.
316: --
317: pqp_ert_shd.lck
318: (p_rec.exception_report_id
319: ,p_rec.language
320: );
321: --

Line 358: l_rec pqp_ert_shd.g_rec_type;

354: ,p_language in varchar2
355: ,p_source_lang in varchar2 default hr_api.g_varchar2
356: ) is
357: --
358: l_rec pqp_ert_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: pqp_ert_shd.convert_args

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