APPS.QP_PRC_CONTEXTS_PKG dependencies on QP_PRC_CONTEXTS_TL

Line 97: insert into QP_PRC_CONTEXTS_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into QP_PRC_CONTEXTS_TL (
98: PRC_CONTEXT_ID,
99: SEEDED_PRC_CONTEXT_NAME,
100: USER_PRC_CONTEXT_NAME,
101: SEEDED_DESCRIPTION,

Line 127: from QP_PRC_CONTEXTS_TL T

123: from FND_LANGUAGES L
124: where L.INSTALLED_FLAG in ('I', 'B')
125: and not exists
126: (select NULL
127: from QP_PRC_CONTEXTS_TL T
128: where T.PRC_CONTEXT_ID = X_PRC_CONTEXT_ID
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: open c;

Line 203: from QP_PRC_CONTEXTS_TL

199: USER_PRC_CONTEXT_NAME,
200: SEEDED_DESCRIPTION,
201: USER_DESCRIPTION,
202: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
203: from QP_PRC_CONTEXTS_TL
204: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID
205: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
206: for update of PRC_CONTEXT_ID nowait;
207: begin

Line 339: update QP_PRC_CONTEXTS_TL set

335: if (sql%notfound) then
336: raise no_data_found;
337: end if;
338:
339: update QP_PRC_CONTEXTS_TL set
340: SEEDED_PRC_CONTEXT_NAME = X_SEEDED_PRC_CONTEXT_NAME,
341: USER_PRC_CONTEXT_NAME = X_USER_PRC_CONTEXT_NAME,
342: SEEDED_DESCRIPTION = X_SEEDED_DESCRIPTION,
343: USER_DESCRIPTION = X_USER_DESCRIPTION,

Line 360: delete from QP_PRC_CONTEXTS_TL

356: procedure DELETE_ROW (
357: X_PRC_CONTEXT_ID in NUMBER
358: ) is
359: begin
360: delete from QP_PRC_CONTEXTS_TL
361: where PRC_CONTEXT_ID = X_PRC_CONTEXT_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 378: delete from QP_PRC_CONTEXTS_TL T

374:
375: procedure ADD_LANGUAGE
376: is
377: begin
378: delete from QP_PRC_CONTEXTS_TL T
379: where not exists
380: (select NULL
381: from QP_PRC_CONTEXTS_B B
382: where B.PRC_CONTEXT_ID = T.PRC_CONTEXT_ID

Line 385: update QP_PRC_CONTEXTS_TL T set (

381: from QP_PRC_CONTEXTS_B B
382: where B.PRC_CONTEXT_ID = T.PRC_CONTEXT_ID
383: );
384:
385: update QP_PRC_CONTEXTS_TL T set (
386: SEEDED_PRC_CONTEXT_NAME,
387: USER_PRC_CONTEXT_NAME,
388: SEEDED_DESCRIPTION,
389: USER_DESCRIPTION

Line 395: from QP_PRC_CONTEXTS_TL B

391: B.SEEDED_PRC_CONTEXT_NAME,
392: B.USER_PRC_CONTEXT_NAME,
393: B.SEEDED_DESCRIPTION,
394: B.USER_DESCRIPTION
395: from QP_PRC_CONTEXTS_TL B
396: where B.PRC_CONTEXT_ID = T.PRC_CONTEXT_ID
397: and B.LANGUAGE = T.SOURCE_LANG)
398: where (
399: T.PRC_CONTEXT_ID,

Line 404: from QP_PRC_CONTEXTS_TL SUBB, QP_PRC_CONTEXTS_TL SUBT

400: T.LANGUAGE
401: ) in (select
402: SUBT.PRC_CONTEXT_ID,
403: SUBT.LANGUAGE
404: from QP_PRC_CONTEXTS_TL SUBB, QP_PRC_CONTEXTS_TL SUBT
405: where SUBB.PRC_CONTEXT_ID = SUBT.PRC_CONTEXT_ID
406: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
407: and (SUBB.SEEDED_PRC_CONTEXT_NAME <> SUBT.SEEDED_PRC_CONTEXT_NAME
408: or (SUBB.SEEDED_PRC_CONTEXT_NAME is null and SUBT.SEEDED_PRC_CONTEXT_NAME is not null)

Line 417: insert into QP_PRC_CONTEXTS_TL (

413: or (SUBB.SEEDED_DESCRIPTION is not null and SUBT.SEEDED_DESCRIPTION is null)
414: or SUBB.USER_DESCRIPTION <> SUBT.USER_DESCRIPTION
415: ));
416:
417: insert into QP_PRC_CONTEXTS_TL (
418: PRC_CONTEXT_ID,
419: SEEDED_PRC_CONTEXT_NAME,
420: USER_PRC_CONTEXT_NAME,
421: SEEDED_DESCRIPTION,

Line 430: ) select /*+ index(B QP_PRC_CONTEXTS_TL_N1) */

426: LAST_UPDATE_DATE,
427: LAST_UPDATE_LOGIN,
428: LANGUAGE,
429: SOURCE_LANG
430: ) select /*+ index(B QP_PRC_CONTEXTS_TL_N1) */
431: B.PRC_CONTEXT_ID,
432: B.SEEDED_PRC_CONTEXT_NAME,
433: B.USER_PRC_CONTEXT_NAME,
434: B.SEEDED_DESCRIPTION,

Line 443: from QP_PRC_CONTEXTS_TL B, FND_LANGUAGES L

439: B.LAST_UPDATE_DATE,
440: B.LAST_UPDATE_LOGIN,
441: L.LANGUAGE_CODE,
442: B.SOURCE_LANG
443: from QP_PRC_CONTEXTS_TL B, FND_LANGUAGES L
444: where L.INSTALLED_FLAG in ('I', 'B')
445: and B.LANGUAGE = userenv('LANG')
446: and not exists
447: (select NULL

Line 448: from QP_PRC_CONTEXTS_TL T

444: where L.INSTALLED_FLAG in ('I', 'B')
445: and B.LANGUAGE = userenv('LANG')
446: and not exists
447: (select NULL
448: from QP_PRC_CONTEXTS_TL T
449: where T.PRC_CONTEXT_ID = B.PRC_CONTEXT_ID
450: and T.LANGUAGE = L.LANGUAGE_CODE);
451: end ADD_LANGUAGE;
452: