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.CSI_II_RELATIONSHIPS_PKG SQL Statements

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

Line: 14


PROCEDURE insert_row(
          px_relationship_id   IN OUT NOCOPY NUMBER,
          p_relationship_type_code    VARCHAR2,
          p_object_id                 NUMBER,
          p_subject_id                NUMBER,
          p_position_reference        VARCHAR2,
          p_active_start_date         DATE,
          p_active_end_date           DATE,
          p_display_order             NUMBER,
          p_mandatory_flag            VARCHAR2,
          p_context                   VARCHAR2,
          p_attribute1                VARCHAR2,
          p_attribute2                VARCHAR2,
          p_attribute3                VARCHAR2,
          p_attribute4                VARCHAR2,
          p_attribute5                VARCHAR2,
          p_attribute6                VARCHAR2,
          p_attribute7                VARCHAR2,
          p_attribute8                VARCHAR2,
          p_attribute9                VARCHAR2,
          p_attribute10               VARCHAR2,
          p_attribute11               VARCHAR2,
          p_attribute12               VARCHAR2,
          p_attribute13               VARCHAR2,
          p_attribute14               VARCHAR2,
          p_attribute15               VARCHAR2,
          p_created_by                NUMBER,
          p_creation_date             DATE,
          p_last_updated_by           NUMBER,
          p_last_update_date          DATE,
          p_last_update_login         NUMBER,
          p_object_version_number     NUMBER)

 IS
CURSOR c2 IS SELECT csi_ii_relationships_s.NEXTVAL FROM sys.dual;

Line: 56


   INSERT INTO csi_ii_relationships(
           relationship_id,
           relationship_type_code,
           object_id,
           subject_id,
           position_reference,
           active_start_date,
           active_end_date,
           display_order,
           mandatory_flag,
           context,
           attribute1,
           attribute2,
           attribute3,
           attribute4,
           attribute5,
           attribute6,
           attribute7,
           attribute8,
           attribute9,
           attribute10,
           attribute11,
           attribute12,
           attribute13,
           attribute14,
           attribute15,
           created_by,
           creation_date,
           last_updated_by,
           last_update_date,
           last_update_login,
           object_version_number
          ) VALUES (
           px_relationship_id,
           decode( p_relationship_type_code, fnd_api.g_miss_char, NULL, p_relationship_type_code),
           decode( p_object_id, fnd_api.g_miss_num, NULL, p_object_id),
           decode( p_subject_id, fnd_api.g_miss_num, NULL, p_subject_id),
           decode( p_position_reference, fnd_api.g_miss_char, NULL, p_position_reference),
           decode( p_active_start_date, fnd_api.g_miss_date, to_date(NULL), p_active_start_date),
           decode( p_active_end_date, fnd_api.g_miss_date, to_date(NULL), p_active_end_date),
           decode( p_display_order, fnd_api.g_miss_num, NULL, p_display_order),
           decode( p_mandatory_flag, fnd_api.g_miss_char, NULL, p_mandatory_flag),
           decode( p_context, fnd_api.g_miss_char, NULL, p_context),
           decode( p_attribute1, fnd_api.g_miss_char, NULL, p_attribute1),
           decode( p_attribute2, fnd_api.g_miss_char, NULL, p_attribute2),
           decode( p_attribute3, fnd_api.g_miss_char, NULL, p_attribute3),
           decode( p_attribute4, fnd_api.g_miss_char, NULL, p_attribute4),
           decode( p_attribute5, fnd_api.g_miss_char, NULL, p_attribute5),
           decode( p_attribute6, fnd_api.g_miss_char, NULL, p_attribute6),
           decode( p_attribute7, fnd_api.g_miss_char, NULL, p_attribute7),
           decode( p_attribute8, fnd_api.g_miss_char, NULL, p_attribute8),
           decode( p_attribute9, fnd_api.g_miss_char, NULL, p_attribute9),
           decode( p_attribute10, fnd_api.g_miss_char, NULL, p_attribute10),
           decode( p_attribute11, fnd_api.g_miss_char, NULL, p_attribute11),
           decode( p_attribute12, fnd_api.g_miss_char, NULL, p_attribute12),
           decode( p_attribute13, fnd_api.g_miss_char, NULL, p_attribute13),
           decode( p_attribute14, fnd_api.g_miss_char, NULL, p_attribute14),
           decode( p_attribute15, fnd_api.g_miss_char, NULL, p_attribute15),
           decode( p_created_by, fnd_api.g_miss_num, NULL, p_created_by),
           decode( p_creation_date, fnd_api.g_miss_date, to_date(NULL), p_creation_date),
           decode( p_last_updated_by, fnd_api.g_miss_num, NULL, p_last_updated_by),
           decode( p_last_update_date, fnd_api.g_miss_date, to_date(NULL), p_last_update_date),
           decode( p_last_update_login, fnd_api.g_miss_num, NULL, p_last_update_login),
           decode( p_object_version_number, fnd_api.g_miss_num, NULL, p_object_version_number));

Line: 123


END insert_row;

Line: 125


