APPS.JTF_CAL_SHIFT_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_SHIFT_ASSIGN_ID in out NOCOPY NUMBER,
  X_SHIFT_START_DATE in DATE,
  X_SHIFT_END_DATE in DATE,
  X_CALENDAR_ID in NUMBER,
  X_SHIFT_SEQUENCE_NUMBER in NUMBER,
  X_SHIFT_ID in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE3 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
count_cal number;

Line: 43

     select count(*) into count_cal
     from jtf_cal_shift_assign
     where calendar_id = X_CALENDAR_ID;

Line: 48

         select count(*) into temp_count
	from jtf_cal_shift_assign
	where calendar_id = X_CALENDAR_ID
	and shift_id = X_SHIFT_ID
	and shift_start_date = TRUNC(X_SHIFT_START_DATE)
	and shift_end_date = TRUNC(X_SHIFT_END_DATE);

Line: 127

                     SELECT jtf_cal_shift_assign_s.nextval
                     INTO   v_jtf_cal_shift_assign_s
                     FROM dual;

Line: 133

	  insert into JTF_CAL_SHIFT_ASSIGN (
		    OBJECT_VERSION_NUMBER,
		    SHIFT_START_DATE,
		    SHIFT_END_DATE,
		    CAL_SHIFT_ASSIGN_ID,
		    CALENDAR_ID,
		    SHIFT_SEQUENCE_NUMBER,
		    SHIFT_ID,
		    CREATED_BY,
		    CREATION_DATE,
		    LAST_UPDATED_BY,
		    LAST_UPDATE_DATE,
		    LAST_UPDATE_LOGIN,
		    ATTRIBUTE1,
		    ATTRIBUTE2,
		    ATTRIBUTE4,
		    ATTRIBUTE5,
		    ATTRIBUTE3,
		    ATTRIBUTE6,
		    ATTRIBUTE7,
		    ATTRIBUTE8,
		    ATTRIBUTE9,
		    ATTRIBUTE10,
		    ATTRIBUTE11,
		    ATTRIBUTE12,
		    ATTRIBUTE13,
		    ATTRIBUTE14,
		    ATTRIBUTE15,
		    ATTRIBUTE_CATEGORY
		  ) values
		  ( 1,
	       	 X_SHIFT_START_DATE,
		    X_SHIFT_END_DATE,
		    v_jtf_cal_shift_assign_s,
		    X_CALENDAR_ID,
		    X_SHIFT_SEQUENCE_NUMBER,
		    X_SHIFT_ID,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    FND_GLOBAL.USER_ID,
		    sysdate,
		    FND_GLOBAL.LOGIN_ID,
		    X_ATTRIBUTE1,
		    X_ATTRIBUTE2,
		    X_ATTRIBUTE4,
		    X_ATTRIBUTE5,
		    X_ATTRIBUTE3,
		    X_ATTRIBUTE6,
		    X_ATTRIBUTE7,
		    X_ATTRIBUTE8,
		    X_ATTRIBUTE9,
		    X_ATTRIBUTE10,
		    X_ATTRIBUTE11,
		    X_ATTRIBUTE12,
		    X_ATTRIBUTE13,
		    X_ATTRIBUTE14,
		    X_ATTRIBUTE15,
		    X_ATTRIBUTE_CATEGORY);

Line: 200

end INSERT_ROW;

Line: 226

  cursor c1 is select
      SHIFT_START_DATE,
      SHIFT_END_DATE,
      CALENDAR_ID,
      SHIFT_SEQUENCE_NUMBER,
      SHIFT_ID,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE3,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      CAL_SHIFT_ASSIGN_ID
    from JTF_CAL_SHIFT_ASSIGN
    where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID
    for update of CAL_SHIFT_ASSIGN_ID nowait;

Line: 304

procedure UPDATE_ROW (
  X_ERROR out NOCOPY VARCHAR2,
  X_CAL_SHIFT_ASSIGN_ID in NUMBER,
  X_SHIFT_START_DATE in DATE,
  X_SHIFT_END_DATE in DATE,
  X_CALENDAR_ID in NUMBER,
  X_SHIFT_SEQUENCE_NUMBER in NUMBER,
  X_SHIFT_ID in NUMBER,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE3 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
	temp_count number;

Line: 338

         select count(*) into temp_count
	from jtf_cal_shift_assign
	where calendar_id = X_CALENDAR_ID
	and shift_id = X_SHIFT_ID
	and shift_start_date = TRUNC(X_SHIFT_START_DATE)
	and shift_end_date = TRUNC(X_SHIFT_END_DATE);

Line: 398

		  update JTF_CAL_SHIFT_ASSIGN set
                    object_version_number = object_version_number + 1,
		    SHIFT_START_DATE = X_SHIFT_START_DATE,
		    SHIFT_END_DATE = X_SHIFT_END_DATE,
		    CALENDAR_ID = X_CALENDAR_ID,
		    SHIFT_SEQUENCE_NUMBER = X_SHIFT_SEQUENCE_NUMBER,
		    SHIFT_ID = X_SHIFT_ID,
		    ATTRIBUTE1 = X_ATTRIBUTE1,
		    ATTRIBUTE2 = X_ATTRIBUTE2,
		    ATTRIBUTE4 = X_ATTRIBUTE4,
		    ATTRIBUTE5 = X_ATTRIBUTE5,
		    ATTRIBUTE3 = X_ATTRIBUTE3,
		    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_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID,
		    LAST_UPDATE_DATE = SYSDATE,
		    LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
		    LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
		  where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;

Line: 431

	end UPDATE_ROW;

Line: 433

procedure DELETE_ROW (
  X_CAL_SHIFT_ASSIGN_ID in NUMBER
) is
begin
  delete from JTF_CAL_SHIFT_ASSIGN
  where CAL_SHIFT_ASSIGN_ID = X_CAL_SHIFT_ASSIGN_ID;

Line: 444

end DELETE_ROW;

Line: 468

		select 'x'
		from   jtf_cal_shift_assign
		where  shift_id = X_SHIFT_ID
		and    shift_start_date = TRUNC(X_SHIFT_START_DATE)
		AND    shift_end_date = TRUNC(X_SHIFT_END_DATE)
		AND rownum < 2;

Line: 495

		select 'x'
		from   jtf_cal_shift_assign
		where  shift_id = X_SHIFT_ID
		and    shift_sequence_number = X_SHIFT_SEQUENCE_NUMBER
		AND rownum < 2;