APPS.JTF_CAL_EXCEPTION_ASSIGN_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_CAL_EXCEPTION_ASSIGN_ID in out NOCOPY NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_EXCEPTION_REASON in VARCHAR2,
  X_CALENDAR_ID in NUMBER,
  X_EXCEPTION_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  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_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 JTF_CAL_EXCEPTION_ASSIGN
    where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID;

Line: 88

                      SELECT jtf_cal_exception_assign_s.nextval
                      INTO   v_cal_exception_assign_id_s
                      FROM   dual;

Line: 93

		  insert into JTF_CAL_EXCEPTION_ASSIGN (
		    OBJECT_VERSION_NUMBER,
		    CAL_EXCEPTION_ASSIGN_ID,
		    EXCEPTION_REASON,
		    CALENDAR_ID,
		    EXCEPTION_ID,
		    START_DATE_ACTIVE,
		    END_DATE_ACTIVE,
		    CREATED_BY,
		    CREATION_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATE_LOGIN,
		    ATTRIBUTE1,
		    ATTRIBUTE2,
		    ATTRIBUTE3,
		    ATTRIBUTE4,
		    ATTRIBUTE5,
		    ATTRIBUTE6,
		    ATTRIBUTE7,
		    ATTRIBUTE8,
		    ATTRIBUTE9,
		    ATTRIBUTE10,
		    ATTRIBUTE11,
		    ATTRIBUTE12,
		    ATTRIBUTE13,
		    ATTRIBUTE14,
		    ATTRIBUTE15,
		    ATTRIBUTE_CATEGORY
		  ) values
		  ( 1,
		    v_CAL_EXCEPTION_ASSIGN_ID_S,
		    X_EXCEPTION_REASON,
		    X_CALENDAR_ID,
		    X_EXCEPTION_ID,
		    X_START_DATE_ACTIVE,
		    X_END_DATE_ACTIVE,
		    FND_GLOBAL.USER_ID,
	            sysdate,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    NULL,
		    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);

Line: 160

end INSERT_ROW;

Line: 187

  cursor c1 is select
      OBJECT_VERSION_NUMBER,
      EXCEPTION_REASON,
      CALENDAR_ID,
      EXCEPTION_ID,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      CAL_EXCEPTION_ASSIGN_ID
    from JTF_CAL_EXCEPTION_ASSIGN
    where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID
    for update of CAL_EXCEPTION_ASSIGN_ID nowait;

Line: 271

procedure UPDATE_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_CAL_EXCEPTION_ASSIGN_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in OUT NOCOPY NUMBER,
  X_EXCEPTION_REASON in VARCHAR2,
  X_CALENDAR_ID in NUMBER,
  X_EXCEPTION_ID in NUMBER,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  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_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
	v_error CHAR := 'N';

Line: 305

		SELECT 	count(*)
        	INTO v_count
		FROM   	jtf_cal_exception_assign
		WHERE calendar_id = X_CALENDAR_ID
          	and exception_id = X_EXCEPTION_ID;

Line: 347

		  update JTF_CAL_EXCEPTION_ASSIGN set
		    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
		    EXCEPTION_REASON = X_EXCEPTION_REASON,
		    CALENDAR_ID = X_CALENDAR_ID,
		    EXCEPTION_ID = X_EXCEPTION_ID,
		    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
		    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
		    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,
		    CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID,
		    LAST_UPDATE_DATE = sysdate,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
		    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
		  where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID;

Line: 380

end UPDATE_ROW;

Line: 382

procedure DELETE_ROW (
  X_CAL_EXCEPTION_ASSIGN_ID in NUMBER
) is
begin
  delete from JTF_CAL_EXCEPTION_ASSIGN
  where CAL_EXCEPTION_ASSIGN_ID = X_CAL_EXCEPTION_ASSIGN_ID;

Line: 393

end DELETE_ROW;

Line: 418

		select 	'x'
		from   	jtf_cal_exception_assign
		where calendar_id = X_CALENDAR_ID
        and exception_id = X_EXCEPTION_ID
--		and exception_reason= X_EXCEPTION_REASON
 --       and (( X_START_DATE_ACTIVE <=  start_date_active and nvl(X_END_DATE_ACTIVE,'31-DEC-4712')  >= end_date_active )
  --      OR  ( X_START_DATE_ACTIVE BETWEEN  start_date_active and end_date_active)
   --     OR  ( nvl(X_END_DATE_ACTIVE,'31-DEC-4712')   BETWEEN  start_date_active and end_date_active)
    --    OR  ((X_START_DATE_ACTIVE <  start_date_active) AND (nvl(X_END_DATE_ACTIVE,'31-DEC-4712') > end_date_active )))
		AND rownum < 2;