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: 45

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

Line: 77

   	SELECT COUNT(*) INTO prime_flag_count FROM jtf_cal_resource_assign
        WHERE resource_id = X_RESOURCE_ID
        AND resource_type_code = X_RESOURCE_TYPE_CODE
        AND primary_calendar_flag = 'Y'
        -- Modified by jawang on 06/05/2002 to fix bug 2180182
        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: 119

        SELECT COUNT(*) INTO v_count FROM jtf_cal_resource_assign
        WHERE resource_id = X_RESOURCE_ID
        AND resource_type_code = X_RESOURCE_TYPE_CODE
        AND primary_calendar_flag = 'N'
        AND (( X_START_DATE_TIME <=  start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                                >= NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ( X_START_DATE_TIME BETWEEN  start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)   BETWEEN
                                              start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ((X_START_DATE_TIME <  start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                          > NVL(end_date_time,Fnd_Api.g_miss_date))));

Line: 153

                     SELECT jtf_cal_resource_assign_s.NEXTVAL
                     INTO   v_cal_resource_assign_id
                     FROM  dual;

Line: 159

	  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: 230

END INSERT_ROW;

Line: 257

  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: 340

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: 405

	SELECT COUNT(*) INTO prime_flag_count FROM jtf_cal_resource_assign
        WHERE resource_id = X_RESOURCE_ID
        AND resource_type_code = X_RESOURCE_TYPE_CODE
        AND primary_calendar_flag = 'Y'
        AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
        AND (( X_START_DATE_TIME <=  start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                                 >= NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ( X_START_DATE_TIME BETWEEN  start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)   BETWEEN  start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ((X_START_DATE_TIME <  start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date) >
                                                                  NVL(end_date_time,Fnd_Api.g_miss_date)))
         OR  ((X_START_DATE_TIME >  start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                          < NVL(end_date_time,Fnd_Api.g_miss_date))));

Line: 425

    SELECT COUNT(*) INTO v_count FROM jtf_cal_resource_assign
        WHERE resource_id = X_RESOURCE_ID
        AND resource_type_code = X_RESOURCE_TYPE_CODE
        AND primary_calendar_flag = 'N'
        AND CAL_RESOURCE_ASSIGN_ID <> X_CAL_RESOURCE_ASSIGN_ID
        AND (( X_START_DATE_TIME <=  start_date_time AND NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                                  >= NVL(end_date_time,Fnd_Api.g_miss_date))
         OR  ( X_START_DATE_TIME BETWEEN  start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ( NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)   BETWEEN
                                       start_date_time AND NVL(end_date_time,Fnd_Api.g_miss_date))
        OR  ((X_START_DATE_TIME <  start_date_time) AND (NVL(X_END_DATE_TIME,Fnd_Api.g_miss_date)
                                                                 > NVL(end_date_time,Fnd_Api.g_miss_date))));

Line: 461

  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: 494

END UPDATE_ROW;

Line: 496

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: 507

END DELETE_ROW;

Line: 534

   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: 550

   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);