APPS.XLA_MPA_JLT_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_mpa_accounting_line_type_co	IN VARCHAR2,
    x_mpa_accounting_line_code		IN VARCHAR2,
    x_analytical_criterion_type_co	IN VARCHAR2,
    x_analytical_criterion_code		IN VARCHAR2,
    x_mpa_inherit_ac_flag		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_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 mpa_accounting_line_type_code		= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code		= x_mpa_accounting_line_code
      and analytical_criterion_type_code	= x_analytical_criterion_type_co
      and analytical_criterion_code		= x_analytical_criterion_code;

Line: 86

      l_log_module := C_DEFAULT_MODULE||'.insert_row';

Line: 90

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

Line: 95

   INSERT INTO XLA_MPA_JLT_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,
        MPA_ACCOUNTING_LINE_TYPE_CODE,
        MPA_ACCOUNTING_LINE_CODE,
        ANALYTICAL_CRITERION_TYPE_CODE,
        ANALYTICAL_CRITERION_CODE,
	MPA_INHERIT_AC_FLAG,
        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_ANALYTICAL_CRITERION_TYPE_CO,
        X_ANALYTICAL_CRITERION_CODE,
	X_MPA_INHERIT_AC_FLAG,
        1,
        X_CREATION_DATE,
	X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN);

Line: 147

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

Line: 152

END Insert_Row;

Line: 171

   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: 203

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

Line: 217

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_analytical_criterion_type_co	IN VARCHAR2,
    x_analytical_criterion_code		IN VARCHAR2,
    x_mpa_inherit_ac_flag		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: 241

     l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 245

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

Line: 250

   UPDATE XLA_MPA_JLT_AC_ASSGNS
      SET mpa_inherit_ac_flag		= x_mpa_inherit_ac_flag,
	  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
      and analytical_criterion_type_code = x_analytical_criterion_type_co
      and analytical_criterion_code	= x_analytical_criterion_code;

Line: 273

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

Line: 278

END Update_Row;

Line: 282

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,
    x_analytical_criterion_type_co	IN VARCHAR2,
    x_analytical_criterion_code		IN VARCHAR2
) IS

   l_log_module       VARCHAR2(240);

Line: 301

      l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 305

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

Line: 310

    DELETE XLA_MPA_JLT_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 mpa_accounting_line_type_code		= x_mpa_accounting_line_type_co
      and mpa_accounting_line_code		= x_mpa_accounting_line_code
      and analytical_criterion_type_code	= x_analytical_criterion_type_co
      and analytical_criterion_code		= x_analytical_criterion_code;

Line: 328

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

Line: 333

END Delete_Row;