eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SEC_PROF_ASSIGNS_PKG SQL Statements

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

Line: 18


   SELECT cn_sec_prof_assigns_s.NEXTVAL
     INTO x_sec_prof_assign_id
     FROM dual;

Line: 23


PROCEDURE Insert_Row( x_new_rec IN OUT sec_prof_assign_rec_type) IS
   CURSOR c IS
      SELECT 1
	FROM cn_sec_prof_assigns
	WHERE sec_prof_assign_id = x_new_rec.sec_prof_assign_id;

Line: 34


   SELECT
     Decode(x_new_rec.end_date,
	    fnd_api.g_miss_date, NULL,
	    x_new_rec.end_date),
     Decode(x_new_rec.attribute_category,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute_category),
     Decode(x_new_rec.attribute1,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute1),
     Decode(x_new_rec.attribute2,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute2),
     Decode(x_new_rec.attribute3,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute3),
     Decode(x_new_rec.attribute4,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute4),
     Decode(x_new_rec.attribute5,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute5),
     Decode(x_new_rec.attribute6,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute6),
     Decode(x_new_rec.attribute7,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute7),
     Decode(x_new_rec.attribute8,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute8),
     Decode(x_new_rec.attribute9,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute9),
     Decode(x_new_rec.attribute10,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute10),
     Decode(x_new_rec.attribute11,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute11),
     Decode(x_new_rec.attribute12,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute12),
     Decode(x_new_rec.attribute13,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute13),
     Decode(x_new_rec.attribute14,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute14),
     Decode(x_new_rec.attribute15,
	    fnd_api.g_miss_char, NULL,
	    x_new_rec.attribute15),
     Decode(x_new_rec.created_by,
	    cn_api.g_miss_id, g_created_by,
	    x_new_rec.created_by),
     Decode(x_new_rec.creation_date,
	    fnd_api.g_miss_date, g_creation_date,
	    x_new_rec.creation_date),
     Decode(x_new_rec.last_update_login,
	    cn_api.g_miss_id, g_last_update_login,
	    x_new_rec.last_update_login),
     Decode(x_new_rec.last_update_date,
	    fnd_api.g_miss_date, g_last_update_date,
	    x_new_rec.last_update_date),
     Decode(x_new_rec.last_updated_by,
	    cn_api.g_miss_id, g_last_updated_by,
	    x_new_rec.last_updated_by)
     INTO
     x_new_rec.end_date,
     x_new_rec.attribute_category,
     x_new_rec.attribute1,
     x_new_rec.attribute2,
     x_new_rec.attribute3,
     x_new_rec.attribute4,
     x_new_rec.attribute5,
     x_new_rec.attribute6,
     x_new_rec.attribute7,
     x_new_rec.attribute8,
     x_new_rec.attribute9,
     x_new_rec.attribute10,
     x_new_rec.attribute11,
     x_new_rec.attribute12,
     x_new_rec.attribute13,
     x_new_rec.attribute14,
     x_new_rec.attribute15,
     x_new_rec.created_by,
     x_new_rec.creation_date,
     x_new_rec.last_update_login,
     x_new_rec.last_update_date,
     x_new_rec.last_updated_by
     FROM dual;

Line: 126


   INSERT INTO cn_sec_prof_assigns
     (sec_prof_assign_id,
      security_profile_id,
      salesrep_id,
      start_date,
      end_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_update_login,
      last_update_date,
      last_updated_by
      )
     VALUES
     (x_new_rec.sec_prof_assign_id,
      x_new_rec.security_profile_id,
      x_new_rec.salesrep_id,
      x_new_rec.start_date,
      x_new_rec.end_date,
      x_new_rec.attribute_category,
      x_new_rec.attribute1,
      x_new_rec.attribute2,
      x_new_rec.attribute3,
      x_new_rec.attribute4,
      x_new_rec.attribute5,
      x_new_rec.attribute6,
      x_new_rec.attribute7,
      x_new_rec.attribute8,
      x_new_rec.attribute9,
      x_new_rec.attribute10,
      x_new_rec.attribute11,
      x_new_rec.attribute12,
      x_new_rec.attribute13,
      x_new_rec.attribute14,
      x_new_rec.attribute15,
      x_new_rec.created_by,
      x_new_rec.creation_date,
      x_new_rec.last_update_login,
      x_new_rec.last_update_date,
      x_new_rec.last_updated_by
      );

Line: 191


END Insert_Row;

Line: 193


PROCEDURE Update_Row(x_new_rec  sec_prof_assign_rec_type) IS
     CURSOR c IS
	SELECT *
	  FROM cn_sec_prof_assigns
	  WHERE sec_prof_assign_id = x_new_rec.sec_prof_assign_id
	  FOR UPDATE OF sec_prof_assign_id nowait;

Line: 208


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

