APPS.JA_CN_DFF_ASSIGNMENTS_PKG SQL Statements

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

Line: 62

  PROCEDURE Insert_Row(p_row_id            IN OUT NOCOPY VARCHAR2
                      ,P_application_id    IN NUMBER
                      ,p_dff_name          IN VARCHAR2
                      ,p_dff_title_code    IN VARCHAR2
                      ,p_context_code      IN VARCHAR2
                      ,p_attribute_column  IN VARCHAR2
                      ,p_creation_date     IN DATE
                      ,p_created_by        IN NUMBER
                      ,p_last_update_date  IN DATE
                      ,p_last_updated_by   IN NUMBER
                      ,p_last_update_login IN NUMBER
                      ,p_chart_of_accounts_id In NUMBER
                      ) IS

    l_procedure_name VARCHAR2(100) := 'Insert_Row';

Line: 81

      SELECT ROWID
        FROM JA_CN_DFF_ASSIGNMENTS
       WHERE DFF_TITLE_CODE = p_dff_title_code;

Line: 95

    INSERT INTO JA_CN_DFF_ASSIGNMENTS
      (application_id
      ,descriptive_flexfield_name
      ,dff_title_code
      ,context_code
      ,attribute_column
      ,creation_date
      ,created_by
      ,last_update_date
      ,last_updated_by
      ,last_update_login
      ,chart_of_accounts_id
      )
    VALUES
      (
      p_application_id
      ,p_dff_name
      ,p_dff_title_code
      ,p_context_code
      ,p_attribute_column
      ,p_creation_date
      ,p_created_by
      ,p_last_update_date
      ,p_last_updated_by
      ,p_last_update_login
      ,p_chart_of_accounts_id
     );

Line: 144

  END Insert_Row;

Line: 181

  PROCEDURE Update_Row(p_row_id            IN OUT NOCOPY VARCHAR2
                      ,p_application_id    IN NUMBER
                      ,p_dff_name          IN VARCHAR2
                      ,p_dff_title_code    IN VARCHAR2
                      ,p_context_code      IN VARCHAR2
                      ,p_attribute_column  IN VARCHAR2
                      ,p_creation_date     IN DATE
                      ,p_created_by        IN NUMBER
                      ,p_last_update_date  IN DATE
                      ,p_last_updated_by   IN NUMBER
                      ,p_last_update_login IN NUMBER
                      ,p_chart_of_accounts_id In NUMBER) IS

    l_procedure_name VARCHAR2(100) := 'Update_Row';

Line: 208

    UPDATE JA_CN_DFF_ASSIGNMENTS
       SET application_id             = p_application_id,
           descriptive_flexfield_name = p_dff_name,
           dff_title_code             = p_dff_title_code,
           context_code               = p_context_code,
           attribute_column           = p_attribute_column,
           creation_date              = p_creation_date,
           created_by                 = p_created_by,
           last_update_date           = p_last_update_date,
           last_updated_by            = p_last_updated_by,
           last_update_login          = p_last_update_login,
           chart_of_accounts_id       = p_chart_of_accounts_id
     WHERE ROWID = p_row_id;

Line: 234

  END Update_Row;

Line: 279

                    ,p_last_update_date  IN DATE
                    ,p_last_updated_by   IN NUMBER
                    ,p_last_update_login IN NUMBER
                    ,p_chart_of_accounts_id In NUMBER) IS

    l_procedure_name VARCHAR2(100) := 'Lock_Row';

Line: 289

      SELECT *
        FROM JA_CN_DFF_ASSIGNMENTS
       WHERE ROWID = p_row_id
         FOR UPDATE OF dff_title_code NOWAIT;

Line: 314

                             'FORM_RECORD_DELETED');