APPS.CN_INTEL_CALC_PKG SQL Statements

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

Line: 16

procedure insert_row (
		      x_srp_intel_period_id                IN NUMBER,
		      x_salesrep_id                        IN NUMBER,
		      x_org_id                             IN NUMBER,
		      x_period_id                          IN NUMBER,
		      x_processing_status_code             IN VARCHAR2,
		      x_process_all_flag                   IN VARCHAR2,
		      x_attribute_category                 IN VARCHAR2 := null,
		      x_attribute1                         IN VARCHAR2 := null,
		      x_attribute2                         IN VARCHAR2 := null,
		      x_attribute3                         IN VARCHAR2 := null,
		      x_attribute4                         IN VARCHAR2 := null,
		      x_attribute5                         IN VARCHAR2 := null,
		      x_attribute6                         IN VARCHAR2 := null,
		      x_attribute7                         IN VARCHAR2 := null,
		      x_attribute8                         IN VARCHAR2 := null,
		      x_attribute9                         IN VARCHAR2 := null,
		      x_attribute10                        IN VARCHAR2 := null,
		      x_attribute11                        IN VARCHAR2 := null,
		      x_attribute12                        IN VARCHAR2 := null,
		      x_attribute13                        IN VARCHAR2 := null,
		      x_attribute14                        IN VARCHAR2 := null,
                      x_attribute15                        IN VARCHAR2 := null,
                      x_creation_date                      IN DATE := sysdate,
                      x_created_by                         IN NUMBER := fnd_global.user_id,
                      x_last_update_date                   IN DATE := sysdate,
                      x_last_updated_by                    IN NUMBER := fnd_global.user_id,
                      x_last_update_login                  IN NUMBER := fnd_global.login_id,
                      x_start_date                         IN DATE := null,
                      x_end_date                           IN DATE := null
  ) IS
     l_srp_intel_period_id NUMBER(15);

Line: 50

	SELECT cn_srp_intel_periods_s.NEXTVAL
	FROM dual;

Line: 52

     CURSOR c IS SELECT ROWID FROM cn_srp_intel_periods
       WHERE srp_intel_period_id = l_srp_intel_period_id;

Line: 55

	SELECT srp_intel_period_id
	  FROM cn_srp_intel_periods
	  WHERE period_id = x_period_id
	  AND salesrep_id = x_salesrep_id
	  AND org_id      = x_org_id;

Line: 77

   INSERT INTO cn_srp_intel_periods (
      srp_intel_period_id,
      salesrep_id,
      org_id,
      period_id,
      processing_status_code,
      process_all_flag,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login,
      start_date,
      end_date
      ) VALUES (
      l_srp_intel_period_id,
      x_salesrep_id,
      x_org_id,
      x_period_id,
      x_processing_status_code,
      x_process_all_flag,
      x_attribute_category,
      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_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      x_start_date,
      x_end_date
     );

Line: 147

END insert_row;

Line: 175

     CURSOR c IS SELECT
       salesrep_id,
       period_id,
       processing_status_code,
       process_all_flag,
       start_date,
       end_date,
       attribute_category,
       attribute1,
       attribute2,
       attribute3,
       attribute4,
       attribute5,
       attribute6,
       attribute7,
       attribute8,
       attribute9,
       attribute10,
       attribute11,
       attribute12,
       attribute13,
       attribute14,
       attribute15
       FROM cn_srp_intel_periods
       WHERE srp_intel_period_id = x_srp_intel_period_id
       FOR UPDATE OF srp_intel_period_id nowait;

Line: 207

      fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 297

PROCEDURE update_row (
		    x_srp_intel_period_id             IN NUMBER,
		    x_salesrep_id                     IN NUMBER,
		    x_period_id                       IN NUMBER,
		    x_start_date                      IN DATE,
		    x_end_date                        IN DATE,
		    x_processing_status_code          IN VARCHAR2,
		    x_process_all_flag                IN VARCHAR2,
		    x_attribute_category              IN VARCHAR2,
		    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_last_update_date                IN DATE,
                    x_last_updated_by                 IN NUMBER,
                    x_last_update_login               IN NUMBER) IS
BEGIN
   UPDATE cn_srp_intel_periods SET
     salesrep_id = x_salesrep_id,
     period_id = x_period_id,
     start_date = x_start_date,
     end_date = x_end_date,
     processing_status_code = x_processing_status_code,
     process_all_flag = x_process_all_flag,
     attribute_category = x_attribute_category,
     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,
     last_update_date = x_last_update_date,
     last_updated_by = x_last_updated_by,
     last_update_login = x_last_update_login
     WHERE srp_intel_period_id = x_srp_intel_period_id;

Line: 357

END update_row;

Line: 359

PROCEDURE delete_row (
		      x_srp_intel_period_id           IN NUMBER
		      ) IS
BEGIN
   DELETE FROM cn_srp_intel_periods
     WHERE srp_intel_period_id = x_srp_intel_period_id;

Line: 370

END delete_row;