APPS.JTF_CAL_RESOURCE_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_RESOURCE_ASSIGN_ID IN OUT NOCOPY NUMBER,
  X_OBJECT_VERSION_NUMBER IN NUMBER,
  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_START_DATE_TIME IN DATE,
  X_END_DATE_TIME IN DATE,
  X_CALENDAR_ID IN NUMBER,
  X_RESOURCE_ID IN NUMBER,
  X_RESOURCE_TYPE_CODE IN VARCHAR2,
  X_PRIMARY_CALENDAR_FLAG IN VARCHAR2,
  X_ATTRIBUTE1 IN VARCHAR2,
  X_ATTRIBUTE2 IN VARCHAR2,
  X_ATTRIBUTE3 IN VARCHAR2,
  X_ATTRIBUTE4 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_flag CHAR := 'F';

Line: 48

  CURSOR C IS SELECT ROWID FROM JTF_CAL_RESOURCE_ASSIGN
    WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID;

Line: 51

  CURSOR C_RES_NAME IS SELECT RESOURCE_NAME
    FROM  JTF_TASK_RESOURCES_VL
   WHERE   RESOURCE_ID = X_RESOURCE_ID
     AND   RESOURCE_TYPE = X_RESOURCE_TYPE_CODE;

Line: 56

  CURSOR C_CAL_NAME(p_calendar_id NUMBER) IS SELECT CALENDAR_NAME
    FROM  JTF_CALENDARS_TL
   WHERE   CALENDAR_ID = p_calendar_id
     AND   LANGUAGE=USERENV('LANG');

Line: 61

  CURSOR C_CAL_ID(p_primary_calendar_flag VARCHAR2) IS SELECT CALENDAR_ID
    FROM  JTF_CAL_RESOURCE_ASSIGN
   WHERE   resource_id = X_RESOURCE_ID
     AND   resource_type_code = X_RESOURCE_TYPE_CODE
     AND   primary_calendar_flag = p_primary_calendar_flag
     AND   (( X_START_DATE_TIME <=  start_date_time AND NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
                                                           >= NVL(end_date_time,l_temp_fnd_end_date) )
              OR  ( X_START_DATE_TIME BETWEEN  start_date_time AND  NVL(end_date_time,l_temp_fnd_end_date))
              OR  ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)   BETWEEN  start_date_time AND
                                                             NVL(end_date_time,l_temp_fnd_end_date))
              OR  ((X_START_DATE_TIME <  start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
                                                              > NVL(end_date_time,l_temp_fnd_end_date)))
              OR  ((X_START_DATE_TIME >  start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <
                                                                NVL(end_date_time,l_temp_fnd_end_date))));

Line: 143

                     SELECT jtf_cal_resource_assign_s.NEXTVAL
                     INTO   v_cal_resource_assign_id
                     FROM  dual;

Line: 149

	  INSERT INTO JTF_CAL_RESOURCE_ASSIGN (
	    OBJECT_VERSION_NUMBER,
	    ATTRIBUTE5,
	    ATTRIBUTE6,
	    ATTRIBUTE7,
	    ATTRIBUTE8,
	    ATTRIBUTE9,
	    ATTRIBUTE10,
	    ATTRIBUTE11,
	    ATTRIBUTE12,
	    ATTRIBUTE13,
	    ATTRIBUTE14,
	    ATTRIBUTE15,
	    ATTRIBUTE_CATEGORY,
	    CAL_RESOURCE_ASSIGN_ID,
	    START_DATE_TIME,
	    END_DATE_TIME,
	    CALENDAR_ID,
	    RESOURCE_ID,
        RESOURCE_TYPE_CODE,
	    PRIMARY_CALENDAR_FLAG,
	    CREATED_BY,
	    CREATION_DATE,
	    LAST_UPDATED_BY,
	    LAST_UPDATE_DATE,
	    LAST_UPDATE_LOGIN,
	    ATTRIBUTE1,
	    ATTRIBUTE2,
	    ATTRIBUTE3,
	    ATTRIBUTE4
	  ) VALUES
	  ( 1,
	    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,
	    v_CAL_RESOURCE_ASSIGN_ID,
	    X_START_DATE_TIME,
	    X_END_DATE_TIME,
	    X_CALENDAR_ID,
	    X_RESOURCE_ID,
         X_RESOURCE_TYPE_CODE,
	    X_PRIMARY_CALENDAR_FLAG,
	    Fnd_Global.USER_ID,
	    SYSDATE,
	    Fnd_Global.USER_ID,
	    SYSDATE,
	    NULL,
	    X_ATTRIBUTE1,
	    X_ATTRIBUTE2,
	    X_ATTRIBUTE3,
	    X_ATTRIBUTE4);

Line: 220

END INSERT_ROW;

