APPS.AS_STATUSES_PKG dependencies on AS_STATUSES_TL

Line 125: insert into AS_STATUSES_TL (

121: X_LAST_UPDATED_BY,
122: X_LAST_UPDATE_LOGIN
123: );
124:
125: insert into AS_STATUSES_TL (
126: STATUS_CODE,
127: LAST_UPDATE_DATE,
128: LAST_UPDATED_BY,
129: CREATION_DATE,

Line 151: from AS_STATUSES_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_STATUSES_TL T
152: where T.STATUS_CODE = X_STATUS_CODE
153: and T.LANGUAGE = L.LANGUAGE_CODE);
154:
155: open c;

Line 230: from AS_STATUSES_TL

226: cursor c1 is select
227: MEANING,
228: DESCRIPTION,
229: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
230: from AS_STATUSES_TL
231: where STATUS_CODE = X_STATUS_CODE
232: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
233: for update of STATUS_CODE nowait;
234: begin

Line 394: update AS_STATUSES_TL set

390: if (sql%notfound) then
391: raise no_data_found;
392: end if;
393:
394: update AS_STATUSES_TL set
395: MEANING = X_MEANING,
396: DESCRIPTION = X_DESCRIPTION,
397: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
398: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 414: delete from AS_STATUSES_TL

410: procedure DELETE_ROW (
411: X_STATUS_CODE in VARCHAR2
412: ) is
413: begin
414: delete from AS_STATUSES_TL
415: where STATUS_CODE = X_STATUS_CODE;
416:
417: if (sql%notfound) then
418: raise no_data_found;

Line 574: delete from AS_STATUSES_TL T

570:
571: procedure ADD_LANGUAGE
572: is
573: begin
574: delete from AS_STATUSES_TL T
575: where not exists
576: (select NULL
577: from AS_STATUSES_B B
578: where B.STATUS_CODE = T.STATUS_CODE

Line 581: update AS_STATUSES_TL T set (

577: from AS_STATUSES_B B
578: where B.STATUS_CODE = T.STATUS_CODE
579: );
580:
581: update AS_STATUSES_TL T set (
582: MEANING,
583: DESCRIPTION
584: ) = (select
585: B.MEANING,

Line 587: from AS_STATUSES_TL B

583: DESCRIPTION
584: ) = (select
585: B.MEANING,
586: B.DESCRIPTION
587: from AS_STATUSES_TL B
588: where B.STATUS_CODE = T.STATUS_CODE
589: and B.LANGUAGE = T.SOURCE_LANG)
590: where (
591: T.STATUS_CODE,

Line 596: from AS_STATUSES_TL SUBB, AS_STATUSES_TL SUBT

592: T.LANGUAGE
593: ) in (select
594: SUBT.STATUS_CODE,
595: SUBT.LANGUAGE
596: from AS_STATUSES_TL SUBB, AS_STATUSES_TL SUBT
597: where SUBB.STATUS_CODE = SUBT.STATUS_CODE
598: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
599: and (SUBB.MEANING <> SUBT.MEANING
600: or (SUBB.MEANING is null and SUBT.MEANING is not null)

Line 607: insert into AS_STATUSES_TL (

603: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
604: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
605: ));
606:
607: insert into AS_STATUSES_TL (
608: STATUS_CODE,
609: LAST_UPDATE_DATE,
610: LAST_UPDATED_BY,
611: CREATION_DATE,

Line 629: from AS_STATUSES_TL B, FND_LANGUAGES L

625: B.MEANING,
626: B.DESCRIPTION,
627: L.LANGUAGE_CODE,
628: B.SOURCE_LANG
629: from AS_STATUSES_TL B, FND_LANGUAGES L
630: where L.INSTALLED_FLAG in ('I', 'B')
631: and B.LANGUAGE = userenv('LANG')
632: and not exists
633: (select NULL

Line 634: from AS_STATUSES_TL T

630: where L.INSTALLED_FLAG in ('I', 'B')
631: and B.LANGUAGE = userenv('LANG')
632: and not exists
633: (select NULL
634: from AS_STATUSES_TL T
635: where T.STATUS_CODE = B.STATUS_CODE
636: and T.LANGUAGE = L.LANGUAGE_CODE);
637: end ADD_LANGUAGE;
638:

Line 648: update AS_STATUSES_TL

644: X_OWNER in VARCHAR2)
645: IS
646: begin
647: -- only update rows that have not been altered by user
648: update AS_STATUSES_TL
649: set description = X_DESCRIPTION,
650: meaning = X_MEANING,
651: source_lang = userenv('LANG'),
652: last_update_date = sysdate,