[Home] [Help]
PACKAGE: APPS.ENI_ITEMS_STAR_PKG
Source
1 Package ENI_ITEMS_STAR_PKG AS
2 /* $Header: ENIIDBCS.pls 120.1 2005/08/22 05:58:21 lparihar noship $ */
3
4 PROCEDURE CREATE_STAR_TABLE(errbuf OUT NOCOPY varchar2,
5 retcode OUT NOCOPY varchar2);
6
7 -- Insert new item
8
9 PROCEDURE Insert_Items_In_Star(p_api_version NUMBER,
10 p_init_msg_list VARCHAR2 := 'F',
11 p_inventory_item_id NUMBER,
12 p_organization_id NUMBER,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 X_MSG_DATA OUT NOCOPY VARCHAR2);
16
17 --Delete item
18
19 PROCEDURE Delete_Items_In_Star(p_api_version NUMBER,
20 p_init_msg_list VARCHAR2 := 'F',
21 p_inventory_item_id NUMBER,
22 p_organization_id NUMBER,
23 x_return_status OUT NOCOPY VARCHAR2,
24 x_msg_count OUT NOCOPY NUMBER,
25 X_MSG_DATA OUT NOCOPY VARCHAR2);
26
27 -- Update concatenated segments for an existing item
28
29 PROCEDURE Update_Items_In_Star(p_api_version NUMBER,
30 p_init_msg_list VARCHAR2 := 'F',
31 p_inventory_item_id NUMBER,
32 p_organization_id NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 X_MSG_DATA OUT NOCOPY VARCHAR2);
36
37 -- Create or Change an category assignment
38
39 PROCEDURE Update_Categories(p_api_version NUMBER,
40 p_init_msg_list VARCHAR2 := 'F',
41 p_category_id NUMBER,
42 p_structure_id NUMBER,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 X_MSG_DATA OUT NOCOPY VARCHAR2);
46
47 -- UPdate or delete item-category assignment
48
49 PROCEDURE Sync_Category_Assignments(p_api_version NUMBER,
50 p_init_msg_list VARCHAR2 := 'F',
51 p_inventory_item_id NUMBER,
52 p_organization_id NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 X_MSG_DATA OUT NOCOPY VARCHAR2);
56
57 -- Inserts/updates item star table from item open interface
58
59 PROCEDURE Sync_Star_Items_From_IOI(p_api_version NUMBER,
60 p_init_msg_list VARCHAR2 := 'F',
61 p_set_process_id NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 X_MSG_DATA OUT NOCOPY VARCHAR2);
65
66 -- Inserts/Deletes item category assignment from star table from
67 -- Categories open interface
68
69 PROCEDURE Sync_Star_ItemCatg_From_COI(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := 'F',
72 p_set_process_id IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 X_MSG_DATA OUT NOCOPY VARCHAR2);
76
77 End ENI_ITEMS_STAR_PKG;