[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_SEG
Source
1 PACKAGE QP_QP_Form_Seg AUTHID CURRENT_USER AS
2 /* $Header: QPXFSEGS.pls 120.2 2005/08/03 07:37:18 srashmi noship $ */
3
4 -- Procedure : Default_Attributes
5 --
6
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
9 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
10 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_availability_in_basic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_prc_context_id OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_seeded_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_seeded_format_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_seeded_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
32 , x_seeded_segment_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 , x_seeded_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34 , x_seeded_valueset_id OUT NOCOPY /* file.sql.39 change */ NUMBER
35 , x_segment_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 , x_segment_id OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_segment_mapping_column OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_user_format_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_user_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
41 , x_user_segment_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_user_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_user_valueset_id OUT NOCOPY /* file.sql.39 change */ NUMBER
44 , x_prc_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_seeded OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_seeded_valueset OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_user_valueset OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_required_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 , x_party_hierarchy_enabled_flag OUT NOCOPY VARCHAR2 -- Added for TCA
51 );
52
53 -- Procedure : Change_Attribute
54 --
55
56 PROCEDURE Change_Attribute
57 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
59 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , p_segment_id IN NUMBER
61 , p_attr_id IN NUMBER
62 , p_attr_value IN VARCHAR2
63 , p_attribute1 IN VARCHAR2
64 , p_attribute10 IN VARCHAR2
65 , p_attribute11 IN VARCHAR2
66 , p_attribute12 IN VARCHAR2
67 , p_attribute13 IN VARCHAR2
68 , p_attribute14 IN VARCHAR2
69 , p_attribute15 IN VARCHAR2
70 , p_attribute2 IN VARCHAR2
71 , p_attribute3 IN VARCHAR2
72 , p_attribute4 IN VARCHAR2
73 , p_attribute5 IN VARCHAR2
74 , p_attribute6 IN VARCHAR2
75 , p_attribute7 IN VARCHAR2
76 , p_attribute8 IN VARCHAR2
77 , p_attribute9 IN VARCHAR2
78 , p_context IN VARCHAR2
79 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_availability_in_basic OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_prc_context_id OUT NOCOPY /* file.sql.39 change */ NUMBER
97 , x_seeded_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_seeded_format_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 , x_seeded_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
100 , x_seeded_segment_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_seeded_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_seeded_valueset_id OUT NOCOPY /* file.sql.39 change */ NUMBER
103 , x_segment_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_segment_id OUT NOCOPY /* file.sql.39 change */ NUMBER
105 , x_application_id OUT NOCOPY /* file.sql.39 change */ NUMBER
106 , x_segment_mapping_column OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_user_format_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_user_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
109 , x_user_segment_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_user_description OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_user_valueset_id OUT NOCOPY /* file.sql.39 change */ NUMBER
112 , x_prc_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , x_seeded OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_seeded_valueset OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_segment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_user_valueset OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_required_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_party_hierarchy_enabled_flag OUT NOCOPY VARCHAR2 -- Added for TCA
119 );
120
121 -- Procedure Validate_And_Write
122 --
123
124 PROCEDURE Validate_And_Write
125 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
127 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , p_segment_id IN NUMBER
129 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
130 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
131 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
132 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
133 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
134 );
135
136 -- Procedure Delete_Row
137 --
138
139 PROCEDURE Delete_Row
140 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
142 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , p_segment_id IN NUMBER
144 );
145
146 -- Procedure Process_Entity
147 --
148
149 PROCEDURE Process_Entity
150 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
152 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 );
154
155 -- Procedure lock_Row
156 --
157
158 PROCEDURE Lock_Row
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_attribute1 IN VARCHAR2
163 , p_attribute10 IN VARCHAR2
164 , p_attribute11 IN VARCHAR2
165 , p_attribute12 IN VARCHAR2
166 , p_attribute13 IN VARCHAR2
167 , p_attribute14 IN VARCHAR2
168 , p_attribute15 IN VARCHAR2
169 , p_attribute2 IN VARCHAR2
170 , p_attribute3 IN VARCHAR2
171 , p_attribute4 IN VARCHAR2
172 , p_attribute5 IN VARCHAR2
173 , p_attribute6 IN VARCHAR2
174 , p_attribute7 IN VARCHAR2
175 , p_attribute8 IN VARCHAR2
176 , p_attribute9 IN VARCHAR2
177 , p_availability_in_basic IN VARCHAR2
178 , p_context IN VARCHAR2
179 , p_created_by IN NUMBER
180 , p_creation_date IN DATE
181 , p_last_updated_by IN NUMBER
182 , p_last_update_date IN DATE
183 , p_last_update_login IN NUMBER
184 , p_prc_context_id IN NUMBER
185 , p_program_application_id IN NUMBER
186 , p_program_id IN NUMBER
187 , p_program_update_date IN DATE
188 , p_seeded_flag IN VARCHAR2
189 , p_seeded_format_type IN VARCHAR2
190 , p_seeded_precedence IN NUMBER
191 , p_seeded_segment_name IN VARCHAR2
192 , p_seeded_description IN VARCHAR2
193 , p_seeded_valueset_id IN NUMBER
194 , p_segment_code IN VARCHAR2
195 , p_segment_id IN NUMBER
196 , p_application_id IN NUMBER
197 , p_segment_mapping_column IN VARCHAR2
198 , p_user_format_type IN VARCHAR2
199 , p_user_precedence IN NUMBER
200 , p_user_segment_name IN VARCHAR2
201 , p_user_description IN VARCHAR2
202 , p_user_valueset_id IN NUMBER
203 , p_required_flag IN VARCHAR2
204 , p_party_hierarchy_enabled_flag IN VARCHAR2 -- Added for TCA
205 );
206
207 END QP_QP_Form_Seg;