APPS.ASO_QUOTE_STATUS_PKG dependencies on ASO_QUOTE_STATUSES_TL

Line 159: insert into ASO_QUOTE_STATUSES_TL (

155: decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156: decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157: );
158:
159: insert into ASO_QUOTE_STATUSES_TL (
160: QUOTE_STATUS_ID,
161: CREATION_DATE,
162: CREATED_BY,
163: LAST_UPDATED_BY,

Line 192: (select NULL from ASO_QUOTE_STATUSES_TL T

188: userenv('LANG')
189: from FND_LANGUAGES L
190: where L.INSTALLED_FLAG in ('I', 'B')
191: and not exists
192: (select NULL from ASO_QUOTE_STATUSES_TL T
193: where T.QUOTE_STATUS_ID = px_QUOTE_STATUS_ID
194: and T.LANGUAGE = L.LANGUAGE_CODE);
195: End Insert_Row;
196:

Line 296: update ASO_QUOTE_STATUSES_TL set

292: If (SQL%NOTFOUND) then
293: RAISE NO_DATA_FOUND;
294: End If;
295:
296: update ASO_QUOTE_STATUSES_TL set
297: MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298: DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
300: LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

Line 325: delete from ASO_QUOTE_STATUSES_TL

321: If (SQL%NOTFOUND) then
322: RAISE NO_DATA_FOUND;
323: End If;
324:
325: delete from ASO_QUOTE_STATUSES_TL
326: where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
327: if (sql%notfound) then
328: raise no_data_found;
329: end if;

Line 385: FROM ASO_QUOTE_STATUSES_TL

381:
382: CURSOR C_TL IS
383: SELECT MEANING, DESCRIPTION,
384: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
385: FROM ASO_QUOTE_STATUSES_TL
386: WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID
387: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
388: FOR UPDATE of QUOTE_STATUS_ID NOWAIT;
389:

Line 525: delete from ASO_QUOTE_STATUSES_TL T

521:
522: procedure ADD_LANGUAGE
523: is
524: begin
525: delete from ASO_QUOTE_STATUSES_TL T
526: where not exists
527: (select NULL
528: from ASO_QUOTE_STATUSES_B B
529: where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID

Line 532: update ASO_QUOTE_STATUSES_TL T set (

528: from ASO_QUOTE_STATUSES_B B
529: where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
530: );
531:
532: update ASO_QUOTE_STATUSES_TL T set (
533: MEANING,
534: DESCRIPTION
535: ) = (select
536: B.MEANING,

Line 538: from ASO_QUOTE_STATUSES_TL B

534: DESCRIPTION
535: ) = (select
536: B.MEANING,
537: B.DESCRIPTION
538: from ASO_QUOTE_STATUSES_TL B
539: where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
540: and B.LANGUAGE = T.SOURCE_LANG)
541: where (
542: T.QUOTE_STATUS_ID,

Line 547: from ASO_QUOTE_STATUSES_TL SUBB, ASO_QUOTE_STATUSES_TL SUBT

543: T.LANGUAGE
544: ) in (select
545: SUBT.QUOTE_STATUS_ID,
546: SUBT.LANGUAGE
547: from ASO_QUOTE_STATUSES_TL SUBB, ASO_QUOTE_STATUSES_TL SUBT
548: where SUBB.QUOTE_STATUS_ID = SUBT.QUOTE_STATUS_ID
549: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
550: and (SUBB.MEANING <> SUBT.MEANING
551: or (SUBB.MEANING is null and SUBT.MEANING is not null)

Line 558: insert into ASO_QUOTE_STATUSES_TL (

554: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
555: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
556: ));
557:
558: insert into ASO_QUOTE_STATUSES_TL (
559: QUOTE_STATUS_ID,
560: LAST_UPDATE_DATE,
561: LAST_UPDATED_BY,
562: CREATION_DATE,

Line 588: from ASO_QUOTE_STATUSES_TL B, FND_LANGUAGES L

584: B.MEANING,
585: B.DESCRIPTION,
586: L.LANGUAGE_CODE,
587: B.SOURCE_LANG
588: from ASO_QUOTE_STATUSES_TL B, FND_LANGUAGES L
589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: and not exists
592: (select NULL

Line 593: from ASO_QUOTE_STATUSES_TL T

589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: and not exists
592: (select NULL
593: from ASO_QUOTE_STATUSES_TL T
594: where T.QUOTE_STATUS_ID = B.QUOTE_STATUS_ID
595: and T.LANGUAGE = L.LANGUAGE_CODE);
596: end ADD_LANGUAGE;
597:

Line 777: update ASO_QUOTE_STATUSES_TL

773: begin
774:
775: -- only update rows that have not been altered by user
776:
777: update ASO_QUOTE_STATUSES_TL
778: set description = X_DESCRIPTION,
779: meaning = X_MEANING,
780: source_lang = userenv('LANG'),
781: last_update_date = sysdate,