1 Package INV_ENI_ITEMS_STAR_PKG AUTHID CURRENT_USER AS
2 /* $Header: INVENICS.pls 120.1 2005/08/04 06:22:07 lparihar noship $ */
3
4 -- Create or update an item-category assignment
5
6 PROCEDURE Sync_Category_Assignments(
7 p_api_version IN NUMBER
8 ,p_init_msg_list IN VARCHAR2 := 'F'
9 ,p_inventory_item_id IN NUMBER
10 ,p_organization_id IN NUMBER
11 ,p_category_set_id IN NUMBER
12 ,p_old_category_id IN NUMBER
13 ,p_new_category_id IN NUMBER
14 ,x_return_status OUT NOCOPY VARCHAR2
15 ,x_msg_count OUT NOCOPY NUMBER
16 ,x_msg_data OUT NOCOPY VARCHAR2);
17
18 PROCEDURE Update_ENI_Staging_Table(
19 p_mode_flag IN VARCHAR2
20 ,p_category_set_id IN NUMBER
21 ,p_category_id IN NUMBER
22 ,p_language_code IN VARCHAR2
23 ,x_return_status OUT NOCOPY VARCHAR2
24 ,x_msg_count OUT NOCOPY NUMBER
25 ,x_msg_data OUT NOCOPY VARCHAR2);
26
27 PROCEDURE SYNC_STAR_ITEMS_FROM_IOI(
28 p_api_version IN NUMBER
29 ,p_init_msg_list IN VARCHAR2 := 'F'
30 ,p_set_process_id IN NUMBER
31 ,x_return_status OUT NOCOPY VARCHAR2
32 ,x_msg_count OUT NOCOPY NUMBER
33 ,x_msg_data OUT NOCOPY VARCHAR2);
34
35 PROCEDURE Sync_Star_ItemCatg_From_COI(
36 p_api_version IN NUMBER
37 ,p_init_msg_list IN VARCHAR2 := 'F'
38 ,p_set_process_id IN NUMBER
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2);
42
43 End INV_ENI_ITEMS_STAR_PKG;