The following lines contain the word 'select', 'insert', 'update' or 'delete':
| to update transaction number, Event Number |
| and Reference Information |
| 06-May-02 S. Singhania Added "valuation_method" and "ledger_id". |
| Bug # 2351677. |
| 31-May-02 S. Singhania Removed one of the 'create_entity_event' API |
| Renamed 'create_entity_event' API to |
| 'create_bulk_events' |
| 23-Jul-02 S. Singhania commented 'get_document_status' API. |
| Bug # 2464825 |
| 09-Sep-02 S. Singhania modified 'create_bulk_events' API. Bug 2530796|
| 21-Feb-03 S. Singhania Added 'Trace' procedure. |
| 04-Sep-03 S. Singhania Made changes to satisfy enhanced requirement |
| for 'Source Application'. |
| - Added parameter to CREATE_BULK_EVENTS |
| 12-Dec-03 S. Singhania Removed the API UPDATE_TRANSACTION_NUMBER. |
| Bug # 3268790 |
| 25-Jun-04 W. Shen add a new function delete_entity(bug 3316535) |
| 23-OCT-04 W. Shen New API to delete/update/create event in bulk |
| 1- APR-05 W. Shen Add transaction_date to create_event api |
| add transaction_date to update_event API |
| 20-Apr-05 S. Singhania Bug 4312353. Modified the calls to routines in|
| xla_events_pkg to reflect the change in the |
| way we handle valuation method different |
| from other security columns |
| 02-May-05 V. Kumar Removed function create_bulk_events, |
| Bug # 4323140 |
| 30-SEP-10 VDAMERLA Bug:9077926 Created overloaded procedures |
| for create_bulk_events and |
| update_bulk_event_statuses to pass |
| bulk limit value |
| 13-Oct-10 nksurana Bug 10152910 Created new function/API |
| allow_third_party_update to check if the party|
| site can be updated, based on Control Account.|
+===========================================================================*/
--=============================================================================
-- *********** Local Trace Routine **********
--=============================================================================
C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
PROCEDURE update_event_status
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_class_code IN VARCHAR2 DEFAULT NULL
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_event_status_code IN VARCHAR2
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security) IS
BEGIN
trace('> xla_events_pub_pkg.update_event_status' , 20);
xla_events_pkg.update_event_status
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,p_event_class_code => p_event_class_code
,p_event_type_code => p_event_type_code
,p_event_date => p_event_date
,p_event_status_code => p_event_status_code);
trace('< xla_events_pub_pkg.update_event_status' , 20);
(p_location => 'xla_events_pub_pkg.update_event_status');
END update_event_status;
PROCEDURE update_event
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_id IN INTEGER
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_event_status_code IN VARCHAR2 DEFAULT NULL
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security
,p_transaction_date IN DATE DEFAULT NULL) IS
BEGIN
trace('> xla_events_pub_pkg.update_event' , 20);
xla_events_pkg.update_event
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,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_code
,p_transaction_date => p_transaction_date);
trace('< xla_events_pub_pkg.update_event' , 20);
(p_location => 'xla_events_pub_pkg.update_event');
END update_event;
PROCEDURE update_event
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_id IN INTEGER
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_event_status_code IN VARCHAR2 DEFAULT NULL
,p_event_number IN INTEGER
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security
,p_transaction_date IN DATE DEFAULT NULL) IS
BEGIN
trace('> xla_events_pub_pkg.update_event' , 20);
xla_events_pkg.update_event
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,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_code
,p_transaction_date => p_transaction_date
,p_event_number => p_event_number
,p_overwrite_event_num => 'Y');
trace('< xla_events_pub_pkg.update_event' , 20);
(p_location => 'xla_events_pub_pkg.update_event');
END update_event;
PROCEDURE update_event
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_id IN INTEGER
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_event_status_code IN VARCHAR2 DEFAULT NULL
,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security
,p_transaction_date IN DATE DEFAULT NULL) IS
BEGIN
trace('> xla_events_pub_pkg.update_event' , 20);
xla_events_pkg.update_event
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,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_code
,p_transaction_date => p_transaction_date
,p_reference_info => p_reference_info
,p_overwrite_ref_info => 'Y' );
trace('< xla_events_pub_pkg.update_event' , 20);
(p_location => 'xla_events_pub_pkg.update_event');
END update_event;
PROCEDURE update_event
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_id IN INTEGER
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_event_status_code IN VARCHAR2 DEFAULT NULL
,p_event_number IN INTEGER
,p_reference_info IN xla_events_pub_pkg.t_event_reference_info
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security
,p_transaction_date IN DATE DEFAULT NULL) IS
BEGIN
trace('> xla_events_pub_pkg.update_event' , 20);
xla_events_pkg.update_event
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,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_code
,p_transaction_date => p_transaction_date
,p_event_number => p_event_number
,p_reference_info => p_reference_info
,p_overwrite_event_num => 'Y'
,p_overwrite_ref_info => 'Y');
trace('< xla_events_pub_pkg.update_event' , 20);
(p_location => 'xla_events_pub_pkg.update_event');
END update_event;
PROCEDURE delete_event
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_id IN INTEGER
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security) IS
BEGIN
trace('> xla_events_pub_pkg.delete_event' , 20);
xla_events_pkg.delete_event
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method
,p_event_id => p_event_id );
trace('< xla_events_pub_pkg.delete_event' , 20);
(p_location => 'xla_events_pub_pkg.delete_event');
END delete_event;
FUNCTION delete_events
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_event_class_code IN VARCHAR2 DEFAULT NULL
,p_event_type_code IN VARCHAR2 DEFAULT NULL
,p_event_date IN DATE DEFAULT NULL
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security)
RETURN INTEGER IS
BEGIN
trace('@ xla_events_pub_pkg.delete_events (fn)' , 20);
RETURN xla_events_pkg.delete_events
(p_event_source_info => p_event_source_info
,p_event_class_code => p_event_class_code
,p_valuation_method => p_valuation_method
,p_event_type_code => p_event_type_code
,p_event_date => p_event_date);
(p_location => 'xla_events_pub_pkg.delete_events(fn)');
END delete_events;
FUNCTION delete_entity
(p_source_info IN xla_events_pub_pkg.t_event_source_info
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security)
RETURN INTEGER IS
l_result INTEGER;
trace('> xla_events_pub_pkg.delete_entty' , 20);
l_result := xla_events_pkg.delete_entity
(p_source_info => p_source_info
,p_valuation_method => p_valuation_method);
trace('< xla_events_pub_pkg.delete_entity' , 20);
(p_location => 'xla_events_pub_pkg.delete_entity');
END delete_entity;
PROCEDURE update_bulk_event_statuses(p_application_id INTEGER) IS
BEGIN
trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
xla_events_pkg.update_bulk_event_statuses(
p_application_id => p_application_id);
trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
(p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');
END update_bulk_event_statuses;
PROCEDURE update_bulk_event_statuses(p_application_id IN INTEGER
,p_limit_size IN INTEGER) IS
BEGIN
trace('>BEGIN of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
xla_events_pkg.update_bulk_event_statuses(
p_application_id => p_application_id
,p_limit_size => p_limit_size);
trace('>END of procedure xla_events_pub_pkg.update_bulk_event_statuses' , 20);
(p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');
END update_bulk_event_statuses;
PROCEDURE delete_bulk_events(p_application_id INTEGER) IS
BEGIN
xla_events_pkg.delete_bulk_events(
p_application_id => p_application_id);
(p_location => 'xla_events_pub_pkg.delete_bulk_events');
END delete_bulk_events;
SELECT adjustment_period_flag
INTO l_adjustment_flag
FROM gl_period_statuses
WHERE application_id = p_application_id
AND ledger_id = p_ledger_id
AND period_name = p_period_name;
SELECT adjustment_period_flag
INTO l_adjustment_flag
FROM gl_period_statuses
WHERE application_id = 101
AND ledger_id = l_ledger_id
AND period_name = l_period_name;
PROCEDURE update_transaction_number
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_transaction_number IN VARCHAR2
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security
,p_event_id IN NUMBER DEFAULT NULL) IS -- 8761772
BEGIN
trace('> xla_events_pub_pkg.update_transaction_number' , 20);
xla_events_pkg.update_transaction_number
(p_event_source_info => p_event_source_info
,p_transaction_number => p_transaction_number
,p_valuation_method => p_valuation_method
,p_event_id => p_event_id
);
trace('< xla_events_pub_pkg.update_transaction_number' , 20);
(p_location => 'xla_events_pub_pkg.update_transaction_number');
END update_transaction_number;
FUNCTION allow_third_party_update
(p_event_source_info IN xla_events_pub_pkg.t_event_source_info
,p_valuation_method IN VARCHAR2
,p_security_context IN xla_events_pub_pkg.t_security)
RETURN BOOLEAN IS
BEGIN
trace('> xla_events_pub_pkg.allow_third_party_update' , 20);
RETURN xla_events_pkg.allow_third_party_update
(p_event_source_info => p_event_source_info
,p_valuation_method => p_valuation_method);
trace('< xla_events_pub_pkg.allow_third_party_update' , 20);
(p_location => 'xla_events_pub_pkg.allow_third_party_update');
END allow_third_party_update;