1 PACKAGE CN_SEAS_SCHEDULES_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvsschs.pls 115.4 2002/11/21 21:19:30 hlchen ship $
3
4 TYPE seas_schedules_rec_type IS RECORD
5 ( SEAS_SCHEDULE_ID cn_seas_schedules.SEAS_SCHEDULE_ID%TYPE := NULL,
6 NAME cn_seas_schedules.NAME%TYPE := FND_API.G_MISS_CHAR,
7 DESCRIPTION cn_seas_schedules.DESCRIPTION%TYPE := FND_API.G_MISS_CHAR,
8 PERIOD_YEAR cn_seas_schedules.PERIOD_YEAR%TYPE := FND_API.G_MISS_NUM,
9 START_DATE cn_seas_schedules.START_DATE%TYPE := FND_API.G_MISS_DATE,
10 END_DATE cn_seas_schedules.END_DATE%TYPE := FND_API.G_MISS_DATE,
11 VALIDATION_STATUS cn_seas_schedules.VALIDATION_STATUS%TYPE := FND_API.G_MISS_CHAR,
12 OBJECT_VERSION_NUMBER cn_seas_schedules.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
13 ) ;
14
15 TYPE seas_schedules_tbl_type IS TABLE OF seas_schedules_rec_type INDEX BY BINARY_INTEGER;
16
17
18 -- Start of comments
19 -- API name : Create_Seas_Schedule
20 -- Type : Private.
21 -- Function :
22 -- Pre-reqs : None.
23 -- Parameters :
24 -- IN : p_api_version IN NUMBER Required
25 -- p_init_msg_list IN VARCHAR2 Optional
26 -- Default = FND_API.G_FALSE
27 -- p_commit IN VARCHAR2 Optional
28 -- Default = FND_API.G_FALSE
29 -- p_validation_level IN NUMBER Optional
30 -- Default = FND_API.G_VALID_LEVEL_FULL
31 -- p_seas_schedules_tbl_type IN seas_schedules_tbl_type
32 -- OUT : x_return_status OUT VARCHAR2(1)
33 -- x_msg_count OUT NUMBER
34 -- x_msg_data OUT VARCHAR2(2000)
35 --
36 -- Version : Current version 1.0
37 --
38 --
39 --
40 -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
41 -- and CN_SEASONALITIES_PKG to insert rows into CN_SEAS_SCHEDULES
42 -- and CN_SEASONALITIES after some validations.
43 --
44 -- End of comments
45
46 PROCEDURE Create_Seas_Schedule
47 ( p_api_version IN NUMBER ,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_seas_schedules_rec_type IN seas_schedules_rec_type,
52 x_seas_schedule_id OUT NOCOPY NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2 ,
54 x_msg_count OUT NOCOPY NUMBER ,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58
59 -- Start of comments
60 -- API name : Update_Seas_Schedule
61 -- Type : Private.
62 -- Function :
63 -- Pre-reqs : None.
64 -- Parameters :
65 -- IN : p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional
71 -- Default = FND_API.G_VALID_LEVEL_FULL
72 -- p_seas_schedules_tbl_type IN seas_schedules_tbl_type
73 -- OUT : x_return_status OUT VARCHAR2(1)
74 -- x_msg_count OUT NUMBER
75 -- x_msg_data OUT VARCHAR2(2000)
76 --
77 -- Version : Current version 1.0
78 --
79 --
80 --
81 -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
82 -- to update rows into CN_SEAS_SCHEDULES after some validations.
83 --
84 -- End of comments
85
86 PROCEDURE Update_Seas_Schedule
87 ( p_api_version IN NUMBER ,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 p_seas_schedules_rec_type IN seas_schedules_rec_type,
92 x_return_status OUT NOCOPY VARCHAR2 ,
93 x_msg_count OUT NOCOPY NUMBER ,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97
98 -- Start of comments
99 -- API name : Delete_Seas_Schedule
100 -- Type : Private.
101 -- Function :
102 -- Pre-reqs : None.
103 -- Parameters :
104 -- IN : p_api_version IN NUMBER Required
105 -- p_init_msg_list IN VARCHAR2 Optional
106 -- Default = FND_API.G_FALSE
107 -- p_commit IN VARCHAR2 Optional
108 -- Default = FND_API.G_FALSE
109 -- p_validation_level IN NUMBER Optional
110 -- Default = FND_API.G_VALID_LEVEL_FULL
111 -- P_SEAS_SCHEDULE_ID IN NUMBER Required
112 --
113 -- OUT : x_return_status OUT VARCHAR2(1)
114 -- x_msg_count OUT NUMBER
115 -- x_msg_data OUT VARCHAR2(2000)
116 --
117 --
118 -- Version : Current version 1.0
119 --
120 --
121 --
122 -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
123 -- and CN_SEASONALITIES_PKG to delete rows into CN_SEAS_SCHEDULES
124 -- and CN_SEASONALITIES after the validations are done.
125 --
126 -- End of comments
127
128 PROCEDURE Delete_Seas_Schedule
129 ( p_api_version IN NUMBER ,
130 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
131 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
132 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
133 P_SEAS_SCHEDULE_ID IN cn_seas_schedules.seas_schedule_id%TYPE,
134 x_return_status OUT NOCOPY VARCHAR2 ,
135 x_msg_count OUT NOCOPY NUMBER ,
136 x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140 -- Start of comments
141 -- API name : Sum_Seas_Schedule
142 -- Type : Private.
143 -- Function :
144 -- Pre-reqs : None.
145 -- Parameters :
146 -- IN : p_api_version IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional
148 -- Default = FND_API.G_FALSE
149 -- p_commit IN VARCHAR2 Optional
150 -- Default = FND_API.G_FALSE
151 -- p_validation_level IN NUMBER Optional
152 -- Default = FND_API.G_VALID_LEVEL_FULL
153 -- P_SEAS_SCHEDULE_ID IN NUMBER Required
154 --
155 -- OUT : x_seas_schedule_sum OUT NUMBER,
156 -- x_return_status OUT VARCHAR2(1)
157 -- x_msg_count OUT NUMBER
158 -- x_msg_data OUT VARCHAR2(2000)
159 --
160 --
161 -- Version : Current version 1.0
162 --
163 --
164 --
165 -- Notes : This procedures find the sum of seasonalities
166 -- End of comments
167
168 PROCEDURE Sum_Seas_Schedule
169 ( p_api_version IN NUMBER ,
170 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
171 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
172 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173 p_seas_schedules_id IN NUMBER,
174 x_seas_schedule_sum OUT NOCOPY NUMBER,
175 x_return_status OUT NOCOPY VARCHAR2 ,
176 x_msg_count OUT NOCOPY NUMBER ,
177 x_msg_data OUT NOCOPY VARCHAR2
178 );
179
180 END cn_seas_schedules_PVT;