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