[Home] [Help]
PACKAGE: APPS.QP_QP_FORM_FORMULA_LINES
Source
1 PACKAGE QP_QP_Form_Formula_Lines AUTHID CURRENT_USER AS
2 /* $Header: QPXFPFLS.pls 120.1 2005/06/13 04:04:04 appldev $ */
3
4
5 -- Procedure : Create_Factor_List
6 --
7
8 PROCEDURE Create_Factor_List
9 ( p_name IN VARCHAR2
10 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
12 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_list_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
30 , x_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 );
32
33 -- Procedure : Default_Attributes
34 --
35
36 PROCEDURE Default_Attributes
37 ( p_price_formula_id IN NUMBER
38 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
40 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
58 , x_numeric_constant OUT NOCOPY /* file.sql.39 change */ NUMBER
59 , x_price_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
60 , x_price_formula_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
61 , x_formula_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_price_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
63 , x_price_modifier_list_id OUT NOCOPY /* file.sql.39 change */ NUMBER
64 , x_pricing_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_pricing_attribute_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
67 , x_step_number OUT NOCOPY /* file.sql.39 change */ NUMBER
68 , x_price_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 , x_price_formula_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
70 , x_price_formula_line_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 , x_price_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 , x_price_modifier_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 );
75
76 -- Procedure : Change_Attribute
77 --
78
79 PROCEDURE Change_Attribute
80 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
82 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 , p_price_formula_line_id IN NUMBER
84 , p_attr_id IN NUMBER
85 , p_attr_value IN VARCHAR2
86 , p_attribute1 IN VARCHAR2
87 , p_attribute10 IN VARCHAR2
88 , p_attribute11 IN VARCHAR2
89 , p_attribute12 IN VARCHAR2
90 , p_attribute13 IN VARCHAR2
91 , p_attribute14 IN VARCHAR2
92 , p_attribute15 IN VARCHAR2
93 , p_attribute2 IN VARCHAR2
94 , p_attribute3 IN VARCHAR2
95 , p_attribute4 IN VARCHAR2
96 , p_attribute5 IN VARCHAR2
97 , p_attribute6 IN VARCHAR2
98 , p_attribute7 IN VARCHAR2
99 , p_attribute8 IN VARCHAR2
100 , p_attribute9 IN VARCHAR2
101 , p_context IN VARCHAR2
102 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
119 , x_numeric_constant OUT NOCOPY /* file.sql.39 change */ NUMBER
120 , x_price_formula_id OUT NOCOPY /* file.sql.39 change */ NUMBER
121 , x_price_formula_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
122 , x_formula_line_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
123 , x_price_list_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER
124 , x_price_modifier_list_id OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_pricing_attribute OUT NOCOPY /* file.sql.39 change */ VARCHAR2
126 , x_pricing_attribute_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
128 , x_step_number OUT NOCOPY /* file.sql.39 change */ NUMBER
129 , x_price_formula OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_price_formula_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 , x_price_formula_line_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , x_price_list_line OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , x_price_modifier_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
134 , x_reqd_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 );
136
137 -- Procedure Validate_And_Write
138 --
139
140 PROCEDURE Validate_And_Write
141 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
143 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , p_price_formula_line_id IN NUMBER
145 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
146 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
147 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
148 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
149 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
150 );
151
152 -- Procedure Delete_Row
153 --
154
155 PROCEDURE Delete_Row
156 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
158 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
159 , p_price_formula_line_id IN NUMBER
160 );
161
162 -- Procedure Process_Entity
163 --
164
165 PROCEDURE Process_Entity
166 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
168 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169 );
170
171 -- Procedure lock_Row
172 --
173
174 PROCEDURE Lock_Row
175 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
176 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
177 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
178 , p_attribute1 IN VARCHAR2
179 , p_attribute10 IN VARCHAR2
180 , p_attribute11 IN VARCHAR2
181 , p_attribute12 IN VARCHAR2
182 , p_attribute13 IN VARCHAR2
183 , p_attribute14 IN VARCHAR2
184 , p_attribute15 IN VARCHAR2
185 , p_attribute2 IN VARCHAR2
186 , p_attribute3 IN VARCHAR2
187 , p_attribute4 IN VARCHAR2
188 , p_attribute5 IN VARCHAR2
189 , p_attribute6 IN VARCHAR2
190 , p_attribute7 IN VARCHAR2
191 , p_attribute8 IN VARCHAR2
192 , p_attribute9 IN VARCHAR2
193 , p_context IN VARCHAR2
194 , p_created_by IN NUMBER
195 , p_creation_date IN DATE
196 , p_end_date_active IN DATE
197 , p_last_updated_by IN NUMBER
198 , p_last_update_date IN DATE
199 , p_last_update_login IN NUMBER
200 , p_numeric_constant IN NUMBER
201 , p_price_formula_id IN NUMBER
202 , p_price_formula_line_id IN NUMBER
203 , p_formula_line_type_code IN VARCHAR2
204 , p_price_list_line_id IN NUMBER
205 , p_price_modifier_list_id IN NUMBER
206 , p_pricing_attribute IN VARCHAR2
207 , p_pricing_attribute_context IN VARCHAR2
208 , p_start_date_active IN DATE
209 , p_step_number IN NUMBER
210 , p_reqd_flag IN VARCHAR2
211 );
212
213 END QP_QP_Form_Formula_Lines;