APPS.QPR_REPORT_HDRS_PKG dependencies on QPR_REPORT_HDRS_TL

Line 58: insert into QPR_REPORT_HDRS_TL (

54: X_LAST_UPDATED_BY,
55: X_LAST_UPDATE_LOGIN
56: );
57:
58: insert into QPR_REPORT_HDRS_TL (
59: REPORT_HEADER_ID,
60: REPORT_NAME,
61: REPORT_TITLE,
62: CREATION_DATE,

Line 92: from QPR_REPORT_HDRS_TL T

88: from FND_LANGUAGES L
89: where L.INSTALLED_FLAG in ('I', 'B')
90: and not exists
91: (select NULL
92: from QPR_REPORT_HDRS_TL T
93: where T.REPORT_HEADER_ID = X_REPORT_HEADER_ID
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95:
96: open c;

Line 137: from QPR_REPORT_HDRS_TL

133: cursor c1 is select
134: REPORT_NAME,
135: REPORT_TITLE,
136: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
137: from QPR_REPORT_HDRS_TL
138: where REPORT_HEADER_ID = X_REPORT_HEADER_ID
139: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
140: for update of REPORT_HEADER_ID nowait;
141: begin

Line 225: update QPR_REPORT_HDRS_TL set

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: update QPR_REPORT_HDRS_TL set
226: REPORT_NAME = X_REPORT_NAME,
227: REPORT_TITLE = X_REPORT_TITLE,
228: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
229: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 244: delete from QPR_REPORT_HDRS_TL

240: procedure DELETE_ROW (
241: X_REPORT_HEADER_ID in NUMBER
242: ) is
243: begin
244: delete from QPR_REPORT_HDRS_TL
245: where REPORT_HEADER_ID = X_REPORT_HEADER_ID;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 262: delete from QPR_REPORT_HDRS_TL T

258:
259: procedure ADD_LANGUAGE
260: is
261: begin
262: delete from QPR_REPORT_HDRS_TL T
263: where not exists
264: (select NULL
265: from QPR_REPORT_HDRS_B B
266: where B.REPORT_HEADER_ID = T.REPORT_HEADER_ID

Line 269: update QPR_REPORT_HDRS_TL T set (

265: from QPR_REPORT_HDRS_B B
266: where B.REPORT_HEADER_ID = T.REPORT_HEADER_ID
267: );
268:
269: update QPR_REPORT_HDRS_TL T set (
270: REPORT_NAME,
271: REPORT_TITLE
272: ) = (select
273: B.REPORT_NAME,

Line 275: from QPR_REPORT_HDRS_TL B

271: REPORT_TITLE
272: ) = (select
273: B.REPORT_NAME,
274: B.REPORT_TITLE
275: from QPR_REPORT_HDRS_TL B
276: where B.REPORT_HEADER_ID = T.REPORT_HEADER_ID
277: and B.LANGUAGE = T.SOURCE_LANG)
278: where (
279: T.REPORT_HEADER_ID,

Line 284: from QPR_REPORT_HDRS_TL SUBB, QPR_REPORT_HDRS_TL SUBT

280: T.LANGUAGE
281: ) in (select
282: SUBT.REPORT_HEADER_ID,
283: SUBT.LANGUAGE
284: from QPR_REPORT_HDRS_TL SUBB, QPR_REPORT_HDRS_TL SUBT
285: where SUBB.REPORT_HEADER_ID = SUBT.REPORT_HEADER_ID
286: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
287: and (SUBB.REPORT_NAME <> SUBT.REPORT_NAME
288: or (SUBB.REPORT_NAME is null and SUBT.REPORT_NAME is not null)

Line 295: insert into QPR_REPORT_HDRS_TL (

291: or (SUBB.REPORT_TITLE is null and SUBT.REPORT_TITLE is not null)
292: or (SUBB.REPORT_TITLE is not null and SUBT.REPORT_TITLE is null)
293: ));
294:
295: insert into QPR_REPORT_HDRS_TL (
296: REPORT_HEADER_ID,
297: REPORT_NAME,
298: REPORT_TITLE,
299: CREATION_DATE,

Line 325: from QPR_REPORT_HDRS_TL B, FND_LANGUAGES L

321: B.PROGRAM_LOGIN_ID,
322: B.REQUEST_ID,
323: L.LANGUAGE_CODE,
324: B.SOURCE_LANG
325: from QPR_REPORT_HDRS_TL B, FND_LANGUAGES L
326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL

Line 330: from QPR_REPORT_HDRS_TL T

326: where L.INSTALLED_FLAG in ('I', 'B')
327: and B.LANGUAGE = userenv('LANG')
328: and not exists
329: (select NULL
330: from QPR_REPORT_HDRS_TL T
331: where T.REPORT_HEADER_ID = B.REPORT_HEADER_ID
332: and T.LANGUAGE = L.LANGUAGE_CODE);
333: end ADD_LANGUAGE;
334: