APPS.JTF_CAL_EXCEPTIONS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_ROWID in out NOCOPY VARCHAR2,
  X_EXCEPTION_ID in out NOCOPY NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_START_DATE_TIME in DATE,
  X_END_DATE_TIME in DATE,
  X_EXCEPTION_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_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_EXCEPTION_NAME in VARCHAR2,
  X_DESCRIPTION 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
v_begin_time date;

Line: 36

  cursor C is select ROWID from JTF_CAL_EXCEPTIONS_B
    where EXCEPTION_ID = X_EXCEPTION_ID
    ;

Line: 85

		   select count(*) into p_rec
		     from JTF_CAL_EXCEPTIONS_VL
		    where EXCEPTION_NAME = X_EXCEPTION_NAME
 		     -- Added for bug 5123027 by abraina
                    and (
                        start_date_time <= nvl(X_END_DATE_TIME,to_date('12/31/9999','mm/dd/yyyy'))
                    and
                        nvl(end_date_time,to_date('12/31/9999','mm/dd/yyyy')) >= X_START_DATE_TIME
                        ) ;

Line: 109

			SELECT 	JTF_CAL_EXCEPTIONS_S.nextval
			INTO	v_exception_id
			FROM 	dual;

Line: 114

		  insert into JTF_CAL_EXCEPTIONS_B (
		    OBJECT_VERSION_NUMBER,
		    EXCEPTION_ID,
		    START_DATE_TIME,
		    END_DATE_TIME,
		    EXCEPTION_CATEGORY,
		    ATTRIBUTE1,
		    ATTRIBUTE2,
		    ATTRIBUTE3,
		    ATTRIBUTE4,
		    ATTRIBUTE5,
		    ATTRIBUTE6,
		    ATTRIBUTE7,
		    ATTRIBUTE8,
		    ATTRIBUTE9,
		    ATTRIBUTE10,
		    ATTRIBUTE11,
		    ATTRIBUTE12,
		    ATTRIBUTE13,
		    ATTRIBUTE14,
		    ATTRIBUTE15,
		    ATTRIBUTE_CATEGORY,
		    CREATION_DATE,
		    CREATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_LOGIN
		  ) values (
		    1,
		    v_exception_id,
		    X_START_DATE_TIME,
		    X_END_DATE_TIME,
		    X_EXCEPTION_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_ATTRIBUTE_CATEGORY,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    SYSDATE,
		    FND_GLOBAL.USER_ID,
		    NULL
		  );

