APPS.QP_CURRENCY_LISTS_PKG dependencies on QP_CURRENCY_LISTS_TL

Line 89: insert into QP_CURRENCY_LISTS_TL (

85: X_LAST_UPDATED_BY,
86: X_LAST_UPDATE_LOGIN
87: );
88:
89: insert into QP_CURRENCY_LISTS_TL (
90: CURRENCY_HEADER_ID,
91: NAME,
92: DESCRIPTION,
93: CREATION_DATE,

Line 115: from QP_CURRENCY_LISTS_TL T

111: from FND_LANGUAGES L
112: where L.INSTALLED_FLAG in ('I', 'B')
113: and not exists
114: (select NULL
115: from QP_CURRENCY_LISTS_TL T
116: where T.CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID
117: and T.LANGUAGE = L.LANGUAGE_CODE);
118:
119: open c;

Line 181: from QP_CURRENCY_LISTS_TL

177: cursor c1 is select
178: NAME,
179: DESCRIPTION,
180: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
181: from QP_CURRENCY_LISTS_TL
182: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID
183: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
184: for update of CURRENCY_HEADER_ID nowait;
185: begin

Line 307: update QP_CURRENCY_LISTS_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update QP_CURRENCY_LISTS_TL set
308: NAME = X_NAME,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 326: delete from QP_CURRENCY_LISTS_TL

322: procedure DELETE_ROW (
323: X_CURRENCY_HEADER_ID in NUMBER
324: ) is
325: begin
326: delete from QP_CURRENCY_LISTS_TL
327: where CURRENCY_HEADER_ID = X_CURRENCY_HEADER_ID;
328:
329: if (sql%notfound) then
330: raise no_data_found;

Line 344: delete from QP_CURRENCY_LISTS_TL T

340:
341: procedure ADD_LANGUAGE
342: is
343: begin
344: delete from QP_CURRENCY_LISTS_TL T
345: where not exists
346: (select NULL
347: from QP_CURRENCY_LISTS_B B
348: where B.CURRENCY_HEADER_ID = T.CURRENCY_HEADER_ID

Line 351: update QP_CURRENCY_LISTS_TL T set (

347: from QP_CURRENCY_LISTS_B B
348: where B.CURRENCY_HEADER_ID = T.CURRENCY_HEADER_ID
349: );
350:
351: update QP_CURRENCY_LISTS_TL T set (
352: NAME,
353: DESCRIPTION
354: ) = (select
355: B.NAME,

Line 357: from QP_CURRENCY_LISTS_TL B

353: DESCRIPTION
354: ) = (select
355: B.NAME,
356: B.DESCRIPTION
357: from QP_CURRENCY_LISTS_TL B
358: where B.CURRENCY_HEADER_ID = T.CURRENCY_HEADER_ID
359: and B.LANGUAGE = T.SOURCE_LANG)
360: where (
361: T.CURRENCY_HEADER_ID,

Line 366: from QP_CURRENCY_LISTS_TL SUBB, QP_CURRENCY_LISTS_TL SUBT

362: T.LANGUAGE
363: ) in (select
364: SUBT.CURRENCY_HEADER_ID,
365: SUBT.LANGUAGE
366: from QP_CURRENCY_LISTS_TL SUBB, QP_CURRENCY_LISTS_TL SUBT
367: where SUBB.CURRENCY_HEADER_ID = SUBT.CURRENCY_HEADER_ID
368: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
369: and (SUBB.NAME <> SUBT.NAME
370: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 375: insert into QP_CURRENCY_LISTS_TL (

371: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
372: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
373: ));
374:
375: insert into QP_CURRENCY_LISTS_TL (
376: CURRENCY_HEADER_ID,
377: NAME,
378: DESCRIPTION,
379: CREATION_DATE,

Line 397: from QP_CURRENCY_LISTS_TL B, FND_LANGUAGES L

393: B.LAST_UPDATED_BY,
394: B.LAST_UPDATE_LOGIN,
395: L.LANGUAGE_CODE,
396: B.SOURCE_LANG
397: from QP_CURRENCY_LISTS_TL B, FND_LANGUAGES L
398: where L.INSTALLED_FLAG in ('I', 'B')
399: and B.LANGUAGE = userenv('LANG')
400: and not exists
401: (select NULL

Line 402: from QP_CURRENCY_LISTS_TL T

398: where L.INSTALLED_FLAG in ('I', 'B')
399: and B.LANGUAGE = userenv('LANG')
400: and not exists
401: (select NULL
402: from QP_CURRENCY_LISTS_TL T
403: where T.CURRENCY_HEADER_ID = B.CURRENCY_HEADER_ID
404: and T.LANGUAGE = L.LANGUAGE_CODE);
405: end ADD_LANGUAGE;
406: