[Home] [Help]
PACKAGE: APPS.CN_ATTAIN_SCHEDULE_PVT
Source
1 PACKAGE CN_ATTAIN_SCHEDULE_PVT AUTHID CURRENT_USER AS
2 /*$Header: cnvatshs.pls 115.3 2002/11/21 21:11:37 hlchen ship $*/
3
4 -- job title
5 TYPE attain_schedule_rec_type IS RECORD
6 (
7 ATTAIN_SCHEDULE_ID NUMBER := NULL,
8 NAME VARCHAR2(30) := NULL,
9 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
10 ATTRIBUTE1 VARCHAR2(150) := NULL,
11 ATTRIBUTE2 VARCHAR2(150) := NULL,
12 ATTRIBUTE3 VARCHAR2(150) := NULL,
13 ATTRIBUTE4 VARCHAR2(150) := NULL,
14 ATTRIBUTE5 VARCHAR2(150) := NULL,
15 ATTRIBUTE6 VARCHAR2(150) := NULL,
16 ATTRIBUTE7 VARCHAR2(150) := NULL,
17 ATTRIBUTE8 VARCHAR2(150) := NULL,
18 ATTRIBUTE9 VARCHAR2(150) := NULL,
19 ATTRIBUTE10 VARCHAR2(150) := NULL,
20 ATTRIBUTE11 VARCHAR2(150) := NULL,
21 ATTRIBUTE12 VARCHAR2(150) := NULL,
22 ATTRIBUTE13 VARCHAR2(150) := NULL,
23 ATTRIBUTE14 VARCHAR2(150) := NULL,
24 ATTRIBUTE15 VARCHAR2(150) := NULL,
25 OBJECT_VERSION_NUMBER NUMBER := NULL
26 ) ;
27
28 TYPE attain_schedule_tbl_type IS
29 TABLE OF attain_schedule_rec_type INDEX BY BINARY_INTEGER ;
30
31 -- Global variable that represent missing values.
32
33 G_MISS_ATTAIN_SCHEDULE_REC attain_schedule_rec_type;
34 G_MISS_ATTAIN_SCHEDULE_REC_TB attain_schedule_tbl_type;
35
36 -- Start of comments
37 -- API name : Create_Attain_Schedule
38 -- Type : Private.
39 -- Function :
40 -- Pre-reqs : None.
41 -- Parameters :
42 -- IN : p_api_version IN NUMBER Required
43 -- p_init_msg_list IN VARCHAR2 Optional
44 -- Default = FND_API.G_FALSE
45 -- p_commit IN VARCHAR2 Optional
46 -- Default = FND_API.G_FALSE
47 -- p_validation_level IN NUMBER Optional
48 -- Default = FND_API.G_VALID_LEVEL_FULL
49 -- p_attain_schedule IN attain_schedule_rec_type
50 -- OUT : x_return_status OUT VARCHAR2(1)
51 -- x_msg_count OUT NUMBER
52 -- x_msg_data OUT VARCHAR2(2000)
53 -- Version : Current version 1.0
54 -- Notes : Note text
55 --
56 -- End of comments
57 PROCEDURE Create_Attain_Schedule
58 (p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_attain_schedule IN attain_schedule_rec_type,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2);
66
67 -- Start of comments
68 -- API name : Update_Attain_Schedule
69 -- Type : Private.
70 -- Function :
71 -- Pre-reqs : None.
72 -- Parameters :
73 -- IN : p_api_version IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional
75 -- Default = FND_API.G_FALSE
76 -- p_commit IN VARCHAR2 Optional
77 -- Default = FND_API.G_FALSE
78 -- p_validation_level IN NUMBER Optional
79 -- Default = FND_API.G_VALID_LEVEL_FULL
80 -- p_attain_schedule IN attain_schedule_rec_type
81 -- OUT : x_return_status OUT VARCHAR2(1)
82 -- x_msg_count OUT NUMBER
83 -- x_msg_data OUT VARCHAR2(2000)
84 -- Version : Current version 1.0
85 -- Notes : Note text
86 --
87 -- End of comments
88 PROCEDURE Update_Attain_Schedule
89 (p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
91 p_commit IN VARCHAR2 := FND_API.G_FALSE,
92 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
93 p_attain_schedule IN attain_schedule_rec_type,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2 );
97
98 -- Start of comments
99 -- API name : Delete_Attain_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_attain_schedule IN attain_schedule_rec_type
112 -- OUT : x_return_status OUT VARCHAR2(1)
113 -- x_msg_count OUT NUMBER
114 -- x_msg_data OUT VARCHAR2(2000)
115 -- Version : Current version 1.0
116 -- Notes : Note text
117 --
118 -- End of comments
119 PROCEDURE Delete_Attain_Schedule
120 (p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122 p_commit IN VARCHAR2 := FND_API.G_FALSE,
123 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124 p_attain_schedule IN attain_schedule_rec_type,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2);
128
129 -- Start of comments
130 -- API name : Get_Attain_Schedule
131 -- Type : Private.
132 -- Function :
133 -- Pre-reqs : None.
134 -- Parameters :
135 -- IN : p_api_version IN NUMBER Required
136 -- p_init_msg_list IN VARCHAR2 Optional
137 -- Default = FND_API.G_FALSE
138 -- p_commit IN VARCHAR2 Optional
139 -- Default = FND_API.G_FALSE
140 -- p_validation_level IN NUMBER Optional
141 -- Default = FND_API.G_VALID_LEVEL_FULL
142 -- OUT : x_return_status OUT VARCHAR2(1)
143 -- x_msg_count OUT NUMBER
144 -- x_msg_data OUT VARCHAR2(2000)
145 -- x_attain_schedule OUT attain_schedule_tbl_type
146 -- Version : Current version 1.0
147 -- Notes : Note text
148 --
149 -- End of comments
150 PROCEDURE Get_Attain_Schedule
151 (p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 p_commit IN VARCHAR2 := FND_API.G_FALSE,
154 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155 x_attain_schedule OUT NOCOPY attain_schedule_tbl_type,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2);
159
160
161 END CN_ATTAIN_SCHEDULE_PVT;