Line: 247

  CURSOR c1 IS SELECT
      OBJECT_VERSION_NUMBER,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE_CATEGORY,
      START_DATE_TIME,
      END_DATE_TIME,
      CALENDAR_ID,
      RESOURCE_ID,
      PRIMARY_CALENDAR_FLAG,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      CAL_RESOURCE_ASSIGN_ID
    FROM JTF_CAL_RESOURCE_ASSIGN
    WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID
    FOR UPDATE OF CAL_RESOURCE_ASSIGN_ID NOWAIT;

Line: 330

PROCEDURE UPDATE_ROW (
  X_ERROR OUT NOCOPY VARCHAR2,
  X_CAL_RESOURCE_ASSIGN_ID IN NUMBER,
  X_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
  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_START_DATE_TIME IN DATE,
  X_END_DATE_TIME IN DATE,
  X_CALENDAR_ID IN NUMBER,
  X_RESOURCE_ID IN NUMBER,
  X_RESOURCE_TYPE_CODE IN VARCHAR2,
  X_PRIMARY_CALENDAR_FLAG IN VARCHAR2,
  X_ATTRIBUTE1 IN VARCHAR2,
  X_ATTRIBUTE2 IN VARCHAR2,
  X_ATTRIBUTE3 IN VARCHAR2,
  X_ATTRIBUTE4 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: 372

   CURSOR C_RES_NAME IS SELECT RESOURCE_NAME
     FROM  JTF_TASK_RESOURCES_VL
    WHERE   RESOURCE_ID = X_RESOURCE_ID
      AND   RESOURCE_TYPE = X_RESOURCE_TYPE_CODE;

Line: 377

   CURSOR C_CAL_NAME(p_calendar_id NUMBER) IS SELECT CALENDAR_NAME
     FROM JTF_CALENDARS_TL
    WHERE  CALENDAR_ID = p_calendar_id
      AND  LANGUAGE=USERENV('LANG');

Line: 382

   CURSOR C_CAL_ID(p_primary_calendar_flag VARCHAR2) IS SELECT CALENDAR_ID
     FROM  JTF_CAL_RESOURCE_ASSIGN
    WHERE   resource_id = X_RESOURCE_ID
      AND   resource_type_code = X_RESOURCE_TYPE_CODE
      AND   primary_calendar_flag = p_primary_calendar_flag
      AND   cal_resource_assign_id <> X_CAL_RESOURCE_ASSIGN_ID
      AND   (( X_START_DATE_TIME <=  start_date_time AND NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
                                                           >= NVL(end_date_time,l_temp_fnd_end_date) )
            OR  ( X_START_DATE_TIME BETWEEN  start_date_time AND  NVL(end_date_time,l_temp_fnd_end_date))
            OR  ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)   BETWEEN  start_date_time AND
                                                             NVL(end_date_time,l_temp_fnd_end_date))
            OR  ((X_START_DATE_TIME <  start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date)
                                                              > NVL(end_date_time,l_temp_fnd_end_date)))
            OR  ((X_START_DATE_TIME >  start_date_time) AND (NVL(X_END_DATE_TIME,l_temp_fnd_end_date) <
                                                                NVL(end_date_time,l_temp_fnd_end_date))));

Line: 471

  UPDATE JTF_CAL_RESOURCE_ASSIGN SET
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    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,
    START_DATE_TIME = X_START_DATE_TIME,
    END_DATE_TIME = X_END_DATE_TIME,
    CALENDAR_ID = X_CALENDAR_ID,
    RESOURCE_ID = X_RESOURCE_ID,
    PRIMARY_CALENDAR_FLAG = X_PRIMARY_CALENDAR_FLAG,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID,
    LAST_UPDATE_DATE = SYSDATE,
    LAST_UPDATED_BY = Fnd_Global.USER_ID,
    LAST_UPDATE_LOGIN = Fnd_Global.LOGIN_ID
  WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID;

Line: 504

END UPDATE_ROW;

Line: 506

PROCEDURE DELETE_ROW (
  X_CAL_RESOURCE_ASSIGN_ID IN NUMBER
) IS
BEGIN
  DELETE FROM JTF_CAL_RESOURCE_ASSIGN
  WHERE CAL_RESOURCE_ASSIGN_ID = X_CAL_RESOURCE_ASSIGN_ID;

Line: 517

END DELETE_ROW;

Line: 544

   SELECT resource_type_code,resource_id,start_date_time,end_date_time
   FROM JTF_CAL_RESOURCE_ASSIGN
   WHERE calendar_id = X_CALENDAR_ID
   AND resource_id = X_RESOURCE_ID
   AND RESOURCE_TYPE_CODE = X_RESOURCE_TYPE_CODE
   ORDER BY start_date_time
   ;

Line: 560

   SELECT COUNT(*) INTO temp_count
   FROM JTF_CAL_RESOURCE_ASSIGN
  WHERE calendar_id = X_CALENDAR_ID
   AND resource_id = X_RESOURCE_ID
   AND RESOURCE_TYPE_CODE = X_RESOURCE_TYPE_CODE
  AND TRUNC(start_date_time) = TRUNC(v_start_date_time)
  AND TRUNC(end_date_time) = TRUNC(v_end_date_time);