APPS.XLA_MPA_JLT_ASSGNS_F_PVT SQL Statements

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

Line: 45

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_mpa_accounting_line_type_co	IN VARCHAR2,
    x_mpa_accounting_line_code		IN VARCHAR2,
    x_inherit_desc_flag			IN VARCHAR2,
    x_description_type_code		IN VARCHAR2,
    x_description_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_jlt_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 mpa_accounting_line_type_code	= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code	= x_mpa_accounting_line_code;

Line: 85

      l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 89

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

Line: 94

   INSERT INTO XLA_MPA_JLT_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,
       MPA_ACCOUNTING_LINE_TYPE_CODE,
       MPA_ACCOUNTING_LINE_CODE,
       INHERIT_DESC_FLAG,
       DESCRIPTION_TYPE_CODE,
       DESCRIPTION_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_MPA_ACCOUNTING_LINE_TYPE_CO,
       X_MPA_ACCOUNTING_LINE_CODE,
       X_INHERIT_DESC_FLAG,
       X_DESCRIPTION_TYPE_CODE,
       X_DESCRIPTION_CODE,
       1,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);

Line: 146

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

Line: 150

END Insert_Row;

Line: 153

PROCEDURE Update_Row (
    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_mpa_accounting_line_type_co	IN VARCHAR2,
    x_mpa_accounting_line_code		IN VARCHAR2,
    x_inherit_desc_flag			IN VARCHAR2,
    x_description_type_code		IN VARCHAR2,
    x_description_code			IN VARCHAR2,
    x_last_update_date			IN DATE,
    x_last_updated_by			IN NUMBER,
    x_last_update_login			IN NUMBER
) IS

   l_log_module		varchar2(240);

Line: 177

     l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 181

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

Line: 186

   UPDATE XLA_MPA_JLT_ASSGNS
      SET inherit_desc_flag	= x_inherit_desc_flag,
          description_type_code	= x_description_type_code,
          description_code	= x_description_code,
	  last_update_date	= x_last_update_date,
	  object_version_number	= object_version_number + 1,
	  last_updated_by	= x_last_updated_by,
	  last_update_login	= x_last_update_login
    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 mpa_accounting_line_type_code	= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code	= x_mpa_accounting_line_code;

Line: 210

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

Line: 215

END Update_Row;

Line: 233

   Select *
     from xla_mpa_jlt_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 mpa_accounting_line_type_code		= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code		= x_mpa_accounting_line_code
      for update of event_class_code nowait;

Line: 264

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

Line: 286

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_mpa_accounting_line_type_co	IN VARCHAR2,
    x_mpa_accounting_line_code		IN VARCHAR2
) IS

   l_log_module       VARCHAR2(240);

Line: 302

      l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 306

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

Line: 311

   DELETE from XLA_MPA_JLT_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 mpa_accounting_line_type_code	= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code	= x_mpa_accounting_line_code;

Line: 327

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

Line: 332

END Delete_Row;