[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_CURR_DETAILS
Source
1 PACKAGE QP_QP_Form_Curr_Details AUTHID CURRENT_USER AS
2 /* $Header: QPXFCDTS.pls 120.1 2005/06/12 23:48:55 appldev $ */
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 , p_currency_header_id IN NUMBER -- Added by Sunil
12 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_conversion_date OUT NOCOPY /* file.sql.39 change */ DATE
29 , x_conversion_date_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 -- , x_conversion_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_conversion_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_currency_detail_id OUT NOCOPY /* file.sql.39 change */ NUMBER
33 , x_currency_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
34 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
35 , x_fixed_value OUT NOCOPY /* file.sql.39 change */ NUMBER
36 , x_markup_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_markup_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 , x_markup_value OUT NOCOPY /* file.sql.39 change */ NUMBER
39 , x_price_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
40 , x_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
41 , x_selling_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
42 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
43 , x_to_currency_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_currency_detail OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_currency_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_markup_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_price_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_to_currency OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_curr_attribute_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 , x_curr_attribute_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , x_curr_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_curr_attribute_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
54 );
55
56 -- Procedure : Change_Attribute
57 --
58
59 PROCEDURE Change_Attribute
60 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 , p_currency_detail_id IN NUMBER
64 , p_attr_id IN NUMBER
65 , p_attr_value IN VARCHAR2
66 , p_attribute1 IN VARCHAR2
67 , p_attribute10 IN VARCHAR2
68 , p_attribute11 IN VARCHAR2
69 , p_attribute12 IN VARCHAR2
70 , p_attribute13 IN VARCHAR2
71 , p_attribute14 IN VARCHAR2
72 , p_attribute15 IN VARCHAR2
73 , p_attribute2 IN VARCHAR2
74 , p_attribute3 IN VARCHAR2
75 , p_attribute4 IN VARCHAR2
76 , p_attribute5 IN VARCHAR2
77 , p_attribute6 IN VARCHAR2
78 , p_attribute7 IN VARCHAR2
79 , p_attribute8 IN VARCHAR2
80 , p_attribute9 IN VARCHAR2
81 , p_context IN VARCHAR2
82 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_conversion_date OUT NOCOPY /* file.sql.39 change */ DATE
99 , x_conversion_date_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 -- , x_conversion_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 , x_conversion_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , x_currency_detail_id OUT NOCOPY /* file.sql.39 change */ NUMBER
103 , x_currency_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
104 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
105 , x_fixed_value OUT NOCOPY /* file.sql.39 change */ NUMBER
106 , x_markup_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
107 , x_markup_operator OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_markup_value OUT NOCOPY /* file.sql.39 change */ NUMBER
109 , x_price_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
110 , x_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
111 , x_selling_rounding_factor OUT NOCOPY /* file.sql.39 change */ NUMBER
112 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
113 , x_to_currency_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_currency_detail OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_currency_header OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_markup_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_price_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_to_currency OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 , x_curr_attribute_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , x_curr_attribute_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 , x_curr_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 , x_curr_attribute_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , x_precedence OUT NOCOPY /* file.sql.39 change */ NUMBER
124 );
125
126 -- Procedure Validate_And_Write
127 --
128
129 PROCEDURE Validate_And_Write
130 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
132 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , p_currency_detail_id IN NUMBER
134 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
135 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
137 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
138 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
139 );
140
141 -- Procedure Delete_Row
142 --
143
144 PROCEDURE Delete_Row
145 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
147 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , p_currency_detail_id IN NUMBER
149 );
150
151 -- Procedure Process_Entity
152 --
153
154 PROCEDURE Process_Entity
155 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
157 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158 );
159
160 -- Procedure lock_Row
161 --
162
163 PROCEDURE Lock_Row
164 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
165 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
166 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , p_attribute1 IN VARCHAR2
168 , p_attribute10 IN VARCHAR2
169 , p_attribute11 IN VARCHAR2
170 , p_attribute12 IN VARCHAR2
171 , p_attribute13 IN VARCHAR2
172 , p_attribute14 IN VARCHAR2
173 , p_attribute15 IN VARCHAR2
174 , p_attribute2 IN VARCHAR2
175 , p_attribute3 IN VARCHAR2
176 , p_attribute4 IN VARCHAR2
177 , p_attribute5 IN VARCHAR2
178 , p_attribute6 IN VARCHAR2
179 , p_attribute7 IN VARCHAR2
180 , p_attribute8 IN VARCHAR2
181 , p_attribute9 IN VARCHAR2
182 , p_context IN VARCHAR2
183 , p_conversion_date IN DATE
184 , p_conversion_date_type IN VARCHAR2
185 -- , p_conversion_method IN VARCHAR2
186 , p_conversion_type IN VARCHAR2
187 , p_created_by IN NUMBER
188 , p_creation_date IN DATE
189 , p_currency_detail_id IN NUMBER
190 , p_currency_header_id IN NUMBER
191 , p_end_date_active IN DATE
192 , p_fixed_value IN NUMBER
193 , p_last_updated_by IN NUMBER
194 , p_last_update_date IN DATE
195 , p_last_update_login IN NUMBER
196 , p_markup_formula_id IN NUMBER
197 , p_markup_operator IN VARCHAR2
198 , p_markup_value IN NUMBER
199 , p_price_formula_id IN NUMBER
200 , p_program_application_id IN NUMBER
201 , p_program_id IN NUMBER
202 , p_program_update_date IN DATE
203 , p_request_id IN NUMBER
204 , p_rounding_factor IN NUMBER
205 , p_selling_rounding_factor IN NUMBER
206 , p_start_date_active IN DATE
207 , p_to_currency_code IN VARCHAR2
208 , p_curr_attribute_type IN VARCHAR2
209 , p_curr_attribute_context IN VARCHAR2
210 , p_curr_attribute IN VARCHAR2
211 , p_curr_attribute_value IN VARCHAR2
212 , p_precedence IN NUMBER
213 );
214
215 END QP_QP_Form_Curr_Details;