PROCEDURE update_row(
          p_relationship_id             NUMBER,
          p_relationship_type_code      VARCHAR2,
          p_object_id                   NUMBER,
          p_subject_id                  NUMBER,
          p_position_reference          VARCHAR2,
          p_active_start_date           DATE,
          p_active_end_date             DATE,
          p_display_order               NUMBER,
          p_mandatory_flag              VARCHAR2,
          p_context                     VARCHAR2,
          p_attribute1                  VARCHAR2,
          p_attribute2                  VARCHAR2,
          p_attribute3                  VARCHAR2,
          p_attribute4                  VARCHAR2,
          p_attribute5                  VARCHAR2,
          p_attribute6                  VARCHAR2,
          p_attribute7                  VARCHAR2,
          p_attribute8                  VARCHAR2,
          p_attribute9                  VARCHAR2,
          p_attribute10                 VARCHAR2,
          p_attribute11                 VARCHAR2,
          p_attribute12                 VARCHAR2,
          p_attribute13                 VARCHAR2,
          p_attribute14                 VARCHAR2,
          p_attribute15                 VARCHAR2,
          p_created_by                  NUMBER,
          p_creation_date               DATE,
          p_last_updated_by             NUMBER,
          p_last_update_date            DATE,
          p_last_update_login           NUMBER,
          p_object_version_number       NUMBER)

 IS
 BEGIN
    update csi_ii_relationships
    set
              relationship_type_code = decode( p_relationship_type_code, fnd_api.g_miss_char, relationship_type_code, p_relationship_type_code),
              object_id = decode( p_object_id, fnd_api.g_miss_num, object_id, p_object_id),
              subject_id = decode( p_subject_id, fnd_api.g_miss_num, subject_id, p_subject_id),
              position_reference = decode( p_position_reference, fnd_api.g_miss_char, position_reference, p_position_reference),
              active_start_date = decode( p_active_start_date, fnd_api.g_miss_date, active_start_date, p_active_start_date),
              active_end_date = decode( p_active_end_date, fnd_api.g_miss_date, active_end_date, p_active_end_date),
              display_order = decode( p_display_order, fnd_api.g_miss_num, display_order, p_display_order),
              mandatory_flag = decode( p_mandatory_flag, fnd_api.g_miss_char, mandatory_flag, p_mandatory_flag),
              context = decode( p_context, fnd_api.g_miss_char, context, p_context),
              attribute1 = decode( p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1),
              attribute2 = decode( p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2),
              attribute3 = decode( p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3),
              attribute4 = decode( p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4),
              attribute5 = decode( p_attribute5, fnd_api.g_miss_char, attribute5, p_attribute5),
              attribute6 = decode( p_attribute6, fnd_api.g_miss_char, attribute6, p_attribute6),
              attribute7 = decode( p_attribute7, fnd_api.g_miss_char, attribute7, p_attribute7),
              attribute8 = decode( p_attribute8, fnd_api.g_miss_char, attribute8, p_attribute8),
              attribute9 = decode( p_attribute9, fnd_api.g_miss_char, attribute9, p_attribute9),
              attribute10 = decode( p_attribute10, fnd_api.g_miss_char, attribute10, p_attribute10),
              attribute11 = decode( p_attribute11, fnd_api.g_miss_char, attribute11, p_attribute11),
              attribute12 = decode( p_attribute12, fnd_api.g_miss_char, attribute12, p_attribute12),
              attribute13 = decode( p_attribute13, fnd_api.g_miss_char, attribute13, p_attribute13),
              attribute14 = decode( p_attribute14, fnd_api.g_miss_char, attribute14, p_attribute14),
              attribute15 = decode( p_attribute15, fnd_api.g_miss_char, attribute15, p_attribute15),
              created_by = decode( p_created_by, fnd_api.g_miss_num, created_by, p_created_by),
              creation_date = decode( p_creation_date, fnd_api.g_miss_date, creation_date, p_creation_date),
              last_updated_by = decode( p_last_updated_by, fnd_api.g_miss_num, last_updated_by, p_last_updated_by),
              last_update_date = decode( p_last_update_date, fnd_api.g_miss_date, last_update_date, p_last_update_date),
              last_update_login = decode( p_last_update_login, fnd_api.g_miss_num, last_update_login, p_last_update_login),
              object_version_number = object_version_number+1
              --object_version_number = decode( p_object_version_number, fnd_api.g_miss_num, object_version_number, p_object_version_number)
    WHERE relationship_id = p_relationship_id;

Line: 198


END update_row;

Line: 200


PROCEDURE delete_row(
    p_relationship_id  NUMBER)
 IS
 BEGIN
   DELETE FROM csi_ii_relationships
    WHERE relationship_id = p_relationship_id;

Line: 209


 END delete_row;

Line: 239


          p_last_updated_by             NUMBER,
          p_last_update_date            DATE,
          p_last_update_login           NUMBER,
          p_object_version_number       NUMBER)

 IS
   CURSOR c IS
        SELECT *
         FROM csi_ii_relationships
        WHERE relationship_id =  p_relationship_id
        FOR UPDATE OF relationship_id NOWAIT;

Line: 256


        fnd_message.set_name('fnd', 'form_record_deleted');

Line: 340


       AND (    ( recinfo.last_updated_by = p_last_updated_by)
            OR (    ( recinfo.last_updated_by IS NULL )
                AND (  p_last_updated_by IS NULL )))
       AND (    ( recinfo.last_update_date = p_last_update_date)
            OR (    ( recinfo.last_update_date IS NULL )
                AND (  p_last_update_date IS NULL )))
       AND (    ( recinfo.last_update_login = p_last_update_login)
            OR (    ( recinfo.last_update_login IS NULL )
                AND (  p_last_update_login IS NULL )))
       AND (    ( recinfo.object_version_number = p_object_version_number)
            OR (    ( recinfo.object_version_number IS NULL )
                AND (  p_object_version_number IS NULL )))
       ) THEN
       return;