APPS.AS_SALES_STAGES_PKG dependencies on AS_SALES_STAGES_ALL_TL

Line 106: insert into AS_SALES_STAGES_ALL_TL (

102: X_LAST_UPDATED_BY,
103: X_LAST_UPDATE_LOGIN
104: );
105:
106: insert into AS_SALES_STAGES_ALL_TL (
107: SALES_STAGE_ID,
108: LAST_UPDATE_DATE,
109: LAST_UPDATED_BY,
110: CREATION_DATE,

Line 132: from AS_SALES_STAGES_ALL_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from AS_SALES_STAGES_ALL_TL T
133: where T.SALES_STAGE_ID = X_SALES_STAGE_ID
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: open c;

Line 209: from AS_SALES_STAGES_ALL_TL

205: cursor c1 is select
206: NAME,
207: DESCRIPTION,
208: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
209: from AS_SALES_STAGES_ALL_TL
210: where SALES_STAGE_ID = X_SALES_STAGE_ID
211: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
212: for update of SALES_STAGE_ID nowait;
213: begin

Line 355: update AS_SALES_STAGES_ALL_TL set

351: if (sql%notfound) then
352: raise no_data_found;
353: end if;
354:
355: update AS_SALES_STAGES_ALL_TL set
356: NAME = X_NAME,
357: DESCRIPTION = X_DESCRIPTION,
358: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
359: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 374: delete from AS_SALES_STAGES_ALL_TL

370: procedure DELETE_ROW (
371: X_SALES_STAGE_ID in NUMBER
372: ) is
373: begin
374: delete from AS_SALES_STAGES_ALL_TL
375: where SALES_STAGE_ID = X_SALES_STAGE_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 524: delete from AS_SALES_STAGES_ALL_TL T

520:
521: procedure ADD_LANGUAGE
522: is
523: begin
524: delete from AS_SALES_STAGES_ALL_TL T
525: where not exists
526: (select NULL
527: from AS_SALES_STAGES_ALL_B B
528: where B.SALES_STAGE_ID = T.SALES_STAGE_ID

Line 531: update AS_SALES_STAGES_ALL_TL T set (

527: from AS_SALES_STAGES_ALL_B B
528: where B.SALES_STAGE_ID = T.SALES_STAGE_ID
529: );
530:
531: update AS_SALES_STAGES_ALL_TL T set (
532: NAME,
533: DESCRIPTION
534: ) = (select
535: B.NAME,

Line 537: from AS_SALES_STAGES_ALL_TL B

533: DESCRIPTION
534: ) = (select
535: B.NAME,
536: B.DESCRIPTION
537: from AS_SALES_STAGES_ALL_TL B
538: where B.SALES_STAGE_ID = T.SALES_STAGE_ID
539: and B.LANGUAGE = T.SOURCE_LANG)
540: where (
541: T.SALES_STAGE_ID,

Line 546: from AS_SALES_STAGES_ALL_TL SUBB, AS_SALES_STAGES_ALL_TL SUBT

542: T.LANGUAGE
543: ) in (select
544: SUBT.SALES_STAGE_ID,
545: SUBT.LANGUAGE
546: from AS_SALES_STAGES_ALL_TL SUBB, AS_SALES_STAGES_ALL_TL SUBT
547: where SUBB.SALES_STAGE_ID = SUBT.SALES_STAGE_ID
548: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
549: and (SUBB.NAME <> SUBT.NAME
550: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 555: insert into AS_SALES_STAGES_ALL_TL (

551: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
552: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
553: ));
554:
555: insert into AS_SALES_STAGES_ALL_TL (
556: SALES_STAGE_ID,
557: LAST_UPDATE_DATE,
558: LAST_UPDATED_BY,
559: CREATION_DATE,

Line 577: from AS_SALES_STAGES_ALL_TL B, FND_LANGUAGES L

573: B.NAME,
574: B.DESCRIPTION,
575: L.LANGUAGE_CODE,
576: B.SOURCE_LANG
577: from AS_SALES_STAGES_ALL_TL B, FND_LANGUAGES L
578: where L.INSTALLED_FLAG in ('I', 'B')
579: and B.LANGUAGE = userenv('LANG')
580: and not exists
581: (select NULL

Line 582: from AS_SALES_STAGES_ALL_TL T

578: where L.INSTALLED_FLAG in ('I', 'B')
579: and B.LANGUAGE = userenv('LANG')
580: and not exists
581: (select NULL
582: from AS_SALES_STAGES_ALL_TL T
583: where T.SALES_STAGE_ID = B.SALES_STAGE_ID
584: and T.LANGUAGE = L.LANGUAGE_CODE);
585: end ADD_LANGUAGE;
586:

Line 597: update AS_SALES_STAGES_ALL_TL

593: IS
594: begin
595: -- only update rows that have not been altered by user
596:
597: update AS_SALES_STAGES_ALL_TL
598: set description = X_DESCRIPTION,
599: name = X_NAME,
600: source_lang = userenv('LANG'),
601: last_update_date = sysdate,