APPS.XLA_JE_FUNDS_CHECKER_PKG SQL Statements

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

Line: 13

FUNCTION bc_packet_insert
   (p_ae_header_id              IN INTEGER
   ,p_application_id		IN INTEGER
   ,p_funds_action              IN VARCHAR2)
RETURN INTEGER;

Line: 120

  p_packet_id := bc_packet_insert(p_ae_header_id, p_application_id, G_FUNDS_ACTION_RESERVE);

Line: 264

PROCEDURE insert_check_funds_row
   (p_packet_id			IN INTEGER
   ,p_ledger_id			IN INTEGER
   ,p_application_id		IN INTEGER
   ,p_ae_header_id              IN INTEGER
   ,p_ae_line_num		IN INTEGER
   ,p_gl_date			IN DATE
   ,p_balance_type_code		IN VARCHAR2
   ,p_je_category_name		IN VARCHAR2
   ,p_budget_version_id		IN INTEGER
   ,p_encumbrance_type_id	IN INTEGER
   ,p_code_combination_id	IN INTEGER
   ,p_currency_code		IN VARCHAR2
   ,p_entered_dr		IN NUMBER
   ,p_entered_cr		IN NUMBER
   ,p_accounted_dr		IN NUMBER
   ,p_accounted_cr		IN NUMBER
   ,p_ussgl_transaction_code	IN VARCHAR2
   ,p_event_id                  IN NUMBER)
IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 288

    l_log_module := C_DEFAULT_MODULE||'.insert_check_funds_row';

Line: 292

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

Line: 315

	insert into gl_bc_packets
(PACKET_ID
,APPLICATION_ID
,LEDGER_ID
,JE_SOURCE_NAME
,JE_CATEGORY_NAME
,CODE_COMBINATION_ID
,ACTUAL_FLAG
,PERIOD_NAME
,PERIOD_YEAR
,PERIOD_NUM
,QUARTER_NUM
,CURRENCY_CODE
,STATUS_CODE
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,ENCUMBRANCE_TYPE_ID
,BUDGET_VERSION_ID
,ENTERED_DR
,ENTERED_CR
,ACCOUNTED_DR
,ACCOUNTED_CR
,EVENT_ID
,AE_HEADER_ID
,AE_LINE_NUM
,SESSION_ID
,SERIAL_ID
,BC_DATE
)
SELECT
  p_packet_id
, p_application_id
, p_ledger_id
, xs.je_source_name
, p_je_category_name
, p_code_combination_id
, p_balance_type_code
, gps.period_name
, gps.period_year
, gps.period_num
, gps.quarter_num
, p_currency_code
, G_FUNDS_ACTION_CHECK
, sysdate
, xla_environment_pkg.g_usr_id
, p_encumbrance_type_id
, p_budget_version_id
, p_entered_dr
, p_entered_cr
, p_accounted_dr
, p_accounted_cr
, p_event_id
, p_ae_header_id
, p_ae_line_num
, ses.sid
, ses.serial#
, p_gl_date
 FROM xla_subledgers     xs
    , gl_period_statuses gps
    , v$session          ses
WHERE xs.application_id  = p_application_id
  AND gps.application_id = 101
  AND gps.ledger_id      = p_ledger_id
  AND p_gl_date  between gps.start_date and gps.end_date
  AND ses.audsid         = userenv('SESSIONID');

Line: 384

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

Line: 394

      (p_location => 'xla_je_funds_checker_pkg.insert_check_funds_row');

Line: 396

END insert_check_funds_row;

Line: 407

FUNCTION bc_packet_insert
   (p_ae_header_id              IN INTEGER
   ,p_application_id		IN INTEGER
   ,p_funds_action              IN VARCHAR2)
RETURN INTEGER
IS
  PRAGMA AUTONOMOUS_TRANSACTION;

Line: 415

    SELECT gl_bc_packets_s.NEXTVAL
    FROM dual;

Line: 422

    l_log_module := C_DEFAULT_MODULE||'.bc_packet_insert';

Line: 426

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

Line: 464

	insert into gl_bc_packets
(PACKET_ID
,APPLICATION_ID
,LEDGER_ID
,JE_SOURCE_NAME
,JE_CATEGORY_NAME
,CODE_COMBINATION_ID
,ACTUAL_FLAG
,PERIOD_NAME
,PERIOD_YEAR
,PERIOD_NUM
,QUARTER_NUM
,CURRENCY_CODE
,STATUS_CODE -- Should be C if checking, P if reservation
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,ENCUMBRANCE_TYPE_ID
,BUDGET_VERSION_ID
,ENTERED_DR
,ENTERED_CR
,ACCOUNTED_DR
,ACCOUNTED_CR
,EVENT_ID
,AE_HEADER_ID
,AE_LINE_NUM
,SESSION_ID
,SERIAL_ID
,BC_DATE
)
SELECT
  l_packet_id
, p_application_id
, xah.ledger_id
, xs.je_source_name
, xah.je_category_name
, xal.code_combination_id
, xah.balance_type_code
, xah.period_name
, gps.period_year
, gps.period_num
, gps.quarter_num
, xal.currency_code
, p_funds_action
, sysdate
, xla_environment_pkg.g_usr_id
, xal.encumbrance_type_id
, xah.budget_version_id
, xal.entered_dr
, xal.entered_cr
, xal.accounted_dr
, xal.accounted_cr
, xah.event_id
, xal.ae_header_id
, xal.ae_line_num
, ses.sid
, ses.serial#
, xah.accounting_date
 FROM xla_ae_headers      xah
    , xla_ae_lines       xal
    , xla_subledgers     xs
    , gl_period_statuses gps
    , v$session          ses
WHERE xal.application_id = xah.application_id
  AND xal.ae_header_id   = xah.ae_header_id
  AND xs.application_id  = xah.application_id
  AND gps.application_id = 101
  AND gps.ledger_id      = xah.ledger_id
  AND gps.period_name    = xah.period_name
  AND xah.application_id = p_application_id
  AND xah.ae_header_id   = p_ae_header_id
  AND ses.audsid         = userenv('SESSIONID');

Line: 537

    trace(p_msg    => 'Num of rows inserted: '||SQL%ROWCOUNT,
          p_module => l_log_module,
          p_level  => C_LEVEL_EVENT);

Line: 545

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

Line: 567

      (p_location => 'xla_je_funds_checker_pkg.bc_packet_insert');

Line: 569

END bc_packet_insert;