APPS.AS_FORECAST_PROB_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
  X_PROBABILITY_VALUE in NUMBER,
  X_USAGE_INDICATOR in VARCHAR2,
  X_INTERNAL_UPGRADE_PROB_VALUE in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG in VARCHAR2,
  X_LEAD_STATUS_CHANGE_CODE in VARCHAR2,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from AS_FORECAST_PROB_ALL_B
    where PROBABILITY_VALUE = X_PROBABILITY_VALUE
    ;

Line: 39

  insert into AS_FORECAST_PROB_ALL_B (
    USAGE_INDICATOR,
    INTERNAL_UPGRADE_PROB_VALUE,
    PROBABILITY_VALUE,
    START_DATE_ACTIVE,
    ENABLED_FLAG,
    LEAD_STATUS_CHANGE_CODE,
    END_DATE_ACTIVE,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_USAGE_INDICATOR,
    X_INTERNAL_UPGRADE_PROB_VALUE,
    X_PROBABILITY_VALUE,
    X_START_DATE_ACTIVE,
    X_ENABLED_FLAG,
    X_LEAD_STATUS_CHANGE_CODE,
    X_END_DATE_ACTIVE,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 99

  insert into AS_FORECAST_PROB_ALL_TL (
    PROBABILITY_VALUE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    MEANING,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_PROBABILITY_VALUE,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_MEANING,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AS_FORECAST_PROB_ALL_TL T
    where T.PROBABILITY_VALUE = X_PROBABILITY_VALUE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 135

end INSERT_ROW;

Line: 163

  cursor c is select
      USAGE_INDICATOR,
      INTERNAL_UPGRADE_PROB_VALUE,
      START_DATE_ACTIVE,
      ENABLED_FLAG,
      LEAD_STATUS_CHANGE_CODE,
      END_DATE_ACTIVE,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    from AS_FORECAST_PROB_ALL_B
    where PROBABILITY_VALUE = X_PROBABILITY_VALUE
    for update of PROBABILITY_VALUE nowait;

Line: 191

  cursor c1 is select
      MEANING,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AS_FORECAST_PROB_ALL_TL
    where PROBABILITY_VALUE = X_PROBABILITY_VALUE
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of PROBABILITY_VALUE nowait;

Line: 203

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 273

procedure UPDATE_ROW (
  X_PROBABILITY_VALUE in NUMBER,
  X_USAGE_INDICATOR in VARCHAR2,
  X_INTERNAL_UPGRADE_PROB_VALUE in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG in VARCHAR2,
  X_LEAD_STATUS_CHANGE_CODE in VARCHAR2,
  X_END_DATE_ACTIVE in DATE,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_MEANING in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AS_FORECAST_PROB_ALL_B set
    USAGE_INDICATOR = X_USAGE_INDICATOR,
    INTERNAL_UPGRADE_PROB_VALUE = X_INTERNAL_UPGRADE_PROB_VALUE,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    ENABLED_FLAG = X_ENABLED_FLAG,
    LEAD_STATUS_CHANGE_CODE = X_LEAD_STATUS_CHANGE_CODE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PROBABILITY_VALUE = X_PROBABILITY_VALUE;

Line: 335

  update AS_FORECAST_PROB_ALL_TL set
    MEANING = X_MEANING,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where PROBABILITY_VALUE = X_PROBABILITY_VALUE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 347

end UPDATE_ROW;

Line: 349

procedure DELETE_ROW (
  X_PROBABILITY_VALUE in NUMBER
) is
begin
  delete from AS_FORECAST_PROB_ALL_TL
  where PROBABILITY_VALUE = X_PROBABILITY_VALUE;

Line: 360

  delete from AS_FORECAST_PROB_ALL_B
  where PROBABILITY_VALUE = X_PROBABILITY_VALUE;

Line: 366

end DELETE_ROW;

Line: 402

	select 'Y'
	from AS_FORECAST_PROB_ALL_B
	where last_updated_by <> 1
	and PROBABILITY_VALUE = p_PROBABILITY_VALUE;

Line: 422

     AS_FORECAST_PROB_PKG.UPDATE_ROW (
       X_PROBABILITY_VALUE 		     => X_PROBABILITY_VALUE,
    	  X_USAGE_INDICATOR 		     => X_USAGE_INDICATOR,
    	  X_INTERNAL_UPGRADE_PROB_VALUE    => X_INTERNAL_UPGRADE_PROB_VALUE,
    	  X_START_DATE_ACTIVE 		     => X_START_DATE_ACTIVE,
    	  X_ENABLED_FLAG 		          => X_ENABLED_FLAG,
    	  X_LEAD_STATUS_CHANGE_CODE 	     => X_LEAD_STATUS_CHANGE_CODE,
    	  X_END_DATE_ACTIVE 		     => X_END_DATE_ACTIVE,
    	  X_ATTRIBUTE_CATEGORY 		     => X_ATTRIBUTE_CATEGORY,
    	  X_ATTRIBUTE1 			     => X_ATTRIBUTE1,
    	  X_ATTRIBUTE2 			     => X_ATTRIBUTE2,
    	  X_ATTRIBUTE3 			     => X_ATTRIBUTE3,
    	  X_ATTRIBUTE4 			     => X_ATTRIBUTE4,
    	  X_ATTRIBUTE5 			     => X_ATTRIBUTE5,
    	  X_ATTRIBUTE6 			     => X_ATTRIBUTE6,
    	  X_ATTRIBUTE7 			     => X_ATTRIBUTE7,
    	  X_ATTRIBUTE8 			     => X_ATTRIBUTE8,
    	  X_ATTRIBUTE9 			     => X_ATTRIBUTE9,
    	  X_ATTRIBUTE10 		          => X_ATTRIBUTE10,
    	  X_ATTRIBUTE11 		          => X_ATTRIBUTE11,
    	  X_ATTRIBUTE12 		          => X_ATTRIBUTE12,
    	  X_ATTRIBUTE13 		          => X_ATTRIBUTE13,
    	  X_ATTRIBUTE14 		          => X_ATTRIBUTE14,
    	  X_ATTRIBUTE15 		          => X_ATTRIBUTE15,
    	  X_MEANING 			          => X_MEANING,
    	  X_LAST_UPDATE_DATE		     => sysdate,
    	  X_LAST_UPDATED_BY 		     => user_id,
    	  X_LAST_UPDATE_LOGIN 		     => 0
	    );

Line: 453

           AS_FORECAST_PROB_PKG.INSERT_ROW (
        		X_ROWID			             => row_id,
        		X_PROBABILITY_VALUE 	        => X_PROBABILITY_VALUE,
        	  	X_USAGE_INDICATOR 		        => X_USAGE_INDICATOR,
        	  	X_INTERNAL_UPGRADE_PROB_VALUE    => X_INTERNAL_UPGRADE_PROB_VALUE,
        		X_START_DATE_ACTIVE 		   => X_START_DATE_ACTIVE,
        		X_ENABLED_FLAG 			   => X_ENABLED_FLAG,
        		X_LEAD_STATUS_CHANGE_CODE 	   => X_LEAD_STATUS_CHANGE_CODE,
        		X_END_DATE_ACTIVE 		        => X_END_DATE_ACTIVE,
        		X_ATTRIBUTE_CATEGORY 		   => X_ATTRIBUTE_CATEGORY,
        		X_ATTRIBUTE1 			        => X_ATTRIBUTE1,
        		X_ATTRIBUTE2 			        => X_ATTRIBUTE2,
        		X_ATTRIBUTE3 			        => X_ATTRIBUTE3,
        		X_ATTRIBUTE4 			        => X_ATTRIBUTE4,
        		X_ATTRIBUTE5 			        => X_ATTRIBUTE5,
        		X_ATTRIBUTE6 			        => X_ATTRIBUTE6,
        		X_ATTRIBUTE7 			        => X_ATTRIBUTE7,
        		X_ATTRIBUTE8 			        => X_ATTRIBUTE8,
        		X_ATTRIBUTE9 			        => X_ATTRIBUTE9,
        		X_ATTRIBUTE10 		   	        => X_ATTRIBUTE10,
        		X_ATTRIBUTE11 		             => X_ATTRIBUTE11,
        		X_ATTRIBUTE12 		  	        => X_ATTRIBUTE12,
        		X_ATTRIBUTE13 			        => X_ATTRIBUTE13,
        		X_ATTRIBUTE14 			        => X_ATTRIBUTE14,
        		X_ATTRIBUTE15 			        => X_ATTRIBUTE15,
        		X_MEANING 			        => X_MEANING,
               X_CREATION_DATE     		   => sysdate,
               X_CREATED_BY        		   => 0,
        		X_LAST_UPDATE_DATE		        => sysdate,
        		X_LAST_UPDATED_BY 		        => user_id,
        		X_LAST_UPDATE_LOGIN 		   => 0
	          );

Line: 494

  delete from AS_FORECAST_PROB_ALL_TL T
  where not exists
    (select NULL
    from AS_FORECAST_PROB_ALL_B B
    where B.PROBABILITY_VALUE = T.PROBABILITY_VALUE
    );

Line: 501

  update AS_FORECAST_PROB_ALL_TL T set (
      MEANING
    ) = (select
      B.MEANING
    from AS_FORECAST_PROB_ALL_TL B
    where B.PROBABILITY_VALUE = T.PROBABILITY_VALUE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.PROBABILITY_VALUE,
      T.LANGUAGE
  ) in (select
      SUBT.PROBABILITY_VALUE,
      SUBT.LANGUAGE
    from AS_FORECAST_PROB_ALL_TL SUBB, AS_FORECAST_PROB_ALL_TL SUBT
    where SUBB.PROBABILITY_VALUE = SUBT.PROBABILITY_VALUE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.MEANING <> SUBT.MEANING
      or (SUBB.MEANING is null and SUBT.MEANING is not null)
      or (SUBB.MEANING is not null and SUBT.MEANING is null)
  ));

Line: 522

  insert into AS_FORECAST_PROB_ALL_TL (
    PROBABILITY_VALUE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    MEANING,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.PROBABILITY_VALUE,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.MEANING,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AS_FORECAST_PROB_ALL_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AS_FORECAST_PROB_ALL_TL T
    where T.PROBABILITY_VALUE = B.PROBABILITY_VALUE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 559

   update AS_FORECAST_PROB_ALL_TL
     set MEANING  = X_MEANING,
         source_lang = userenv('LANG'),
	    last_update_date = sysdate,
	    last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
	    last_update_login = 0
      where PROBABILITY_VALUE = X_PROBABILITY_VALUE
	 and userenv('LANG') in (language, source_lang);