APPS.WSH_CAL_ASG_PKG SQL Statements

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

Line: 36

  SELECT WSH_CALENDAR_ASSIGNMENTS_S.NextVal
  FROM   sys.dual;

Line: 103

    INSERT INTO WSH_CALENDAR_ASSIGNMENTS
             (CALENDAR_ASSIGNMENT_ID,
              CALENDAR_CODE,
              CALENDAR_TYPE,
              ASSOCIATION_TYPE,
              ENABLED_FLAG,
              ORGANIZATION_ID,
              LOCATION_ID,
              VENDOR_ID,
              VENDOR_SITE_ID,
              CUSTOMER_ID,
              CUSTOMER_SITE_USE_ID,
              FREIGHT_CODE,
              FREIGHT_ORG_ID,
              CARRIER_ID,
              CARRIER_SITE_ID,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_LOGIN,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15
             )
             VALUES
             (l_cal_id,
              p_cal_asg_info.calendar_code,
              p_cal_asg_info.calendar_type,
              p_cal_asg_info.association_type,
              p_cal_asg_info.enabled_flag,
              p_cal_asg_info.organization_id,
              p_cal_asg_info.location_id,
              p_cal_asg_info.vendor_id,
              p_cal_asg_info.vendor_site_id,
              p_cal_asg_info.customer_id,
              p_cal_asg_info.customer_site_use_id,
              p_cal_asg_info.freight_code,
              p_cal_asg_info.freight_org_id,
              p_cal_asg_info.carrier_id,
              p_cal_asg_info.carrier_site_id,
              sysdate,
              fnd_global.user_id,
              sysdate,
              fnd_global.user_id,
              fnd_global.login_id,
              p_cal_asg_info.ATTRIBUTE_CATEGORY,
              p_cal_asg_info.ATTRIBUTE1,
              p_cal_asg_info.ATTRIBUTE2,
              p_cal_asg_info.ATTRIBUTE3,
              p_cal_asg_info.ATTRIBUTE4,
              p_cal_asg_info.ATTRIBUTE5,
              p_cal_asg_info.ATTRIBUTE6,
              p_cal_asg_info.ATTRIBUTE7,
              p_cal_asg_info.ATTRIBUTE8,
              p_cal_asg_info.ATTRIBUTE9,
              p_cal_asg_info.ATTRIBUTE10,
              p_cal_asg_info.ATTRIBUTE11,
              p_cal_asg_info.ATTRIBUTE12,
              p_cal_asg_info.ATTRIBUTE13,
              p_cal_asg_info.ATTRIBUTE14,
              p_cal_asg_info.ATTRIBUTE15
              );

Line: 266

PROCEDURE Update_Cal_Asg
( p_api_version_number    IN  NUMBER
, p_init_msg_list         IN  VARCHAR2 := FND_API.G_FALSE
, p_calendar_asgmt_id     IN  NUMBER
, p_cal_asg_info          IN  CalAsgRecType DEFAULT NULL
, x_return_status         OUT NOCOPY  VARCHAR2
, x_msg_count             OUT NOCOPY  NUMBER
, x_msg_data              OUT NOCOPY  VARCHAR2
) IS
  l_api_version_number CONSTANT NUMBER := 1.0;

Line: 276

  l_api_name           CONSTANT VARCHAR2(30):= 'Update_Cal_Asg';

Line: 281

  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CAL_ASG';

Line: 322

  UPDATE WSH_CALENDAR_ASSIGNMENTS
  SET ENABLED_FLAG       = p_cal_asg_info.enabled_flag
    , CALENDAR_CODE      = p_cal_asg_info.calendar_code
    , ATTRIBUTE_CATEGORY = p_cal_asg_info.ATTRIBUTE_CATEGORY
    , ATTRIBUTE1         = p_cal_asg_info.ATTRIBUTE1
    , ATTRIBUTE2         = p_cal_asg_info.ATTRIBUTE2
    , ATTRIBUTE3         = p_cal_asg_info.ATTRIBUTE3
    , ATTRIBUTE4         = p_cal_asg_info.ATTRIBUTE4
    , ATTRIBUTE5         = p_cal_asg_info.ATTRIBUTE5
    , ATTRIBUTE6         = p_cal_asg_info.ATTRIBUTE6
    , ATTRIBUTE7         = p_cal_asg_info.ATTRIBUTE7
    , ATTRIBUTE8         = p_cal_asg_info.ATTRIBUTE8
    , ATTRIBUTE9         = p_cal_asg_info.ATTRIBUTE9
    , ATTRIBUTE10        = p_cal_asg_info.ATTRIBUTE10
    , ATTRIBUTE11        = p_cal_asg_info.ATTRIBUTE11
    , ATTRIBUTE12        = p_cal_asg_info.ATTRIBUTE12
    , ATTRIBUTE13        = p_cal_asg_info.ATTRIBUTE13
    , ATTRIBUTE14        = p_cal_asg_info.ATTRIBUTE14
    , ATTRIBUTE15        = p_cal_asg_info.ATTRIBUTE15
    , LAST_UPDATE_DATE   = sysdate
    , LAST_UPDATED_BY    = FND_GLOBAL.user_id
    , LAST_UPDATE_LOGIN  = FND_GLOBAL.login_id
  WHERE CALENDAR_ASSIGNMENT_ID = p_calendar_asgmt_id;

Line: 402

      , 'Update_Cal_Asg'
      );

Line: 418

END Update_Cal_Asg;

Line: 432

  SELECT CALENDAR_CODE,
         ENABLED_FLAG,
	 ATTRIBUTE_CATEGORY,
         ATTRIBUTE1,
         ATTRIBUTE2,
         ATTRIBUTE3,
         ATTRIBUTE4,
         ATTRIBUTE5,
         ATTRIBUTE6,
         ATTRIBUTE7,
         ATTRIBUTE8,
         ATTRIBUTE9,
         ATTRIBUTE10,
         ATTRIBUTE11,
         ATTRIBUTE12,
         ATTRIBUTE13,
         ATTRIBUTE14,
         ATTRIBUTE15
  FROM wsh_calendar_assignments
  WHERE calendar_assignment_id = p_calendar_assignment_id
  FOR UPDATE OF calendar_assignment_id NOWAIT;

Line: 500

     FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 580

PROCEDURE Delete_Cal_Asg
( p_api_version_number IN  NUMBER
, p_init_msg_list      IN  VARCHAR2 := FND_API.G_FALSE
, x_return_status      OUT NOCOPY  VARCHAR2
, x_msg_count          OUT NOCOPY  NUMBER
, x_msg_data           OUT NOCOPY  VARCHAR2
, p_calendar_assignment_id IN  NUMBER
) IS

  l_debug_on BOOLEAN;

Line: 591

  l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELETE_CAL_ASG';

Line: 614

        DELETE FROM wsh_calendar_assignments
        WHERE  calendar_assignment_id = p_calendar_assignment_id;

Line: 624

END Delete_Cal_Asg;