APPS.AS_FORECAST_PROB_PKG dependencies on AS_FORECAST_PROB_ALL_TL

Line 99: insert into AS_FORECAST_PROB_ALL_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into AS_FORECAST_PROB_ALL_TL (
100: PROBABILITY_VALUE,
101: LAST_UPDATE_DATE,
102: LAST_UPDATED_BY,
103: CREATION_DATE,

Line 123: from AS_FORECAST_PROB_ALL_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from AS_FORECAST_PROB_ALL_TL T
124: where T.PROBABILITY_VALUE = X_PROBABILITY_VALUE
125: and T.LANGUAGE = L.LANGUAGE_CODE);
126:
127: open c;

Line 194: from AS_FORECAST_PROB_ALL_TL

190:
191: cursor c1 is select
192: MEANING,
193: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
194: from AS_FORECAST_PROB_ALL_TL
195: where PROBABILITY_VALUE = X_PROBABILITY_VALUE
196: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
197: for update of PROBABILITY_VALUE nowait;
198: begin

Line 335: update AS_FORECAST_PROB_ALL_TL set

331: if (sql%notfound) then
332: raise no_data_found;
333: end if;
334:
335: update AS_FORECAST_PROB_ALL_TL set
336: MEANING = X_MEANING,
337: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
338: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
339: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 353: delete from AS_FORECAST_PROB_ALL_TL

349: procedure DELETE_ROW (
350: X_PROBABILITY_VALUE in NUMBER
351: ) is
352: begin
353: delete from AS_FORECAST_PROB_ALL_TL
354: where PROBABILITY_VALUE = X_PROBABILITY_VALUE;
355:
356: if (sql%notfound) then
357: raise no_data_found;

Line 494: delete from AS_FORECAST_PROB_ALL_TL T

490:
491: procedure ADD_LANGUAGE
492: is
493: begin
494: delete from AS_FORECAST_PROB_ALL_TL T
495: where not exists
496: (select NULL
497: from AS_FORECAST_PROB_ALL_B B
498: where B.PROBABILITY_VALUE = T.PROBABILITY_VALUE

Line 501: update AS_FORECAST_PROB_ALL_TL T set (

497: from AS_FORECAST_PROB_ALL_B B
498: where B.PROBABILITY_VALUE = T.PROBABILITY_VALUE
499: );
500:
501: update AS_FORECAST_PROB_ALL_TL T set (
502: MEANING
503: ) = (select
504: B.MEANING
505: from AS_FORECAST_PROB_ALL_TL B

Line 505: from AS_FORECAST_PROB_ALL_TL B

501: update AS_FORECAST_PROB_ALL_TL T set (
502: MEANING
503: ) = (select
504: B.MEANING
505: from AS_FORECAST_PROB_ALL_TL B
506: where B.PROBABILITY_VALUE = T.PROBABILITY_VALUE
507: and B.LANGUAGE = T.SOURCE_LANG)
508: where (
509: T.PROBABILITY_VALUE,

Line 514: from AS_FORECAST_PROB_ALL_TL SUBB, AS_FORECAST_PROB_ALL_TL SUBT

510: T.LANGUAGE
511: ) in (select
512: SUBT.PROBABILITY_VALUE,
513: SUBT.LANGUAGE
514: from AS_FORECAST_PROB_ALL_TL SUBB, AS_FORECAST_PROB_ALL_TL SUBT
515: where SUBB.PROBABILITY_VALUE = SUBT.PROBABILITY_VALUE
516: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
517: and (SUBB.MEANING <> SUBT.MEANING
518: or (SUBB.MEANING is null and SUBT.MEANING is not null)

Line 522: insert into AS_FORECAST_PROB_ALL_TL (

518: or (SUBB.MEANING is null and SUBT.MEANING is not null)
519: or (SUBB.MEANING is not null and SUBT.MEANING is null)
520: ));
521:
522: insert into AS_FORECAST_PROB_ALL_TL (
523: PROBABILITY_VALUE,
524: LAST_UPDATE_DATE,
525: LAST_UPDATED_BY,
526: CREATION_DATE,

Line 542: from AS_FORECAST_PROB_ALL_TL B, FND_LANGUAGES L

538: B.LAST_UPDATE_LOGIN,
539: B.MEANING,
540: L.LANGUAGE_CODE,
541: B.SOURCE_LANG
542: from AS_FORECAST_PROB_ALL_TL B, FND_LANGUAGES L
543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL

Line 547: from AS_FORECAST_PROB_ALL_TL T

543: where L.INSTALLED_FLAG in ('I', 'B')
544: and B.LANGUAGE = userenv('LANG')
545: and not exists
546: (select NULL
547: from AS_FORECAST_PROB_ALL_TL T
548: where T.PROBABILITY_VALUE = B.PROBABILITY_VALUE
549: and T.LANGUAGE = L.LANGUAGE_CODE);
550: end ADD_LANGUAGE;
551:

Line 559: update AS_FORECAST_PROB_ALL_TL

555: X_OWNER in VARCHAR2)
556: IS
557: begin
558: -- only update rows that have not been altered by user
559: update AS_FORECAST_PROB_ALL_TL
560: set MEANING = X_MEANING,
561: source_lang = userenv('LANG'),
562: last_update_date = sysdate,
563: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),