APPS.AS_INTEREST_TYPES_PKG dependencies on AS_INTEREST_TYPES_TL

Line 123: INSERT INTO AS_INTEREST_TYPES_TL

119: -- Inserting the _TL table
120:
121: BEGIN
122:
123: INSERT INTO AS_INTEREST_TYPES_TL
124: (
125: INTEREST_TYPE_ID,
126: LAST_UPDATE_DATE,
127: LAST_UPDATED_BY,

Line 151: from AS_INTEREST_TYPES_TL T

147: FROM FND_LANGUAGES L
148: WHERE L.INSTALLED_FLAG in ('I', 'B')
149: and not exists
150: (select NULL
151: from AS_INTEREST_TYPES_TL T
152: where T.INTEREST_TYPE_ID = X_INTEREST_TYPE_ID
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 224: from AS_INTEREST_TYPES_TL

220: cursor c1 is select
221: INTEREST_TYPE,
222: DESCRIPTION,
223: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
224: from AS_INTEREST_TYPES_TL
225: where INTEREST_TYPE_ID = X_INTEREST_TYPE_ID
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
227: for update of INTEREST_TYPE_ID nowait;
228:

Line 382: UPDATE AS_INTEREST_TYPES_TL SET

378: END;
379: */
380:
381: BEGIN
382: UPDATE AS_INTEREST_TYPES_TL SET
383: INTEREST_TYPE = X_INTEREST_TYPE,
384: DESCRIPTION = X_DESCRIPTION,
385: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
386: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 408: delete from AS_INTEREST_TYPES_TL

404: procedure DELETE_ROW (
405: X_INTEREST_TYPE_ID in NUMBER
406: ) is
407: begin
408: delete from AS_INTEREST_TYPES_TL
409: where INTEREST_TYPE_ID = X_INTEREST_TYPE_ID;
410:
411: if (sql%notfound) then
412: raise no_data_found;

Line 440: update AS_INTEREST_TYPES_TL

436: X_OWNER in VARCHAR2)
437: IS
438: begin
439: -- only update rows that have not been altered by user
440: update AS_INTEREST_TYPES_TL
441: set INTEREST_TYPE=X_INTEREST_TYPE,
442: DESCRIPTION=X_DESCRIPTION,
443: source_lang = userenv('LANG'),
444: last_update_date = sysdate,

Line 454: delete from AS_INTEREST_TYPES_TL T

450:
451: procedure ADD_LANGUAGE is
452:
453: begin
454: delete from AS_INTEREST_TYPES_TL T
455: where not exists
456: (select NULL
457: from AS_INTEREST_TYPES_B B
458: where B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID

Line 461: update AS_INTEREST_TYPES_TL T

457: from AS_INTEREST_TYPES_B B
458: where B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID
459: );
460:
461: update AS_INTEREST_TYPES_TL T
462: set ( INTEREST_TYPE,
463: DESCRIPTION) = ( select
464: B.INTEREST_TYPE,
465: B.DESCRIPTION

Line 467: AS_INTEREST_TYPES_TL B

463: DESCRIPTION) = ( select
464: B.INTEREST_TYPE,
465: B.DESCRIPTION
466: from
467: AS_INTEREST_TYPES_TL B
468: where
469: B.INTEREST_TYPE_ID = T.INTEREST_TYPE_ID and
470: B.LANGUAGE = T.SOURCE_LANG )
471: where

Line 477: AS_INTEREST_TYPES_TL SUBB,

473: T.LANGUAGE ) in ( select
474: SUBT.INTEREST_TYPE_ID,
475: SUBT.LANGUAGE
476: from
477: AS_INTEREST_TYPES_TL SUBB,
478: AS_INTEREST_TYPES_TL SUBT
479: where
480: SUBB.INTEREST_TYPE_ID = SUBT.INTEREST_TYPE_ID and
481: SUBB.LANGUAGE = SUBT.SOURCE_LANG and

Line 478: AS_INTEREST_TYPES_TL SUBT

474: SUBT.INTEREST_TYPE_ID,
475: SUBT.LANGUAGE
476: from
477: AS_INTEREST_TYPES_TL SUBB,
478: AS_INTEREST_TYPES_TL SUBT
479: where
480: SUBB.INTEREST_TYPE_ID = SUBT.INTEREST_TYPE_ID and
481: SUBB.LANGUAGE = SUBT.SOURCE_LANG and
482: (SUBB.INTEREST_TYPE <> SUBT.INTEREST_TYPE or

Line 489: insert into AS_INTEREST_TYPES_TL (

485: SUBT.DESCRIPTION is not null) or
486: (SUBB.DESCRIPTION is not null and
487: SUBT.DESCRIPTION is null)));
488:
489: insert into AS_INTEREST_TYPES_TL (
490: INTEREST_TYPE_ID,
491: LAST_UPDATE_DATE,
492: LAST_UPDATED_BY,
493: CREATION_DATE,

Line 513: AS_INTEREST_TYPES_TL B,

509: B.DESCRIPTION,
510: L.LANGUAGE_CODE,
511: B.SOURCE_LANG
512: from
513: AS_INTEREST_TYPES_TL B,
514: FND_LANGUAGES L
515: where
516: L.INSTALLED_FLAG in ('I', 'B') and
517: B.LANGUAGE = userenv('LANG')

Line 520: from AS_INTEREST_TYPES_TL T

516: L.INSTALLED_FLAG in ('I', 'B') and
517: B.LANGUAGE = userenv('LANG')
518: and not exists
519: (select NULL
520: from AS_INTEREST_TYPES_TL T
521: where T.INTEREST_TYPE_ID = B.INTEREST_TYPE_ID
522: and T.LANGUAGE = L.LANGUAGE_CODE);
523: END ADD_LANGUAGE;
524: