APPS.AR_STANDARD_TEXT_PKG dependencies on AR_STANDARD_TEXT_TL

Line 96: insert into AR_STANDARD_TEXT_TL (

92: X_LAST_UPDATED_BY,
93: X_LAST_UPDATE_LOGIN
94: );
95:
96: insert into AR_STANDARD_TEXT_TL (
97: STANDARD_TEXT_ID,
98: TEXT,
99: LAST_UPDATE_DATE,
100: CREATION_DATE,

Line 120: from AR_STANDARD_TEXT_TL T

116: from FND_LANGUAGES L
117: where L.INSTALLED_FLAG in ('I', 'B')
118: and not exists
119: (select NULL
120: from AR_STANDARD_TEXT_TL T
121: where T.STANDARD_TEXT_ID = X_STANDARD_TEXT_ID
122: and T.LANGUAGE = L.LANGUAGE_CODE);
123:
124: open c;

Line 189: from AR_STANDARD_TEXT_TL

185:
186: cursor c1 is select
187: TEXT,
188: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
189: from AR_STANDARD_TEXT_TL
190: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID
191: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
192: for update of STANDARD_TEXT_ID nowait;
193: begin

Line 324: update AR_STANDARD_TEXT_TL set

320: if (sql%notfound) then
321: raise no_data_found;
322: end if;
323:
324: update AR_STANDARD_TEXT_TL set
325: TEXT = X_TEXT,
326: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
327: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
328: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 342: delete from AR_STANDARD_TEXT_TL

338: procedure DELETE_ROW (
339: X_STANDARD_TEXT_ID in NUMBER
340: ) is
341: begin
342: delete from AR_STANDARD_TEXT_TL
343: where STANDARD_TEXT_ID = X_STANDARD_TEXT_ID;
344:
345: if (sql%notfound) then
346: raise no_data_found;

Line 360: delete from AR_STANDARD_TEXT_TL T

356:
357: procedure ADD_LANGUAGE
358: is
359: begin
360: delete from AR_STANDARD_TEXT_TL T
361: where not exists
362: (select NULL
363: from AR_STANDARD_TEXT_B B
364: where B.STANDARD_TEXT_ID = T.STANDARD_TEXT_ID

Line 367: update AR_STANDARD_TEXT_TL T set (

363: from AR_STANDARD_TEXT_B B
364: where B.STANDARD_TEXT_ID = T.STANDARD_TEXT_ID
365: );
366:
367: update AR_STANDARD_TEXT_TL T set (
368: TEXT
369: ) = (select
370: B.TEXT
371: from AR_STANDARD_TEXT_TL B

Line 371: from AR_STANDARD_TEXT_TL B

367: update AR_STANDARD_TEXT_TL T set (
368: TEXT
369: ) = (select
370: B.TEXT
371: from AR_STANDARD_TEXT_TL B
372: where B.STANDARD_TEXT_ID = T.STANDARD_TEXT_ID
373: and B.LANGUAGE = T.SOURCE_LANG)
374: where (
375: T.STANDARD_TEXT_ID,

Line 380: from AR_STANDARD_TEXT_TL SUBB, AR_STANDARD_TEXT_TL SUBT

376: T.LANGUAGE
377: ) in (select
378: SUBT.STANDARD_TEXT_ID,
379: SUBT.LANGUAGE
380: from AR_STANDARD_TEXT_TL SUBB, AR_STANDARD_TEXT_TL SUBT
381: where SUBB.STANDARD_TEXT_ID = SUBT.STANDARD_TEXT_ID
382: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
383: and (SUBB.TEXT <> SUBT.TEXT
384: or (SUBB.TEXT is null and SUBT.TEXT is not null)

Line 388: insert into AR_STANDARD_TEXT_TL (

384: or (SUBB.TEXT is null and SUBT.TEXT is not null)
385: or (SUBB.TEXT is not null and SUBT.TEXT is null)
386: ));
387:
388: insert into AR_STANDARD_TEXT_TL (
389: STANDARD_TEXT_ID,
390: TEXT,
391: LAST_UPDATE_DATE,
392: CREATION_DATE,

Line 408: from AR_STANDARD_TEXT_TL B, FND_LANGUAGES L

404: B.LAST_UPDATED_BY,
405: B.LAST_UPDATE_LOGIN,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from AR_STANDARD_TEXT_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL

Line 413: from AR_STANDARD_TEXT_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from AR_STANDARD_TEXT_TL T
414: where T.STANDARD_TEXT_ID = B.STANDARD_TEXT_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416: end ADD_LANGUAGE;
417:

Line 529: update AR_STANDARD_TEXT_TL

525: begin
526:
527: -- only update rows that have not been altered by user
528:
529: update AR_STANDARD_TEXT_TL
530: set text = X_TEXT,
531: source_lang = userenv('LANG'),
532: last_update_date = sysdate,
533: last_updated_by = decode(X_OWNER, 'SEED', -1, 0),