1 PACKAGE mtl_og_util_pkg AUTHID CURRENT_USER AS
2 /* $Header: INVOGUTS.pls 115.6 2002/12/01 02:27:58 rbande ship $ */
3
4 PROCEDURE get_objid(
5 p_object_number IN VARCHAR2
6 , p_inventory_item_id IN NUMBER
7 , p_organization_id IN NUMBER := NULL
8 , x_object_id OUT NOCOPY NUMBER
9 , x_object_type OUT NOCOPY NUMBER
10 , x_return_status OUT NOCOPY VARCHAR2
11 , x_msg_data OUT NOCOPY VARCHAR2
12 , x_msg_count OUT NOCOPY NUMBER
13 );
14
15 PROCEDURE gen_insert(
16 p_rowid IN OUT NOCOPY VARCHAR2
17 , p_item_id IN NUMBER
18 , p_object_num IN VARCHAR2
19 , p_parent_item_id IN NUMBER
20 , p_parent_object_num IN VARCHAR2
21 , p_origin_txn_id IN NUMBER
22 , p_org_id IN NUMBER := NULL
23 );
24
25 PROCEDURE gen_insert(
26 x_return_status OUT NOCOPY VARCHAR2
27 , x_msg_data OUT NOCOPY VARCHAR2
28 , x_msg_count OUT NOCOPY NUMBER
29 , p_item_id IN NUMBER
30 , p_object_num IN VARCHAR2
31 , p_parent_item_id IN NUMBER
32 , p_parent_object_num IN VARCHAR2
33 , p_origin_txn_id IN NUMBER
34 , p_org_id IN NUMBER := NULL
35 );
36
37 PROCEDURE event_insert(
38 p_rowid IN OUT NOCOPY VARCHAR2
39 , p_item_id IN NUMBER
40 , p_object_number IN VARCHAR2
41 , p_trx_id IN NUMBER
42 , p_trx_date IN DATE
43 , p_trx_src_id IN NUMBER
44 , p_trx_actin_id IN NUMBER
45 , p_org_id IN NUMBER := NULL
46 );
47
48 /** added the procedure gen_update for the 'Serial Tracking in WIP Project.
49 This updates the mtl_object_genealogy and mtl_serial_numbers tables
50 when a serialized component is returned to stores from a WIP job.
51 The genealogy between the parent and the child serials should be disabled
52 whenever a component return transaction is performed. */
53
54 PROCEDURE gen_update(
55 x_return_status OUT NOCOPY VARCHAR2
56 , x_msg_data OUT NOCOPY VARCHAR2
57 , x_msg_count OUT NOCOPY NUMBER
58 , p_item_id IN NUMBER
59 , p_sernum IN VARCHAR2
60 , p_parent_sernum IN VARCHAR2
61 , p_org_id IN NUMBER
62 );
63
64 END mtl_og_util_pkg;