APPS.AS_INTEREST_CODES_PKG dependencies on AS_INTEREST_CODES_TL

Line 136: insert into AS_INTEREST_CODES_TL (

132: -- X_LAST_UPDATED_BY,
133: -- X_LAST_UPDATE_LOGIN
134: -- );
135:
136: insert into AS_INTEREST_CODES_TL (
137: INTEREST_CODE_ID,
138: LAST_UPDATE_DATE,
139: LAST_UPDATED_BY,
140: CREATION_DATE,

Line 162: from AS_INTEREST_CODES_TL T

158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from AS_INTEREST_CODES_TL T
163: where T.INTEREST_CODE_ID = X_INTEREST_CODE_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165:
166: open c;

Line 246: from AS_INTEREST_CODES_TL

242: cursor c1 is select
243: CODE,
244: DESCRIPTION,
245: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
246: from AS_INTEREST_CODES_TL
247: where INTEREST_CODE_ID = X_INTEREST_CODE_ID
248: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
249: for update of INTEREST_CODE_ID nowait;
250:

Line 448: update AS_INTEREST_CODES_TL set

444: if (sql%notfound) then
445: raise no_data_found;
446: end if;
447:
448: update AS_INTEREST_CODES_TL set
449: CODE = X_CODE,
450: DESCRIPTION = X_DESCRIPTION,
451: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
452: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 467: delete from AS_INTEREST_CODES_TL

463: procedure DELETE_ROW (
464: X_INTEREST_CODE_ID in NUMBER
465: ) is
466: begin
467: delete from AS_INTEREST_CODES_TL
468: where INTEREST_CODE_ID = X_INTEREST_CODE_ID;
469:
470: if (sql%notfound) then
471: raise no_data_found;

Line 497: update AS_INTEREST_CODES_TL

493: X_OWNER in VARCHAR2)
494: IS
495: begin
496: -- only update rows that have not been altered by user
497: update AS_INTEREST_CODES_TL
498: set CODE=X_CODE,
499: DESCRIPTION=X_DESCRIPTION,
500: source_lang = userenv('LANG'),
501: last_update_date = sysdate,

Line 511: delete from AS_INTEREST_CODES_TL T

507:
508: procedure ADD_LANGUAGE
509: is
510: begin
511: delete from AS_INTEREST_CODES_TL T
512: where not exists
513: (select NULL
514: from AS_INTEREST_CODES_B B
515: where B.INTEREST_CODE_ID = T.INTEREST_CODE_ID

Line 518: update AS_INTEREST_CODES_TL T set (

514: from AS_INTEREST_CODES_B B
515: where B.INTEREST_CODE_ID = T.INTEREST_CODE_ID
516: );
517:
518: update AS_INTEREST_CODES_TL T set (
519: CODE,
520: DESCRIPTION
521: ) = (select
522: B.CODE,

Line 524: from AS_INTEREST_CODES_TL B

520: DESCRIPTION
521: ) = (select
522: B.CODE,
523: B.DESCRIPTION
524: from AS_INTEREST_CODES_TL B
525: where B.INTEREST_CODE_ID = T.INTEREST_CODE_ID
526: and B.LANGUAGE = T.SOURCE_LANG)
527: where (
528: T.INTEREST_CODE_ID,

Line 533: from AS_INTEREST_CODES_TL SUBB, AS_INTEREST_CODES_TL SUBT

529: T.LANGUAGE
530: ) in (select
531: SUBT.INTEREST_CODE_ID,
532: SUBT.LANGUAGE
533: from AS_INTEREST_CODES_TL SUBB, AS_INTEREST_CODES_TL SUBT
534: where SUBB.INTEREST_CODE_ID = SUBT.INTEREST_CODE_ID
535: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
536: and (SUBB.CODE <> SUBT.CODE
537: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 542: insert into AS_INTEREST_CODES_TL (

538: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
539: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
540: ));
541:
542: insert into AS_INTEREST_CODES_TL (
543: INTEREST_CODE_ID,
544: LAST_UPDATE_DATE,
545: LAST_UPDATED_BY,
546: CREATION_DATE,

Line 564: from AS_INTEREST_CODES_TL B, FND_LANGUAGES L

560: B.CODE,
561: B.DESCRIPTION,
562: L.LANGUAGE_CODE,
563: B.SOURCE_LANG
564: from AS_INTEREST_CODES_TL B, FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL

Line 569: from AS_INTEREST_CODES_TL T

565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL
569: from AS_INTEREST_CODES_TL T
570: where T.INTEREST_CODE_ID = B.INTEREST_CODE_ID
571: and T.LANGUAGE = L.LANGUAGE_CODE);
572: end ADD_LANGUAGE;
573: