APPS.AR_BPA_ITEMS_PKG dependencies on AR_BPA_ITEMS_TL

Line 96: insert into AR_BPA_ITEMS_TL (

92: X_FLEXFIELD_ITEM_FLAG,
93: X_COLUMN_NAME
94: );
95:
96: insert into AR_BPA_ITEMS_TL (
97: ITEM_ID,
98: ITEM_NAME,
99: ITEM_TEXT_VALUE,
100: DISPLAY_PROMPT,

Line 126: from AR_BPA_ITEMS_TL T

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

Line 199: from AR_BPA_ITEMS_TL

195: ITEM_TEXT_VALUE,
196: DISPLAY_PROMPT,
197: ITEM_DESCRIPTION,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from AR_BPA_ITEMS_TL
200: where ITEM_ID = X_ITEM_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of ITEM_ID nowait;
203: begin

Line 337: update AR_BPA_ITEMS_TL set

333: if (sql%notfound) then
334: raise no_data_found;
335: end if;
336:
337: update AR_BPA_ITEMS_TL set
338: ITEM_NAME = X_ITEM_NAME,
339: ITEM_TEXT_VALUE = X_ITEM_TEXT_VALUE,
340: DISPLAY_PROMPT = X_DISPLAY_PROMPT,
341: ITEM_DESCRIPTION = X_ITEM_DESCRIPTION,

Line 358: delete from AR_BPA_ITEMS_TL

354: procedure DELETE_ROW (
355: X_ITEM_ID in NUMBER
356: ) is
357: begin
358: delete from AR_BPA_ITEMS_TL
359: where ITEM_ID = X_ITEM_ID;
360:
361: if (sql%notfound) then
362: raise no_data_found;

Line 376: delete from AR_BPA_ITEMS_TL T

372:
373: procedure ADD_LANGUAGE
374: is
375: begin
376: delete from AR_BPA_ITEMS_TL T
377: where not exists
378: (select NULL
379: from AR_BPA_ITEMS_B B
380: where B.ITEM_ID = T.ITEM_ID

Line 383: update AR_BPA_ITEMS_TL T set (

379: from AR_BPA_ITEMS_B B
380: where B.ITEM_ID = T.ITEM_ID
381: );
382:
383: update AR_BPA_ITEMS_TL T set (
384: ITEM_NAME,
385: ITEM_TEXT_VALUE,
386: DISPLAY_PROMPT,
387: ITEM_DESCRIPTION

Line 393: from AR_BPA_ITEMS_TL B

389: B.ITEM_NAME,
390: B.ITEM_TEXT_VALUE,
391: B.DISPLAY_PROMPT,
392: B.ITEM_DESCRIPTION
393: from AR_BPA_ITEMS_TL B
394: where B.ITEM_ID = T.ITEM_ID
395: and B.LANGUAGE = T.SOURCE_LANG)
396: where (
397: T.ITEM_ID,

Line 402: from AR_BPA_ITEMS_TL SUBB, AR_BPA_ITEMS_TL SUBT

398: T.LANGUAGE
399: ) in (select
400: SUBT.ITEM_ID,
401: SUBT.LANGUAGE
402: from AR_BPA_ITEMS_TL SUBB, AR_BPA_ITEMS_TL SUBT
403: where SUBB.ITEM_ID = SUBT.ITEM_ID
404: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
405: and (SUBB.ITEM_NAME <> SUBT.ITEM_NAME
406: or (SUBB.ITEM_NAME is null and SUBT.ITEM_NAME is not null)

Line 419: insert into AR_BPA_ITEMS_TL (

415: or (SUBB.ITEM_DESCRIPTION is null and SUBT.ITEM_DESCRIPTION is not null)
416: or (SUBB.ITEM_DESCRIPTION is not null and SUBT.ITEM_DESCRIPTION is null)
417: ));
418:
419: insert into AR_BPA_ITEMS_TL (
420: ITEM_ID,
421: ITEM_NAME,
422: ITEM_TEXT_VALUE,
423: DISPLAY_PROMPT,

Line 445: from AR_BPA_ITEMS_TL B, FND_LANGUAGES L

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

Line 450: from AR_BPA_ITEMS_TL T

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

Line 464: update AR_BPA_ITEMS_TL

460: X_ITEM_DESCRIPTION in VARCHAR2,
461: X_OWNER in VARCHAR2) IS
462: begin
463:
464: update AR_BPA_ITEMS_TL
465: set ITEM_NAME = X_ITEM_NAME,
466: ITEM_TEXT_VALUE = X_ITEM_TEXT_VALUE,
467: DISPLAY_PROMPT = X_DISPLAY_PROMPT,
468: ITEM_DESCRIPTION = X_ITEM_DESCRIPTION,