[Home] [Help]
PACKAGE: APPS.QP_ATTRIBUTES_PUB
Source
1 PACKAGE QP_Attributes_PUB AS
2 /* $Header: QPXPATRS.pls 120.2 2005/08/03 07:37:43 srashmi noship $ */
3
4 -- Con record type
5
6 TYPE Con_Rec_Type IS RECORD
7 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23 , created_by NUMBER := FND_API.G_MISS_NUM
24 , creation_date DATE := FND_API.G_MISS_DATE
25 , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26 , last_updated_by NUMBER := FND_API.G_MISS_NUM
27 , last_update_date DATE := FND_API.G_MISS_DATE
28 , last_update_login NUMBER := FND_API.G_MISS_NUM
29 , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30 , prc_context_id NUMBER := FND_API.G_MISS_NUM
31 , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32 , program_application_id NUMBER := FND_API.G_MISS_NUM
33 , program_id NUMBER := FND_API.G_MISS_NUM
34 , program_update_date DATE := FND_API.G_MISS_DATE
35 , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36 , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37 , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38 , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39 , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
43 );
44
45 TYPE Con_Tbl_Type IS TABLE OF Con_Rec_Type
46 INDEX BY BINARY_INTEGER;
47
48 -- Con value record type
49
50 TYPE Con_Val_Rec_Type IS RECORD
51 ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
52 , prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
53 , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
54 );
55
56 TYPE Con_Val_Tbl_Type IS TABLE OF Con_Val_Rec_Type
57 INDEX BY BINARY_INTEGER;
58
59 -- Seg record type
60
61 TYPE Seg_Rec_Type IS RECORD
62 ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63 , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64 , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65 , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66 , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67 , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68 , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69 , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70 , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71 , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72 , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73 , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74 , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75 , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76 , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77 , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78 , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79 , created_by NUMBER := FND_API.G_MISS_NUM
80 , creation_date DATE := FND_API.G_MISS_DATE
81 , last_updated_by NUMBER := FND_API.G_MISS_NUM
82 , last_update_date DATE := FND_API.G_MISS_DATE
83 , last_update_login NUMBER := FND_API.G_MISS_NUM
84 , prc_context_id NUMBER := FND_API.G_MISS_NUM
85 , program_application_id NUMBER := FND_API.G_MISS_NUM
86 , program_id NUMBER := FND_API.G_MISS_NUM
87 , program_update_date DATE := FND_API.G_MISS_DATE
88 , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89 , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90 , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91 , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92 , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93 , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94 , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95 , segment_id NUMBER := FND_API.G_MISS_NUM
96 -- Added application_id by : Abhijit
97 , application_id NUMBER := FND_API.G_MISS_NUM
98 , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99 , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100 , user_precedence NUMBER := FND_API.G_MISS_NUM
101 , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102 , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103 , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104 , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105 , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106 , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107 , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108 , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
109 );
110
111 TYPE Seg_Tbl_Type IS TABLE OF Seg_Rec_Type
112 INDEX BY BINARY_INTEGER;
113
114 -- Seg value record type
115
116 TYPE Seg_Val_Rec_Type IS RECORD
117 ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118 , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119 , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120 , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121 , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
122 );
123
124 TYPE Seg_Val_Tbl_Type IS TABLE OF Seg_Val_Rec_Type
125 INDEX BY BINARY_INTEGER;
126
127 -- Variables representing missing records and tables
128
129 G_MISS_CON_REC Con_Rec_Type;
130 G_MISS_CON_VAL_REC Con_Val_Rec_Type;
131 G_MISS_CON_TBL Con_Tbl_Type;
132 G_MISS_CON_VAL_TBL Con_Val_Tbl_Type;
133 G_MISS_SEG_REC Seg_Rec_Type;
134 G_MISS_SEG_VAL_REC Seg_Val_Rec_Type;
135 G_MISS_SEG_TBL Seg_Tbl_Type;
136 G_MISS_SEG_VAL_TBL Seg_Val_Tbl_Type;
137
138 -- Start of Comments
139 -- API name Process_Attributes
140 -- Type Public
141 -- Function
142 --
143 -- Pre-reqs
144 --
145 -- Parameters
146 --
147 -- Version Current version = 1.0
148 -- Initial version = 1.0
149 --
150 -- Notes
151 --
152 -- End of Comments
153
154 PROCEDURE Process_Attributes
155 ( p_api_version_number IN NUMBER
156 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
158 , p_commit IN VARCHAR2 := FND_API.G_FALSE
159 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
161 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162 , p_CON_rec IN Con_Rec_Type :=
163 G_MISS_CON_REC
164 , p_CON_val_rec IN Con_Val_Rec_Type :=
165 G_MISS_CON_VAL_REC
166 , p_SEG_tbl IN Seg_Tbl_Type :=
167 G_MISS_SEG_TBL
168 , p_SEG_val_tbl IN Seg_Val_Tbl_Type :=
169 G_MISS_SEG_VAL_TBL
170 , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
171 , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
172 , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Tbl_Type
173 , x_SEG_val_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Val_Tbl_Type
174 );
175
176 -- Start of Comments
177 -- API name Lock_Attributes
178 -- Type Public
179 -- Function
180 --
181 -- Pre-reqs
182 --
183 -- Parameters
184 --
185 -- Version Current version = 1.0
186 -- Initial version = 1.0
187 --
188 -- Notes
189 --
190 -- End of Comments
191
192 PROCEDURE Lock_Attributes
193 ( p_api_version_number IN NUMBER
194 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
195 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
196 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
198 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
199 , p_CON_rec IN Con_Rec_Type :=
200 G_MISS_CON_REC
201 , p_CON_val_rec IN Con_Val_Rec_Type :=
202 G_MISS_CON_VAL_REC
203 , p_SEG_tbl IN Seg_Tbl_Type :=
204 G_MISS_SEG_TBL
205 , p_SEG_val_tbl IN Seg_Val_Tbl_Type :=
206 G_MISS_SEG_VAL_TBL
207 , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
208 , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
209 , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Tbl_Type
210 , x_SEG_val_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Val_Tbl_Type
211 );
212
213 -- Start of Comments
214 -- API name Get_Attributes
215 -- Type Public
216 -- Function
217 --
218 -- Pre-reqs
219 --
220 -- Parameters
221 --
222 -- Version Current version = 1.0
223 -- Initial version = 1.0
224 --
225 -- Notes
226 --
227 -- End of Comments
228
229 PROCEDURE Get_Attributes
230 ( p_api_version_number IN NUMBER
231 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
232 , p_return_values IN VARCHAR2 := FND_API.G_FALSE
233 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
234 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
235 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236 , p_prc_context_id IN NUMBER :=
237 FND_API.G_MISS_NUM
238 , p_prc_context IN VARCHAR2 :=
239 FND_API.G_MISS_CHAR
240 , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
241 , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
242 , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Tbl_Type
243 , x_SEG_val_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Val_Tbl_Type
244 );
245
246 END QP_Attributes_PUB;