APPS.XLA_MPA_HEADER_AC_ASSGNS_F_PVT SQL Statements

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

Line: 44

PROCEDURE Insert_Row (
    x_rowid				 IN OUT NOCOPY VARCHAR2,
    x_amb_context_code			 IN VARCHAR2,
    x_application_id			 IN NUMBER,
    x_event_class_code			 IN VARCHAR2,
    x_event_type_code			 IN VARCHAR2,
    x_line_definition_owner_code	 IN VARCHAR2,
    x_line_definition_code		 IN VARCHAR2,
    x_accounting_line_type_code		 IN VARCHAR2,
    x_accounting_line_code		 IN VARCHAR2,
    x_analytical_criterion_type_co	 IN VARCHAR2,
    x_analytical_criterion_code		 IN VARCHAR2,
    x_creation_date			 IN DATE,
    x_created_by			 IN NUMBER,
    x_last_update_date			 IN DATE,
    x_last_updated_by			 IN NUMBER,
    x_last_update_login			 IN NUMBER
) IS

   Cursor C is
   Select rowid
     from xla_mpa_header_ac_assgns
    where amb_context_code			= x_amb_context_code
      and application_id			= x_application_id
      and event_type_code			= x_event_type_code
      and line_definition_owner_code		= x_line_definition_owner_code
      and line_definition_code			= x_line_definition_code
      and accounting_line_type_code		= x_accounting_line_type_code
      and accounting_line_code			= x_accounting_line_code
      and analytical_criterion_type_code	= x_analytical_criterion_type_co
      and analytical_criterion_code		= x_analytical_criterion_code;

Line: 81

      l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 85

      trace(p_msg    => 'BEGIN of procedure insert_row',
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 90

   INSERT INTO XLA_MPA_HEADER_AC_ASSGNS (
       AMB_CONTEXT_CODE,
       APPLICATION_ID,
       EVENT_CLASS_CODE,
       EVENT_TYPE_CODE,
       LINE_DEFINITION_OWNER_CODE,
       LINE_DEFINITION_CODE,
       ACCOUNTING_LINE_TYPE_CODE,
       ACCOUNTING_LINE_CODE,
       ANALYTICAL_CRITERION_TYPE_CODE,
       ANALYTICAL_CRITERION_CODE,
       OBJECT_VERSION_NUMBER,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       LAST_UPDATE_LOGIN
    )
    VALUES (
       X_AMB_CONTEXT_CODE,
       X_APPLICATION_ID,
       X_EVENT_CLASS_CODE,
       X_EVENT_TYPE_CODE,
       X_LINE_DEFINITION_OWNER_CODE,
       X_LINE_DEFINITION_CODE,
       X_ACCOUNTING_LINE_TYPE_CODE,
       X_ACCOUNTING_LINE_CODE,
       X_ANALYTICAL_CRITERION_TYPE_CO,
       X_ANALYTICAL_CRITERION_CODE,
       1,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);

Line: 136

      trace(p_msg    => 'END of procedure insert_row',
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 140

END Insert_Row;

Line: 158

   Select *
     from xla_mpa_header_ac_assgns
    where amb_context_code			= x_amb_context_code
      and application_id			= x_application_id
      and event_type_code			= x_event_type_code
      and line_definition_owner_code		= x_line_definition_owner_code
      and line_definition_code			= x_line_definition_code
      and accounting_line_type_code		= x_accounting_line_type_code
      and accounting_line_code			= x_accounting_line_code
      and analytical_criterion_type_code	= x_analytical_criterion_type_co
      and analytical_criterion_code		= x_analytical_criterion_code
      for update of event_class_code nowait;

Line: 189

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

Line: 203

PROCEDURE Delete_Row (
    x_amb_context_code			 IN VARCHAR2,
    x_application_id			 IN NUMBER,
    x_event_type_code			 IN VARCHAR2,
    x_line_definition_owner_code	 IN VARCHAR2,
    x_line_definition_code		 IN VARCHAR2,
    x_accounting_line_type_code		 IN VARCHAR2,
    x_accounting_line_code		 IN VARCHAR2,
    x_analytical_criterion_type_co	 IN VARCHAR2,
    x_analytical_criterion_code		 IN VARCHAR2
) IS

   l_log_module       VARCHAR2(240);

Line: 219

      l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 223

      trace(p_msg    => 'BEGIN of procedure delete_row',
            p_module => l_log_module,
            p_level  => C_LEVEL_PROCEDURE);

Line: 228

   DELETE from XLA_MPA_HEADER_AC_ASSGNS
    where amb_context_code		 = x_amb_context_code
      and application_id		 = x_application_id
      and event_type_code                = x_event_type_code
      and line_definition_owner_code     = x_line_definition_owner_code
      and line_definition_code           = x_line_definition_code
      and accounting_line_type_code      = x_accounting_line_type_code
      and accounting_line_code           = x_accounting_line_code
      and analytical_criterion_type_code = x_analytical_criterion_type_co
      and analytical_criterion_code      = x_analytical_criterion_code;

Line: 244

       trace(p_msg    => 'END of procedure delete_row',
             p_module => l_log_module,
             p_level  => C_LEVEL_PROCEDURE);

Line: 249

END Delete_Row;