DBA Data[Home] [Help]

APPS.PQP_ERT_DEL dependencies on PQP_EXCEPTION_REPORTS_TL

Line 62: -- Delete the pqp_exception_reports_tl row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: pqp_ert_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqp_exception_reports_tl row.
63: --
64: delete from pqp_exception_reports_tl
65: where exception_report_id = p_rec.exception_report_id
66: and language = p_rec.language;

Line 64: delete from pqp_exception_reports_tl

60: pqp_ert_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the pqp_exception_reports_tl row.
63: --
64: delete from pqp_exception_reports_tl
65: where exception_report_id = p_rec.exception_report_id
66: and language = p_rec.language;
67: --
68: pqp_ert_shd.g_api_dml := false; -- Unset the api dml status

Line 181: (p_module_name => 'PQP_EXCEPTION_REPORTS_TL'

177: --
178: when hr_api.cannot_find_prog_unit then
179: --
180: hr_api.cannot_find_prog_unit_error
181: (p_module_name => 'PQP_EXCEPTION_REPORTS_TL'
182: ,p_hook_type => 'AD');
183: --
184: end;
185: --

Line 268: from pqp_exception_reports_tl ert

264: -- Cursor to obtain all the translation rows.
265: --
266: cursor csr_del_langs is
267: select ert.language
268: from pqp_exception_reports_tl ert
269: where ert.exception_report_id = p_exception_report_id;
270: --
271: l_proc varchar2(72) := g_package||'del_tl';
272: --