APPS.QP_PTE_REQUEST_TYPES_PKG dependencies on QP_PTE_REQUEST_TYPES_TL

Line 99: insert into QP_PTE_REQUEST_TYPES_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into QP_PTE_REQUEST_TYPES_TL (
100: REQUEST_TYPE_CODE,
101: LAST_UPDATE_DATE,
102: LAST_UPDATE_LOGIN,
103: LAST_UPDATED_BY,

Line 123: from QP_PTE_REQUEST_TYPES_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from QP_PTE_REQUEST_TYPES_TL T
124: where T.REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 194: from QP_PTE_REQUEST_TYPES_TL

190:
191: cursor c1 is select
192: REQUEST_TYPE_DESC,
193: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
194: from QP_PTE_REQUEST_TYPES_TL
195: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE
196: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
197: for update of REQUEST_TYPE_CODE nowait;
198: begin

Line 333: update QP_PTE_REQUEST_TYPES_TL set

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: update QP_PTE_REQUEST_TYPES_TL set
334: REQUEST_TYPE_DESC = X_REQUEST_TYPE_DESC,
335: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
336: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
337: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 351: delete from QP_PTE_REQUEST_TYPES_TL

347: procedure DELETE_ROW (
348: X_REQUEST_TYPE_CODE in VARCHAR2
349: ) is
350: begin
351: delete from QP_PTE_REQUEST_TYPES_TL
352: where REQUEST_TYPE_CODE = X_REQUEST_TYPE_CODE;
353:
354: if (sql%notfound) then
355: raise no_data_found;

Line 369: delete from QP_PTE_REQUEST_TYPES_TL T

365:
366: procedure ADD_LANGUAGE
367: is
368: begin
369: delete from QP_PTE_REQUEST_TYPES_TL T
370: where not exists
371: (select NULL
372: from QP_PTE_REQUEST_TYPES_B B
373: where B.REQUEST_TYPE_CODE = T.REQUEST_TYPE_CODE

Line 376: update QP_PTE_REQUEST_TYPES_TL T set (

372: from QP_PTE_REQUEST_TYPES_B B
373: where B.REQUEST_TYPE_CODE = T.REQUEST_TYPE_CODE
374: );
375:
376: update QP_PTE_REQUEST_TYPES_TL T set (
377: REQUEST_TYPE_DESC
378: ) = (select
379: B.REQUEST_TYPE_DESC
380: from QP_PTE_REQUEST_TYPES_TL B

Line 380: from QP_PTE_REQUEST_TYPES_TL B

376: update QP_PTE_REQUEST_TYPES_TL T set (
377: REQUEST_TYPE_DESC
378: ) = (select
379: B.REQUEST_TYPE_DESC
380: from QP_PTE_REQUEST_TYPES_TL B
381: where B.REQUEST_TYPE_CODE = T.REQUEST_TYPE_CODE
382: and B.LANGUAGE = T.SOURCE_LANG)
383: where (
384: T.REQUEST_TYPE_CODE,

Line 389: from QP_PTE_REQUEST_TYPES_TL SUBB, QP_PTE_REQUEST_TYPES_TL SUBT

385: T.LANGUAGE
386: ) in (select
387: SUBT.REQUEST_TYPE_CODE,
388: SUBT.LANGUAGE
389: from QP_PTE_REQUEST_TYPES_TL SUBB, QP_PTE_REQUEST_TYPES_TL SUBT
390: where SUBB.REQUEST_TYPE_CODE = SUBT.REQUEST_TYPE_CODE
391: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
392: and (SUBB.REQUEST_TYPE_DESC <> SUBT.REQUEST_TYPE_DESC
393: or (SUBB.REQUEST_TYPE_DESC is null and SUBT.REQUEST_TYPE_DESC is not null)

Line 397: insert into QP_PTE_REQUEST_TYPES_TL (

393: or (SUBB.REQUEST_TYPE_DESC is null and SUBT.REQUEST_TYPE_DESC is not null)
394: or (SUBB.REQUEST_TYPE_DESC is not null and SUBT.REQUEST_TYPE_DESC is null)
395: ));
396:
397: insert into QP_PTE_REQUEST_TYPES_TL (
398: REQUEST_TYPE_CODE,
399: LAST_UPDATE_DATE,
400: LAST_UPDATE_LOGIN,
401: LAST_UPDATED_BY,

Line 417: from QP_PTE_REQUEST_TYPES_TL B, FND_LANGUAGES L

413: B.CREATED_BY,
414: B.CREATION_DATE,
415: L.LANGUAGE_CODE,
416: B.SOURCE_LANG
417: from QP_PTE_REQUEST_TYPES_TL B, FND_LANGUAGES L
418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL

Line 422: from QP_PTE_REQUEST_TYPES_TL T

418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL
422: from QP_PTE_REQUEST_TYPES_TL T
423: where T.REQUEST_TYPE_CODE = B.REQUEST_TYPE_CODE
424: and T.LANGUAGE = L.LANGUAGE_CODE);
425: end ADD_LANGUAGE;
426: