APPS.XLA_MPA_JLT_ADR_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_flexfield_segment_code		IN VARCHAR2,
    x_segment_rule_appl_id		IN NUMBER,
    x_segment_rule_type_code		IN VARCHAR2,
    x_segment_rule_code			IN VARCHAR2,
    x_inherit_adr_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_adr_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 flexfield_segment_code	= x_flexfield_segment_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_ADR_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,
       FLEXFIELD_SEGMENT_CODE,
       SEGMENT_RULE_APPL_ID,
       SEGMENT_RULE_TYPE_CODE,
       SEGMENT_RULE_CODE,
       INHERIT_ADR_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_FLEXFIELD_SEGMENT_CODE,
       X_SEGMENT_RULE_APPL_ID,
       X_SEGMENT_RULE_TYPE_CODE,
       X_SEGMENT_RULE_CODE,
       X_INHERIT_ADR_FLAG,
       1,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);

Line: 151

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

Line: 156

END Insert_Row;

Line: 159

PROCEDURE Update_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_flexfield_segment_code		IN VARCHAR2,
    x_segment_rule_appl_id		IN NUMBER,
    x_segment_rule_type_code		IN VARCHAR2,
    x_segment_rule_code			IN VARCHAR2,
    x_inherit_adr_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: 184

     l_log_module := C_DEFAULT_MODULE||'.update_row';

Line: 188

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

Line: 193

   UPDATE XLA_MPA_JLT_ADR_ASSGNS
      SET segment_rule_appl_id		= x_segment_rule_appl_id,
          segment_rule_type_code	= x_segment_rule_type_code,
          segment_rule_code		= x_segment_rule_code,
	  inherit_adr_flag		= x_inherit_adr_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 flexfield_segment_code	= x_flexfield_segment_code;

Line: 218

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

Line: 223

END Update_Row;

Line: 244

   Select *
     from xla_mpa_jlt_adr_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 flexfield_segment_code		= x_flexfield_segment_code
      for update of event_class_code nowait;

Line: 276

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

Line: 300

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_flexfield_segment_code		IN VARCHAR2
) IS

   l_log_module       VARCHAR2(240);

Line: 317

      l_log_module := C_DEFAULT_MODULE||'.delete_row';

Line: 321

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

Line: 327

   DELETE XLA_MPA_JLT_ADR_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 flexfield_segment_code	= x_flexfield_segment_code;

Line: 345

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

Line: 350

END Delete_Row;