1 PACKAGE CSP_SUPERSESSIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cspgsups.pls 115.7 2002/11/26 06:54:41 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_SUPERSESSIONS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 TYPE number_arr IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11
12 PROCEDURE PROCESS_SUPERSESSIONS(errbuf OUT NOCOPY varchar2,
13 retcode OUT NOCOPY number);
14 PROCEDURE check_for_supersede_item(p_inventory_item_id IN NUMBER
15 ,p_organization_id IN NUMBER
16 ,x_supersede_item OUT NOCOPY NUMBER);
17 PROCEDURE get_supersede_bilateral_items(p_inventory_item_id IN NUMBER
18 ,p_organization_id IN NUMBER
19 ,x_supersede_items OUT NOCOPY CSP_SUPERSESSIONS_PVT.number_arr);
20 PROCEDURE get_top_supersede_item(p_item_id IN NUMBER
21 ,p_org_id IN NUMBER
22 ,x_item_id OUT NOCOPY NUMBER);
23 PROCEDURE get_replaced_items_list(p_inventory_item_id IN NUMBER
24 ,p_organization_id IN NUMBER
25 ,x_replaced_item_list OUT NOCOPY VARCHAR2);
26 PROCEDURE PROCESS_SUPERSESSIONS(p_level_id IN VARCHAR2
27 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
28 ,x_return_status OUT NOCOPY VARCHAR2
29 ,x_msg_data OUT NOCOPY varchar2
30 ,x_msg_count OUT NOCOPY NUMBER);
31
32 PROCEDURE check_for_duplicate_parts(l_parts_list IN CSP_SCH_INT_PVT.CSP_PARTS_TBL_TYP1
33 ,p_org_id IN NUMBER
34 ,x_return_status OUT NOCOPY varchar2
35 ,x_message OUT NOCOPY varchar2
36 ,x_msg_count OUT NOCOPY NUMBER);
37
38 END;