APPS.SO_RESULTS_PKG dependencies on SO_RESULTS_TL

Line 88: insert into SO_RESULTS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into SO_RESULTS_TL (
89: RESULT_ID,
90: NAME,
91: DESCRIPTION,
92: CREATION_DATE,

Line 114: from SO_RESULTS_TL T

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

Line 179: from SO_RESULTS_TL

175: cursor c1 is select
176: NAME,
177: DESCRIPTION,
178: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
179: from SO_RESULTS_TL
180: where RESULT_ID = X_RESULT_ID
181: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
182: for update of RESULT_ID nowait;
183: begin

Line 305: update SO_RESULTS_TL set

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

Line 326: update so_results_tl set

322: X_OWNER in VARCHAR2,
323: X_DESCRIPTION in VARCHAR2
324: ) is
325: begin
326: update so_results_tl set
327: description = X_DESCRIPTION,
328: source_lang = userenv('LANG'),
329: last_update_date = sysdate,
330: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 441: delete from SO_RESULTS_TL

437: procedure DELETE_ROW (
438: X_RESULT_ID in NUMBER
439: ) is
440: begin
441: delete from SO_RESULTS_TL
442: where RESULT_ID = X_RESULT_ID;
443:
444: if (sql%notfound) then
445: raise no_data_found;

Line 459: delete from SO_RESULTS_TL T

455:
456: procedure ADD_LANGUAGE
457: is
458: begin
459: delete from SO_RESULTS_TL T
460: where not exists
461: (select NULL
462: from SO_RESULTS_B B
463: where B.RESULT_ID = T.RESULT_ID

Line 466: update SO_RESULTS_TL T set (

462: from SO_RESULTS_B B
463: where B.RESULT_ID = T.RESULT_ID
464: );
465:
466: update SO_RESULTS_TL T set (
467: NAME,
468: DESCRIPTION
469: ) = (select
470: B.NAME,

Line 472: from SO_RESULTS_TL B

468: DESCRIPTION
469: ) = (select
470: B.NAME,
471: B.DESCRIPTION
472: from SO_RESULTS_TL B
473: where B.RESULT_ID = T.RESULT_ID
474: and B.LANGUAGE = T.SOURCE_LANG)
475: where (
476: T.RESULT_ID,

Line 481: from SO_RESULTS_TL SUBB, SO_RESULTS_TL SUBT

477: T.LANGUAGE
478: ) in (select
479: SUBT.RESULT_ID,
480: SUBT.LANGUAGE
481: from SO_RESULTS_TL SUBB, SO_RESULTS_TL SUBT
482: where SUBB.RESULT_ID = SUBT.RESULT_ID
483: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
484: and (SUBB.NAME <> SUBT.NAME
485: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 488: insert into SO_RESULTS_TL (

484: and (SUBB.NAME <> SUBT.NAME
485: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
486: ));
487:
488: insert into SO_RESULTS_TL (
489: RESULT_ID,
490: NAME,
491: DESCRIPTION,
492: CREATION_DATE,

Line 510: from SO_RESULTS_TL B, FND_LANGUAGES L

506: B.LAST_UPDATED_BY,
507: B.LAST_UPDATE_LOGIN,
508: L.LANGUAGE_CODE,
509: B.SOURCE_LANG
510: from SO_RESULTS_TL B, FND_LANGUAGES L
511: where L.INSTALLED_FLAG in ('I', 'B')
512: and B.LANGUAGE = userenv('LANG')
513: and not exists
514: (select NULL

Line 515: from SO_RESULTS_TL T

511: where L.INSTALLED_FLAG in ('I', 'B')
512: and B.LANGUAGE = userenv('LANG')
513: and not exists
514: (select NULL
515: from SO_RESULTS_TL T
516: where T.RESULT_ID = B.RESULT_ID
517: and T.LANGUAGE = L.LANGUAGE_CODE);
518: end ADD_LANGUAGE;
519: