DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS SQL Statements

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

Line: 103

    l_delete_event           NUMBER;
Line: 109

    SELECT LEGAL_ENTITY_ID
            ,LOAN_NUMBER
        FROM LNS_LOAN_HEADERS_ALL
    WHERE LOAN_ID = X_Loan_Id;
Line: 115

     SELECT count(event_id)
     FROM   xla_events
     WHERE	entity_id = (select entity_id from xla_events where event_id = c_old_event_id);
Line: 120

    select so.ledger_id
        from lns_system_options sb,
            gl_ledgers so,
	    lns_loan_headers lhdr
    where sb.set_of_books_id = so.ledger_id
       and lhdr.loan_id = c_loan_id
       and lhdr.org_id = sb.org_id;
Line: 136

    SELECT xe.event_id
    FROM  xla_transaction_entities   xte
          ,xla_events     xe
          ,xla_entity_types_b xet
    WHERE xte.application_id                    = p_application_id
        AND xte.ledger_id                       = p_ledger_id
        AND xte.entity_code                     = p_entity_type_code
        AND NVL(xte.source_id_int_1,-99)        = NVL(p_source_id_int_1,-99)
        AND NVL(xte.source_id_int_2,-99)        = NVL(p_source_id_int_2,-99)
        AND NVL(xte.source_id_int_3,-99)        = NVL(p_source_id_int_3,-99)
	AND NVL(xte.source_id_int_4,-99)        = NVL(p_source_id_int_4,-99)
        AND NVL(xte.valuation_method,' ')        = NVL(p_valuation_method,' ')
        AND xe.entity_id                        = xte.entity_id
        AND xet.application_id                  = xte.application_id
        AND xte.entity_code                     = xet.entity_code;
Line: 278

		xla_events_pub_pkg.DELETE_EVENT
				(
				p_event_source_info    => l_loan_details,
				p_event_id             => l_old_event_id,
				p_valuation_method     => null,
				p_security_context     => l_security_context
				);
Line: 285

		logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted l_old_event_id  '||l_old_event_id);
Line: 287

		-- Need to delete the entities from the XLA tables if the entity_id is matched to only one event

		IF (l_entity_count <= 1) THEN

			l_delete_event := xla_events_pub_pkg.DELETE_ENTITY( p_source_info    => l_loan_details,
							p_valuation_method     => null,
							p_security_context     => l_security_context);
Line: 294

			logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Id of the event is deleted '||l_delete_event);
Line: 362

|| PUBLIC PROCEDURE update_event
||
|| DESCRIPTION
|| Overview: will write to xla_events table
||
|| PSEUDO CODE/LOGIC
||
|| PARAMETERS
|| Parameter: p_loan_id => loan_id
||           ,p_event_type_code    => seeded code for loans "APPROVED" "IN_FUNDING"
||           ,p_event_date         => most likely GL_DATE
||           ,p_event_status       => event Status
||             CONSTANT  = 'U';   -- event status:unprocessed
Line: 389

procedure update_event(p_loan_id            in  number
                      ,p_disb_header_id     in  number
                      ,p_loan_amount_adj_id in  number default NULL
		      ,p_loan_line_id		  in  number default NULL
                      ,p_event_id           in  number
                      ,p_event_type_code    in  varchar
                      ,p_event_date         in  date
                      ,p_event_status       in  varchar2
                      ,p_init_msg_list      in  varchar2
                      ,p_commit             in  varchar2
                      ,x_return_status      out nocopy varchar2
                      ,x_msg_count          out nocopy number
                      ,x_msg_data           out nocopy varchar2)
is
  l_api_name         varchar2(15);
Line: 415

  SELECT LEGAL_ENTITY_ID
    FROM LNS_LOAN_HEADERS
   WHERE LOAN_ID = X_Loan_Id;
Line: 420

    select so.ledger_id
        from lns_system_options sb,
            gl_ledgers so,
	    lns_loan_headers lhdr
    where sb.set_of_books_id = so.ledger_id
       and lhdr.loan_id = c_loan_id
       and lhdr.org_id = sb.org_id;
Line: 429

   l_api_name           := 'update_event';
Line: 442

   SAVEPOINT update_event;
Line: 482

   logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
Line: 483

   XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info   => l_loan_details
                                  ,p_event_id            => p_event_id
                                  ,p_event_type_code     => p_event_type_code
                                  ,p_event_date          => p_event_date
                                  ,p_event_status_code   => p_event_status
                                  ,p_valuation_method    => null
                                  ,p_security_context    => l_security_context);
Line: 505

             ROLLBACK TO update_event;
Line: 513

             ROLLBACK TO update_event;
Line: 521

             ROLLBACK TO update_event;
Line: 523

end update_event;
Line: 526

|| PUBLIC PROCEDURE delete_event
||
|| DESCRIPTION
|| Overview: will delete events from xla_events table
||
|| PSEUDO CODE/LOGIC
||
|| PARAMETERS
|| Parameter: p_event_id => event_id
||
|| Return value:
||               standard
|| KNOWN ISSUES
||
|| NOTES
||
|| MODIFICATION HISTORY
|| Date                  Author            Description of Changes
|| 4/11/2005             raverma           Created
||
 *=======================================================================*/
procedure delete_event(p_loan_id            in  number
		      ,p_disb_header_id     in  number
                      ,p_loan_amount_adj_id in  number default NULL
		      ,p_loan_line_id		  in  number default NULL
                      ,p_event_id           in  number
                      ,p_init_msg_list      in  varchar2
                      ,p_commit             in  varchar2
                      ,x_return_status      out nocopy varchar2
                      ,x_msg_count          out nocopy number
                      ,x_msg_data           out nocopy varchar2)
is
  l_api_name         varchar2(15);
Line: 564

  SELECT LEGAL_ENTITY_ID
    FROM LNS_LOAN_HEADERS
   WHERE LOAN_ID = X_Loan_Id;
Line: 569

    select so.ledger_id
        from lns_system_options sb,
            gl_ledgers so,
	    lns_loan_headers lhdr
    where sb.set_of_books_id = so.ledger_id
       and lhdr.loan_id = c_loan_id
       and lhdr.org_id = sb.org_id;
Line: 583

   l_api_name           := 'delete_event';
Line: 593

   SAVEPOINT delete_event;
Line: 635

   logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
Line: 636

   XLA_EVENTS_PUB_PKG.delete_event
   (p_event_source_info            => l_loan_details
   ,p_event_id                     => p_event_id
   ,p_valuation_method             => null
   ,p_security_context             => l_security_context);
Line: 642

    logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleted event_id '||p_event_id||' successfully');
Line: 658

             ROLLBACK TO delete_event;
Line: 666

             ROLLBACK TO delete_event;
Line: 674

             ROLLBACK TO delete_event;
Line: 676

end delete_event;