APPS.QPR_DASHBOARD_MASTER_PKG dependencies on QPR_DASHBOARD_MASTER_TL

Line 54: insert into QPR_DASHBOARD_MASTER_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into QPR_DASHBOARD_MASTER_TL (
55: CREATION_DATE,
56: CREATED_BY,
57: LAST_UPDATE_DATE,
58: LAST_UPDATED_BY,

Line 78: from QPR_DASHBOARD_MASTER_TL T

74: from FND_LANGUAGES L
75: where L.INSTALLED_FLAG in ('I', 'B')
76: and not exists
77: (select NULL
78: from QPR_DASHBOARD_MASTER_TL T
79: where T.DASHBOARD_ID = X_DASHBOARD_ID
80: and T.LANGUAGE = L.LANGUAGE_CODE);
81:
82: open c;

Line 119: from QPR_DASHBOARD_MASTER_TL

115:
116: cursor c1 is select
117: DASHBOARD_NAME,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from QPR_DASHBOARD_MASTER_TL
120: where DASHBOARD_ID = X_DASHBOARD_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of DASHBOARD_ID nowait;
123: begin

Line 198: update QPR_DASHBOARD_MASTER_TL set

194: if (sql%notfound) then
195: raise no_data_found;
196: end if;
197:
198: update QPR_DASHBOARD_MASTER_TL set
199: DASHBOARD_NAME = X_DASHBOARD_NAME,
200: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
201: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
202: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 216: delete from QPR_DASHBOARD_MASTER_TL

212: procedure DELETE_ROW (
213: X_DASHBOARD_ID in NUMBER
214: ) is
215: begin
216: delete from QPR_DASHBOARD_MASTER_TL
217: where DASHBOARD_ID = X_DASHBOARD_ID;
218:
219: if (sql%notfound) then
220: raise no_data_found;

Line 234: delete from QPR_DASHBOARD_MASTER_TL T

230:
231: procedure ADD_LANGUAGE
232: is
233: begin
234: delete from QPR_DASHBOARD_MASTER_TL T
235: where not exists
236: (select NULL
237: from QPR_DASHBOARD_MASTER_B B
238: where B.DASHBOARD_ID = T.DASHBOARD_ID

Line 241: update QPR_DASHBOARD_MASTER_TL T set (

237: from QPR_DASHBOARD_MASTER_B B
238: where B.DASHBOARD_ID = T.DASHBOARD_ID
239: );
240:
241: update QPR_DASHBOARD_MASTER_TL T set (
242: DASHBOARD_NAME
243: ) = (select
244: B.DASHBOARD_NAME
245: from QPR_DASHBOARD_MASTER_TL B

Line 245: from QPR_DASHBOARD_MASTER_TL B

241: update QPR_DASHBOARD_MASTER_TL T set (
242: DASHBOARD_NAME
243: ) = (select
244: B.DASHBOARD_NAME
245: from QPR_DASHBOARD_MASTER_TL B
246: where B.DASHBOARD_ID = T.DASHBOARD_ID
247: and B.LANGUAGE = T.SOURCE_LANG)
248: where (
249: T.DASHBOARD_ID,

Line 254: from QPR_DASHBOARD_MASTER_TL SUBB, QPR_DASHBOARD_MASTER_TL SUBT

250: T.LANGUAGE
251: ) in (select
252: SUBT.DASHBOARD_ID,
253: SUBT.LANGUAGE
254: from QPR_DASHBOARD_MASTER_TL SUBB, QPR_DASHBOARD_MASTER_TL SUBT
255: where SUBB.DASHBOARD_ID = SUBT.DASHBOARD_ID
256: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
257: and (SUBB.DASHBOARD_NAME <> SUBT.DASHBOARD_NAME
258: or (SUBB.DASHBOARD_NAME is null and SUBT.DASHBOARD_NAME is not null)

Line 262: insert into QPR_DASHBOARD_MASTER_TL (

258: or (SUBB.DASHBOARD_NAME is null and SUBT.DASHBOARD_NAME is not null)
259: or (SUBB.DASHBOARD_NAME is not null and SUBT.DASHBOARD_NAME is null)
260: ));
261:
262: insert into QPR_DASHBOARD_MASTER_TL (
263: CREATION_DATE,
264: CREATED_BY,
265: LAST_UPDATE_DATE,
266: LAST_UPDATED_BY,

Line 282: from QPR_DASHBOARD_MASTER_TL B, FND_LANGUAGES L

278: B.DASHBOARD_ID,
279: B.DASHBOARD_NAME,
280: L.LANGUAGE_CODE,
281: B.SOURCE_LANG
282: from QPR_DASHBOARD_MASTER_TL B, FND_LANGUAGES L
283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL

Line 287: from QPR_DASHBOARD_MASTER_TL T

283: where L.INSTALLED_FLAG in ('I', 'B')
284: and B.LANGUAGE = userenv('LANG')
285: and not exists
286: (select NULL
287: from QPR_DASHBOARD_MASTER_TL T
288: where T.DASHBOARD_ID = B.DASHBOARD_ID
289: and T.LANGUAGE = L.LANGUAGE_CODE);
290: end ADD_LANGUAGE;
291: