APPS.PQP_ERT_SHD dependencies on PQP_EXCEPTION_REPORTS

Line 63: from pqp_exception_reports_tl

59: exception_report_id
60: ,exception_report_name
61: ,language
62: ,source_lang
63: from pqp_exception_reports_tl
64: where exception_report_id = p_exception_report_id
65: and language = p_language;
66: --
67: l_fct_ret boolean;

Line 128: from pqp_exception_reports_tl

124: exception_report_id
125: ,exception_report_name
126: ,language
127: ,source_lang
128: from pqp_exception_reports_tl
129: where exception_report_id = p_exception_report_id
130: and language = p_language
131: for update nowait;
132: --

Line 174: fnd_message.set_token('TABLE_NAME', 'pqp_exception_reports_tl');

170: -- The object is locked therefore we need to supply a meaningful
171: -- error message.
172: --
173: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
174: fnd_message.set_token('TABLE_NAME', 'pqp_exception_reports_tl');
175: fnd_message.raise_error;
176: End lck;
177: --
178: -- ----------------------------------------------------------------------------

Line 184: delete from PQP_EXCEPTION_REPORTS_TL T

180: -- ----------------------------------------------------------------------------
181: procedure ADD_LANGUAGE
182: is
183: begin
184: delete from PQP_EXCEPTION_REPORTS_TL T
185: where not exists
186: (select NULL
187: from PQP_EXCEPTION_REPORTS B
188: where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID

Line 187: from PQP_EXCEPTION_REPORTS B

183: begin
184: delete from PQP_EXCEPTION_REPORTS_TL T
185: where not exists
186: (select NULL
187: from PQP_EXCEPTION_REPORTS B
188: where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID
189: );
190:
191: update PQP_EXCEPTION_REPORTS_TL T set (

Line 191: update PQP_EXCEPTION_REPORTS_TL T set (

187: from PQP_EXCEPTION_REPORTS B
188: where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID
189: );
190:
191: update PQP_EXCEPTION_REPORTS_TL T set (
192: EXCEPTION_REPORT_NAME
193: ) = (select
194: B.EXCEPTION_REPORT_NAME
195: from PQP_EXCEPTION_REPORTS_TL B

Line 195: from PQP_EXCEPTION_REPORTS_TL B

191: update PQP_EXCEPTION_REPORTS_TL T set (
192: EXCEPTION_REPORT_NAME
193: ) = (select
194: B.EXCEPTION_REPORT_NAME
195: from PQP_EXCEPTION_REPORTS_TL B
196: where B.EXCEPTION_REPORT_ID = T.EXCEPTION_REPORT_ID
197: and B.LANGUAGE = T.SOURCE_LANG)
198: where (
199: T.EXCEPTION_REPORT_ID,

Line 204: from PQP_EXCEPTION_REPORTS_TL SUBB, PQP_EXCEPTION_REPORTS_TL SUBT

200: T.LANGUAGE
201: ) in (select
202: SUBT.EXCEPTION_REPORT_ID,
203: SUBT.LANGUAGE
204: from PQP_EXCEPTION_REPORTS_TL SUBB, PQP_EXCEPTION_REPORTS_TL SUBT
205: where SUBB.EXCEPTION_REPORT_ID = SUBT.EXCEPTION_REPORT_ID
206: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
207: and (SUBB.EXCEPTION_REPORT_NAME <> SUBT.EXCEPTION_REPORT_NAME
208: ));

Line 211: insert into PQP_EXCEPTION_REPORTS_TL (

207: and (SUBB.EXCEPTION_REPORT_NAME <> SUBT.EXCEPTION_REPORT_NAME
208: ));
209:
210:
211: insert into PQP_EXCEPTION_REPORTS_TL (
212: EXCEPTION_REPORT_ID,
213: EXCEPTION_REPORT_NAME,
214: LAST_UPDATED_BY,
215: LAST_UPDATE_DATE,

Line 233: from PQP_EXCEPTION_REPORTS_TL B, FND_LANGUAGES L

229: B.CREATION_DATE,
230: -- B.OBJECT_VERSION_NUMBER,
231: L.LANGUAGE_CODE,
232: B.SOURCE_LANG
233: from PQP_EXCEPTION_REPORTS_TL B, FND_LANGUAGES L
234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL

Line 238: from PQP_EXCEPTION_REPORTS_TL T

234: where L.INSTALLED_FLAG in ('I', 'B')
235: and B.LANGUAGE = userenv('LANG')
236: and not exists
237: (select NULL
238: from PQP_EXCEPTION_REPORTS_TL T
239: where T.EXCEPTION_REPORT_ID = B.EXCEPTION_REPORT_ID
240: and T.LANGUAGE = L.LANGUAGE_CODE);
241: end ADD_LANGUAGE;
242: --