Line: 170

		  insert into JTF_CAL_EXCEPTIONS_TL (
		    EXCEPTION_ID,
		    EXCEPTION_NAME,
		    DESCRIPTION,
		    CREATION_DATE,
		    CREATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_LOGIN,
		    LANGUAGE,
		    SOURCE_LANG
		  ) select
		    v_exception_id,
		    X_EXCEPTION_NAME,
		    X_DESCRIPTION,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    SYSDATE,
		    FND_GLOBAL.USER_ID,
		    NULL,
		    L.LANGUAGE_CODE,
		    userenv('LANG')
		  from FND_LANGUAGES L
		  where L.INSTALLED_FLAG in ('I', 'B')
		  and not exists
		    (select NULL
		    from JTF_CAL_EXCEPTIONS_TL T
		    where T.EXCEPTION_ID = X_EXCEPTION_ID
		    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 209

end INSERT_ROW;

Line: 236

  cursor c is select
      OBJECT_VERSION_NUMBER,
      START_DATE_TIME,
      END_DATE_TIME,
      EXCEPTION_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY
    from JTF_CAL_EXCEPTIONS_B
    where EXCEPTION_ID = X_EXCEPTION_ID
    for update of EXCEPTION_ID nowait;

Line: 262

  cursor c1 is select
      EXCEPTION_NAME,
      DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_CAL_EXCEPTIONS_TL
    where EXCEPTION_ID = X_EXCEPTION_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of EXCEPTION_ID nowait;

Line: 275

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

Line: 342

procedure UPDATE_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_EXCEPTION_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in OUT NOCOPY NUMBER,
  X_START_DATE_TIME in DATE,
  X_END_DATE_TIME in DATE,
  X_EXCEPTION_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_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_EXCEPTION_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is

	v_error CHAR := 'N';

Line: 416

		   select count(*) into p_rec
		     from JTF_CAL_EXCEPTIONS_VL
		    where EXCEPTION_NAME = X_EXCEPTION_NAME
 		     -- Added for bug 5123027 by abraina
                      and (
                          start_date_time <= nvl(X_END_DATE_TIME,to_date('12/31/9999','mm/dd/yyyy'))
                      and
                          nvl(end_date_time,to_date('12/31/9999','mm/dd/yyyy')) >= X_START_DATE_TIME
                           )
                      AND exception_id <> X_EXCEPTION_ID;

Line: 441

		  update JTF_CAL_EXCEPTIONS_B set
		    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
		    START_DATE_TIME = X_START_DATE_TIME,
		    END_DATE_TIME = X_END_DATE_TIME,
		    EXCEPTION_CATEGORY = X_EXCEPTION_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,
		    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
		    LAST_UPDATE_DATE = sysdate,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
		    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
		  where EXCEPTION_ID = X_EXCEPTION_ID;

Line: 471

		  update
		 JTF_CAL_EXCEPTIONS_TL set
		    EXCEPTION_NAME = X_EXCEPTION_NAME,
		    DESCRIPTION = X_DESCRIPTION,
		    LAST_UPDATE_DATE = sysdate,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
	    	    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
		    SOURCE_LANG = userenv('LANG')
		  where EXCEPTION_ID = X_EXCEPTION_ID
		  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 486

end UPDATE_ROW;

Line: 492

 X_LAST_UPDATE_DATE in date,
 X_LAST_UPDATED_BY in number,
 X_LAST_UPDATE_LOGIN in number)
is
begin

Update JTF_CAL_EXCEPTIONS_TL set
exception_name		= nvl(X_EXCEPTION_NAME,exception_name),
description		= nvl(X_DESCRIPTION,description),
last_update_date	= nvl(x_last_update_date,sysdate),
last_updated_by		= x_last_updated_by,
last_update_login	= 0,
source_lang		= userenv('LANG')
where EXCEPTION_ID		= X_EXCEPTION_ID
and userenv('LANG') in (LANGUAGE,SOURCE_LANG);

Line: 510

procedure DELETE_ROW (
  X_EXCEPTION_ID in NUMBER
) is
begin
  delete from JTF_CAL_EXCEPTIONS_TL
  where EXCEPTION_ID = X_EXCEPTION_ID;

Line: 521

  delete from JTF_CAL_EXCEPTIONS_B
  where EXCEPTION_ID = X_EXCEPTION_ID;

Line: 527

end DELETE_ROW;

Line: 532

  delete from JTF_CAL_EXCEPTIONS_TL T
  where not exists
    (select NULL
    from JTF_CAL_EXCEPTIONS_B B
    where B.EXCEPTION_ID = T.EXCEPTION_ID
    );

Line: 539

  update JTF_CAL_EXCEPTIONS_TL T set (
      EXCEPTION_NAME,
      DESCRIPTION
    ) = (select
      B.EXCEPTION_NAME,
      B.DESCRIPTION
    from JTF_CAL_EXCEPTIONS_TL B
    where B.EXCEPTION_ID = T.EXCEPTION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.EXCEPTION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.EXCEPTION_ID,
      SUBT.LANGUAGE
    from JTF_CAL_EXCEPTIONS_TL SUBB, JTF_CAL_EXCEPTIONS_TL SUBT
    where SUBB.EXCEPTION_ID = SUBT.EXCEPTION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.EXCEPTION_NAME <> SUBT.EXCEPTION_NAME
      or (SUBB.EXCEPTION_NAME is null and SUBT.EXCEPTION_NAME is not null)
      or (SUBB.EXCEPTION_NAME is not null and SUBT.EXCEPTION_NAME is null)
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 565

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