APPS.AS_FORECAST_PROB_PKG dependencies on AS_FORECAST_PROB_ALL_B

Line 35: cursor C is select ROWID from AS_FORECAST_PROB_ALL_B

31: X_LAST_UPDATE_DATE in DATE,
32: X_LAST_UPDATED_BY in NUMBER,
33: X_LAST_UPDATE_LOGIN in NUMBER
34: ) is
35: cursor C is select ROWID from AS_FORECAST_PROB_ALL_B
36: where PROBABILITY_VALUE = X_PROBABILITY_VALUE
37: ;
38: begin
39: insert into AS_FORECAST_PROB_ALL_B (

Line 39: insert into AS_FORECAST_PROB_ALL_B (

35: cursor C is select ROWID from AS_FORECAST_PROB_ALL_B
36: where PROBABILITY_VALUE = X_PROBABILITY_VALUE
37: ;
38: begin
39: insert into AS_FORECAST_PROB_ALL_B (
40: USAGE_INDICATOR,
41: INTERNAL_UPGRADE_PROB_VALUE,
42: PROBABILITY_VALUE,
43: START_DATE_ACTIVE,

Line 186: from AS_FORECAST_PROB_ALL_B

182: ATTRIBUTE12,
183: ATTRIBUTE13,
184: ATTRIBUTE14,
185: ATTRIBUTE15
186: from AS_FORECAST_PROB_ALL_B
187: where PROBABILITY_VALUE = X_PROBABILITY_VALUE
188: for update of PROBABILITY_VALUE nowait;
189: recinfo c%rowtype;
190:

Line 303: update AS_FORECAST_PROB_ALL_B set

299: X_LAST_UPDATED_BY in NUMBER,
300: X_LAST_UPDATE_LOGIN in NUMBER
301: ) is
302: begin
303: update AS_FORECAST_PROB_ALL_B set
304: USAGE_INDICATOR = X_USAGE_INDICATOR,
305: INTERNAL_UPGRADE_PROB_VALUE = X_INTERNAL_UPGRADE_PROB_VALUE,
306: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
307: ENABLED_FLAG = X_ENABLED_FLAG,

Line 360: delete from AS_FORECAST_PROB_ALL_B

356: if (sql%notfound) then
357: raise no_data_found;
358: end if;
359:
360: delete from AS_FORECAST_PROB_ALL_B
361: where PROBABILITY_VALUE = X_PROBABILITY_VALUE;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 403: from AS_FORECAST_PROB_ALL_B

399: row_id varchar2(64);
400:
401: cursor custom_exist(p_PROBABILITY_VALUE NUMBER) is
402: select 'Y'
403: from AS_FORECAST_PROB_ALL_B
404: where last_updated_by <> 1
405: and PROBABILITY_VALUE = p_PROBABILITY_VALUE;
406:
407: l_custom_exist varchar2(1) := 'N';

Line 497: from AS_FORECAST_PROB_ALL_B B

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
499: );
500:
501: update AS_FORECAST_PROB_ALL_TL T set (