Line: 212


   SELECT
     Decode(x_new_rec.security_profile_id,
	    cn_api.g_miss_id, rec.security_profile_id,
	    x_new_rec.security_profile_id),
     Decode(x_new_rec.salesrep_id,
	    cn_api.g_miss_id, rec.salesrep_id,
	    x_new_rec.salesrep_id),
     Decode(x_new_rec.start_date,
	    fnd_api.g_miss_date, rec.start_date,
	    x_new_rec.start_date),
     Decode(x_new_rec.end_date,
	    fnd_api.g_miss_date, rec.end_date,
	    x_new_rec.end_date),
     Decode(x_new_rec.attribute_category,
	    fnd_api.g_miss_char, rec.attribute_category,
	    x_new_rec.attribute_category),
     Decode(x_new_rec.attribute1,
	    fnd_api.g_miss_char, rec.attribute1,
	    x_new_rec.attribute1),
     Decode(x_new_rec.attribute2,
	    fnd_api.g_miss_char, rec.attribute2,
	    x_new_rec.attribute2),
     Decode(x_new_rec.attribute3,
	    fnd_api.g_miss_char, rec.attribute3,
	    x_new_rec.attribute3),
     Decode(x_new_rec.attribute4,
	    fnd_api.g_miss_char, rec.attribute4,
	    x_new_rec.attribute4),
     Decode(x_new_rec.attribute5,
	    fnd_api.g_miss_char, rec.attribute5,
	    x_new_rec.attribute5),
     Decode(x_new_rec.attribute6,
	    fnd_api.g_miss_char, rec.attribute6,
	    x_new_rec.attribute6),
     Decode(x_new_rec.attribute7,
	    fnd_api.g_miss_char, rec.attribute7,
	    x_new_rec.attribute7),
     Decode(x_new_rec.attribute8,
	    fnd_api.g_miss_char, rec.attribute8,
	    x_new_rec.attribute8),
     Decode(x_new_rec.attribute9,
	    fnd_api.g_miss_char, rec.attribute9,
	    x_new_rec.attribute9),
     Decode(x_new_rec.attribute10,
	    fnd_api.g_miss_char, rec.attribute10,
	    x_new_rec.attribute10),
     Decode(x_new_rec.attribute11,
	    fnd_api.g_miss_char, rec.attribute11,
	    x_new_rec.attribute11),
     Decode(x_new_rec.attribute12,
	    fnd_api.g_miss_char, rec.attribute12,
	    x_new_rec.attribute12),
     Decode(x_new_rec.attribute13,
	    fnd_api.g_miss_char, rec.attribute13,
	    x_new_rec.attribute13),
     Decode(x_new_rec.attribute14,
	    fnd_api.g_miss_char, rec.attribute14,
	    x_new_rec.attribute14),
     Decode(x_new_rec.attribute15,
	    fnd_api.g_miss_char, rec.attribute15,
	    x_new_rec.attribute15),
     Decode(x_new_rec.last_update_login,
	    cn_api.g_miss_id, g_last_update_login,
	    x_new_rec.last_update_login),
     Decode(x_new_rec.last_update_date,
	    fnd_api.g_miss_date, g_last_update_date,
	    x_new_rec.last_update_date),
     Decode(x_new_rec.last_updated_by,
	    cn_api.g_miss_id, g_last_updated_by,
	    x_new_rec.last_updated_by)
     INTO
     rec.security_profile_id,
     rec.salesrep_id,
     rec.start_date,
     rec.end_date,
     rec.attribute_category,
     rec.attribute1,
     rec.attribute2,
     rec.attribute3,
     rec.attribute4,
     rec.attribute5,
     rec.attribute6,
     rec.attribute7,
     rec.attribute8,
     rec.attribute9,
     rec.attribute10,
     rec.attribute11,
     rec.attribute12,
     rec.attribute13,
     rec.attribute14,
     rec.attribute15,
     rec.last_update_login,
     rec.last_update_date,
     rec.last_updated_by
     FROM dual;

Line: 308


   UPDATE cn_sec_prof_assigns SET
     security_profile_id = rec.security_profile_id,
     salesrep_id = rec.salesrep_id,
     start_date = rec.start_date,
     end_date   = rec.end_date,
     attribute_category = rec.attribute_category,
     attribute1 = rec.attribute1,
     attribute2 = rec.attribute2,
     attribute3 = rec.attribute3,
     attribute4 = rec.attribute4,
     attribute5 = rec.attribute5,
     attribute6 = rec.attribute6,
     attribute7 = rec.attribute7,
     attribute8 = rec.attribute8,
     attribute9 = rec.attribute9,
     attribute10 = rec.attribute10,
     attribute11 = rec.attribute11,
     attribute12 = rec.attribute12,
     attribute13 = rec.attribute13,
     attribute14 = rec.attribute14,
     attribute15 = rec.attribute15,
     last_update_login = rec.last_update_login,
     last_update_date = rec.last_update_date,
     last_updated_by = rec.last_updated_by
     WHERE sec_prof_assign_id = x_new_rec.sec_prof_assign_id;

Line: 338


END Update_Row;

Line: 342


      SELECT *
	FROM cn_sec_prof_assigns
	WHERE sec_prof_assign_id = x_rec.sec_prof_assign_id
	FOR UPDATE OF sec_prof_assign_id nowait;

Line: 354


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

Line: 440


PROCEDURE Delete_Row(x_sec_prof_assign_id                NUMBER) IS
BEGIN
   DELETE cn_sec_prof_assigns
     WHERE sec_prof_assign_id = x_sec_prof_assign_id;

Line: 449


END Delete_Row;