[Home] [Help]
PACKAGE: APPS.INV_EBI_ITEM_PUB
Source
1 PACKAGE INV_EBI_ITEM_PUB AS
2 /* $Header: INVEIPITS.pls 120.13.12010000.4 2009/02/19 11:20:21 prepatel ship $ */
3
4 G_OTYPE_CREATE CONSTANT VARCHAR2(20) := 'CREATE';
5 G_OTYPE_DELETE CONSTANT VARCHAR2(20) := 'DELETE';
6 G_OTYPE_UPDATE CONSTANT VARCHAR2(20) := 'UPDATE';
7 G_OTYPE_SYNC CONSTANT VARCHAR2(20) := 'SYNC';
8 G_DATA_LEVEL_ITEM CONSTANT VARCHAR2(20) := 'ITEM_LEVEL';
9 G_DATA_LEVEL_ITEM_REV CONSTANT VARCHAR2(20) := 'ITEM_REVISION_LEVEL';
10 G_TEMPLATE CONSTANT NUMBER := 1;
11 G_INVENTORY_ITEM CONSTANT NUMBER := 2;
12 G_ORGANIZATION CONSTANT NUMBER := 3;
13 G_ITEM_CATALOG_GROUP CONSTANT NUMBER := 4;
14 G_LIFECYCLE CONSTANT NUMBER := 5;
15 G_CURRENT_PHASE CONSTANT NUMBER := 6;
16 G_REVISION CONSTANT NUMBER := 7;
17 G_HAZARD_CLASS CONSTANT NUMBER := 8;
18 G_ASSET_CATEGORY CONSTANT NUMBER := 9;
19 G_MANUFACTURER CONSTANT NUMBER := 11;
20 G_CATEGORY_SET CONSTANT NUMBER := 12;
21 G_CATEGORY CONSTANT NUMBER := 13;
22 G_ITEM_BALANCE CONSTANT NUMBER := 1;
23 G_ITEM CONSTANT NUMBER := 2;
24
25
26 PROCEDURE validate_item (
27 p_transaction_type IN VARCHAR2
28 ,p_item IN inv_ebi_item_obj
29 ,x_out OUT NOCOPY inv_ebi_item_output_obj
30 );
31
32 PROCEDURE process_item(
33 p_commit IN VARCHAR2
34 ,p_operation IN VARCHAR2
35 ,p_item IN inv_ebi_item_obj
36 ,x_out OUT NOCOPY inv_ebi_item_output_obj
37 );
38
39 PROCEDURE get_item_balance(
40 p_items IN inv_ebi_item_list
41 ,x_item_balance_output OUT NOCOPY inv_ebi_item_bal_output_list
42 ,x_return_status OUT NOCOPY VARCHAR2
43 ,x_msg_count OUT NOCOPY NUMBER
44 ,x_msg_data OUT NOCOPY VARCHAR2
45 );
46
47 PROCEDURE get_item_attributes(
48 p_items IN inv_ebi_item_list
49 ,p_name_val_list IN inv_ebi_name_value_list
50 ,x_item_tbl_obj OUT NOCOPY inv_ebi_item_attr_tbl_obj
51 ,x_return_status OUT NOCOPY VARCHAR2
52 ,x_msg_count OUT NOCOPY NUMBER
53 ,x_msg_data OUT NOCOPY VARCHAR2
54 );
55
56 PROCEDURE process_item_list(
57 p_commit IN VARCHAR2
58 ,p_operation IN VARCHAR2
59 ,p_item IN inv_ebi_item_obj_tbl
60 ,x_out OUT NOCOPY inv_ebi_item_output_obj_tbl
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 );
65
66 END INV_EBI_ITEM_PUB;