1 PACKAGE WSH_OTM_SYNC_ITEM_PKG AS
2 /* $Header: WSHTMITS.pls 120.0.12000000.2 2007/03/20 18:47:45 schennal noship $ */
3
4 --Record of item
5 TYPE item_info IS RECORD(
6 item_id NUMBER,
7 item_name VARCHAR2(100),
8 item_description VARCHAR2(240),
9 last_update_date DATE,
10 org_id NUMBER
11 );
12
13 --Table of the record item_info
14 TYPE item_info_tbl IS TABLE OF item_info INDEX BY BINARY_INTEGER;
15
16 -----------------------------------------------------------------------------
17 --
18 -- Function :get_EBS_item_info
19 -- Parameters :p_entity_in_rec is the input rec type.
20 -- It has the entity_type, entity id and parent entity id
21 -- x_transmission_id Transmission id passed to the caller
22 -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
23 -- Description :This Function takes input from the txn service and passes
24 -- the item data back. The item data is passed in the form of
25 -- of collection WSH_OTM_GLOG_ITEM_TBL thats maps to
26 -- GLOG Schema ITEMMASTER
27 -----------------------------------------------------------------------------
28 FUNCTION get_EBS_item_info( p_entity_in_rec IN WSH_OTM_ENTITY_REC_TYPE,
29 x_transmission_id OUT NOCOPY NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2
31 ) RETURN WSH_OTM_GLOG_ITEM_TBL;
32
33
34 -----------------------------------------------------------------------------
35 --
36 -- Procedure :remove_duplicate_items
37 -- Parameters :p_item_tbl is the input table of item_info_tbl.
38 -- x_return_status Returns WSH_UTIL_CORE.G_RET_STS_SUCCESS if Success
39 -- Description :This procedure take in the input table and removes all the
40 -- duplicate rows.
41 -----------------------------------------------------------------------------
42 PROCEDURE remove_duplicate_items(p_item_tbl IN OUT NOCOPY item_info_tbl,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45 END WSH_OTM_SYNC_ITEM_PKG;
[Home] [Help]