[Home] [Help]
PACKAGE: APPS.CSP_ASL_PUB
Source
1 PACKAGE CSP_ASL_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspgrecs.pls 115.3 2002/11/26 07:04:48 hhaugeru noship $ */
3
4 -- Start of Comments
5 -- Package name : CSP_ASL_PUB
6 -- Purpose :
7 -- History :
8 -- NOTE :
9 -- End of Comments
10 -- *******************************************************
11 -- Start of Comments
12 -- *******************************************************
13 -- API Name: IMPORT_RECOMENDED_QUANTITIES
14 -- Type : Private
15 -- Pre-Req :
16 -- Parameters:
17 -- IN
18 -- P_Api_Version_Number IN NUMBER,
19 -- P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20 -- P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22 -- p_item_id IN NUMBER,
23 -- p_item_segment1 IN VARCHAR2,
24 -- p_item_segment2 IN VARCHAR2,
25 -- p_item_segment3 IN VARCHAR2,
26 -- p_item_segment4 IN VARCHAR2,
27 -- p_item_segment5 IN VARCHAR2,
28 -- p_item_segment6 IN VARCHAR2,
29 -- p_item_segment7 IN VARCHAR2,
30 -- p_item_segment8 IN VARCHAR2,
31 -- p_item_segment9 IN VARCHAR2,
32 -- p_item_segment10 IN VARCHAR2,
33 -- p_item_segment11 IN VARCHAR2,
34 -- p_item_segment12 IN VARCHAR2,
35 -- p_item_segment13 IN VARCHAR2,
36 -- p_item_segment14 IN VARCHAR2,
37 -- p_item_segment15 IN VARCHAR2,
38 -- p_item_segment16 IN VARCHAR2,
39 -- p_item_segment17 IN VARCHAR2,
40 -- p_item_segment18 IN VARCHAR2,
41 -- p_item_segment19 IN VARCHAR2,
42 -- p_item_segment20 IN VARCHAR2,
43 -- p_organization_id IN NUMBER,
44 -- p_organization_name IN VARCHAR2,
45 -- p_organization_code IN VARCHAR2,
46 -- p_subinventory_code IN VARCHAR2,
47 -- p_recommended_max IN NUMBER,
48 -- p_recommended_min IN NUMBER,
49 --
50 -- OUT:
51 -- x_return_status OUT NOCOPY VARCHAR2
52 -- x_msg_count OUT NOCOPY NUMBER
53 -- x_msg_data OUT NOCOPY VARCHAR2
54 -- Version : Current version 1.0
55 ---
56 ---- End of Comments
57 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSP_ASL_PUB';
58 G_FILE_NAME CONSTANT VARCHAR2(12) := 'cspgrecs.pls';
59
60 PROCEDURE IMPORT_RECOMENDED_QUANTITIES(P_Api_Version_Number IN NUMBER,
61 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
62 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_item_id IN NUMBER,
65 p_item_segment1 IN VARCHAR2,
66 p_item_segment2 IN VARCHAR2,
67 p_item_segment3 IN VARCHAR2,
68 p_item_segment4 IN VARCHAR2,
69 p_item_segment5 IN VARCHAR2,
70 p_item_segment6 IN VARCHAR2,
71 p_item_segment7 IN VARCHAR2,
72 p_item_segment8 IN VARCHAR2,
73 p_item_segment9 IN VARCHAR2,
74 p_item_segment10 IN VARCHAR2,
75 p_item_segment11 IN VARCHAR2,
76 p_item_segment12 IN VARCHAR2,
77 p_item_segment13 IN VARCHAR2,
78 p_item_segment14 IN VARCHAR2,
79 p_item_segment15 IN VARCHAR2,
80 p_item_segment16 IN VARCHAR2,
81 p_item_segment17 IN VARCHAR2,
82 p_item_segment18 IN VARCHAR2,
83 p_item_segment19 IN VARCHAR2,
84 p_item_segment20 IN VARCHAR2,
85 p_organization_id IN NUMBER,
86 p_organization_name IN VARCHAR2,
87 p_organization_code IN VARCHAR2,
88 p_subinventory_code IN VARCHAR2,
89 p_recommended_max IN NUMBER,
90 p_recommended_min IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 X_Msg_Count OUT NOCOPY NUMBER,
93 X_Msg_Data OUT NOCOPY VARCHAR2);
94 PROCEDURE PURGE_OLD_RECOMMENDATIONS(P_Api_Version_Number IN NUMBER,
95 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
96 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
97 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_Msg_Count OUT NOCOPY NUMBER,
100 x_Msg_Data OUT NOCOPY VARCHAR2);
101
102 END CSP_ASL_PUB;