Database Reference
In-Depth Information
basic Events Registration and further outbound processing. For demo purposes,
we show the Address object events registration, although it's not entirely "busi-
ness", it's more like the QDO (see Chapter 5 , Maintaining the Core - the Service
Repository ), and it's quite essential for logistic operations.
• You can see the runtime logging call and its data structure. We will use it later
while discussing Error Handling.
• The last reason is deducted from the common question—it seems that the Basic
Event record contains only the object key, object name, key ID data, CRUD oper-
ation indicator, and some timestamps. Would it be enough? The common answer
is, amazingly, yes! With proper DB organization, you can construct the Business
Object by just using these parameters (OEBS DB is based on Oracle Trading
Community Architecture, TCA standard— http://docs.oracle.com/cd/E18727_01/
doc.121/e13570/toc.htm —and is really well organized). Still, we can supply any
Event Handler with ADT array, which is part of the BasicEvent record, holding
20 elements for any object / object context-related data you will ever need in fur-
ther message construction and propagation. You can increase the number of ele-
ments, but in practice, you will never exceed the proposed number. Naturally, the
Event Log registration table has a column based on this ADT type and you can
query it without any difficulty. So the compound event key registration part looks
as follows:
--1
new_event_attr.ParameterName :=
'FND_GLOBAL.USER_NAME';
new_event_attr.ParameterValue := 'NA';
new_event_attr.BusinessName :=
'FND_GLOBAL.USER_NAME';
new_event_attr.ParameterType := 'VARCHAR2';
new_event_attr.ParameterOrder := 1;
new_event_attr.ParameterStageIndex := 1;
new_event_attr.ParameterStage := 'old';
v_EHS_evtcontext.EXTEND;
v_EHS_evtcontext(1) := new_event_attr;
--2
new_event_attr.ParameterName :=
'FND_GLOBAL.APPLICATION_NAME';
...
/*---------------------------------------------------------------------------------------
OBJECT SPECIFIC, OPTIONAL
Search WWH ::




Custom Search