[Home] [Help]
PACKAGE: APPS.CN_SEASONALITIES_PVT
Source
1 PACKAGE CN_SEASONALITIES_PVT AUTHID CURRENT_USER AS
2 -- $Header: cnvseass.pls 115.4 2002/11/21 21:18:19 hlchen ship $
3
4 TYPE cp_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 seasonalities_rec_type IS RECORD
16 ( SEAS_SCHEDULE_ID cn_seasonalities.SEAS_SCHEDULE_ID%TYPE := NULL,
17 SEASONALITY_ID cn_seasonalities.SEASONALITY_ID%TYPE := NULL,
18 PCT_SEASONALITY cn_seasonalities.PCT_SEASONALITY%TYPE := NULL,
19 OBJECT_VERSION_NUMBER cn_seasonalities.OBJECT_VERSION_NUMBER%TYPE:= FND_API.G_MISS_NUM
20 ) ;
21
22 TYPE seasonalities_tbl_type IS TABLE OF seasonalities_rec_type INDEX BY BINARY_INTEGER;
23
24 -- Start of comments
25 -- API name : Update_Seasonalities
26 -- Type : Private.
27 -- Function :
28 -- Pre-reqs : None.
29 -- Parameters :
30 -- IN : p_api_version IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Optional
32 -- Default = FND_API.G_FALSE
33 -- p_commit IN VARCHAR2 Optional
34 -- Default = FND_API.G_FALSE
35 -- p_validation_level IN NUMBER Optional
36 -- Default = FND_API.G_VALID_LEVEL_FULL
37 -- p_seasonalities_rec_type IN seasonalities_rec_type
38 -- OUT : x_return_status OUT VARCHAR2(1)
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2(2000)
41 --
42 -- Version : Current version 1.0
43 --
44 --
45 --
46 -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
47 -- to update rows into CN_SEAS_SCHEDULES after some validations.
48 --
49 -- End of comments
50
51 PROCEDURE Update_Seasonalities
52 ( p_api_version IN NUMBER ,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 p_seasonalities_rec_type IN seasonalities_rec_type,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2
60 );
61
62
63 -- Start of comments
64 -- API name : Validate_Seasonalities
65 -- Type : Private.
66 -- Function :
67 -- Pre-reqs : None.
68 -- Parameters :
69 -- IN : p_api_version IN NUMBER Required
70 -- p_init_msg_list IN VARCHAR2 Optional
71 -- Default = FND_API.G_FALSE
72 -- p_commit IN VARCHAR2 Optional
73 -- Default = FND_API.G_FALSE
74 -- p_validation_level IN NUMBER Optional
75 -- Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_seas_schedule_id IN NUMBER
77 -- OUT : x_return_status OUT VARCHAR2(1)
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2(2000)
80 --
81 -- Version : Current version 1.0
82 --
83 --
84 --
85 -- Notes : This procedure uses the table handler CN_SEAS_SCHEDULES_PKG
86 -- to update rows into CN_SEAS_SCHEDULES after some validations.
87 --
88 -- End of comments
89
90 PROCEDURE Validate_Seasonalities
91 ( p_api_version IN NUMBER ,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_seas_schedule_rec_type IN cp_seas_schedules_rec_type,
96 x_return_status OUT NOCOPY VARCHAR2 ,
97 x_msg_count OUT NOCOPY NUMBER ,
98 x_msg_data OUT NOCOPY VARCHAR2
99 );
100
101
102 END CN_SEASONALITIES_PVT;