DBA Data[Home] [Help]

PACKAGE: APPS.OE_OE_FORM_PRICE_BREAK

Source


1 PACKAGE OE_OE_Form_Price_Break AS
2 /* $Header: OEXFDPBS.pls 120.1 2005/06/08 04:06:12 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 ,   x_amount                        OUT NOCOPY /* file.sql.39 change */ NUMBER
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_discount_line_id              OUT NOCOPY /* file.sql.39 change */ NUMBER
29 ,   x_end_date_active               OUT NOCOPY /* file.sql.39 change */ DATE
30 ,   x_method_type_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 ,   x_percent                       OUT NOCOPY /* file.sql.39 change */ NUMBER
32 ,   x_price                         OUT NOCOPY /* file.sql.39 change */ NUMBER
33 ,   x_price_break_high              OUT NOCOPY /* file.sql.39 change */ NUMBER
34 ,   x_price_break_low               OUT NOCOPY /* file.sql.39 change */ NUMBER
35 ,   x_start_date_active             OUT NOCOPY /* file.sql.39 change */ DATE
36 ,   x_unit_code                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ,   x_discount_line                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
38 ,   x_method_type                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 ,   x_unit                          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 );
41 
42 --  Procedure   :   Change_Attribute
43 --
44 
45 PROCEDURE Change_Attribute
46 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
47 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
48 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 ,   p_discount_line_id              IN  NUMBER
50 ,   p_method_type_code              IN  VARCHAR2
51 ,   p_price_break_high              IN  NUMBER
52 ,   p_price_break_low               IN  NUMBER
53 ,   p_attr_id                       IN  NUMBER
54 ,   p_attr_value                    IN  VARCHAR2
55 ,   p_attribute1                    IN  VARCHAR2
56 ,   p_attribute10                   IN  VARCHAR2
57 ,   p_attribute11                   IN  VARCHAR2
58 ,   p_attribute12                   IN  VARCHAR2
59 ,   p_attribute13                   IN  VARCHAR2
60 ,   p_attribute14                   IN  VARCHAR2
61 ,   p_attribute15                   IN  VARCHAR2
62 ,   p_attribute2                    IN  VARCHAR2
63 ,   p_attribute3                    IN  VARCHAR2
64 ,   p_attribute4                    IN  VARCHAR2
65 ,   p_attribute5                    IN  VARCHAR2
66 ,   p_attribute6                    IN  VARCHAR2
67 ,   p_attribute7                    IN  VARCHAR2
68 ,   p_attribute8                    IN  VARCHAR2
69 ,   p_attribute9                    IN  VARCHAR2
70 ,   p_context                       IN  VARCHAR2
71 ,   x_amount                        OUT NOCOPY /* file.sql.39 change */ NUMBER
72 ,   x_attribute1                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 ,   x_attribute10                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 ,   x_attribute11                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 ,   x_attribute12                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 ,   x_attribute13                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 ,   x_attribute14                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 ,   x_attribute15                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 ,   x_attribute2                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 ,   x_attribute3                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 ,   x_attribute4                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 ,   x_attribute5                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 ,   x_attribute6                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 ,   x_attribute7                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,   x_attribute8                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 ,   x_attribute9                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 ,   x_discount_line_id              OUT NOCOPY /* file.sql.39 change */ NUMBER
89 ,   x_end_date_active               OUT NOCOPY /* file.sql.39 change */ DATE
90 ,   x_method_type_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 ,   x_percent                       OUT NOCOPY /* file.sql.39 change */ NUMBER
92 ,   x_price                         OUT NOCOPY /* file.sql.39 change */ NUMBER
93 ,   x_price_break_high              OUT NOCOPY /* file.sql.39 change */ NUMBER
94 ,   x_price_break_low               OUT NOCOPY /* file.sql.39 change */ NUMBER
95 ,   x_start_date_active             OUT NOCOPY /* file.sql.39 change */ DATE
96 ,   x_unit_code                     OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 ,   x_discount_line                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 ,   x_method_type                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 ,   x_unit                          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 );
101 
102 --  Procedure       Validate_And_Write
103 --
104 
105 PROCEDURE Validate_And_Write
106 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
108 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 ,   p_price_list_line_id              IN  NUMBER
110 ,	p_price_list_id			IN NUMBER
111 ,   p_method_type_code              IN  VARCHAR2
112 ,   p_price_break_high              IN  NUMBER
113 ,   p_price_break_low               IN  NUMBER
114 ,   p_list_price			 	  IN NUMBER
115 ,   x_creation_date                 OUT NOCOPY /* file.sql.39 change */ DATE
116 ,   x_created_by                    OUT NOCOPY /* file.sql.39 change */ NUMBER
117 ,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
118 ,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
119 ,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
120 );
121 
122 --  Procedure       Delete_Row
123 --
124 
125 PROCEDURE Delete_Row
126 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
128 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 ,   p_discount_line_id              IN  NUMBER
130 ,   p_method_type_code              IN  VARCHAR2
131 ,   p_price_break_high              IN  NUMBER
132 ,   p_price_break_low               IN  NUMBER
133 );
134 
135 --  Procedure       Process_Entity
136 --
137 
138 PROCEDURE Process_Entity
139 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
141 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 );
143 
144 --  Procedure       lock_Row
145 --
146 
147 PROCEDURE Lock_Row
148 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
150 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 ,   p_amount                        IN  NUMBER
152 ,   p_attribute1                    IN  VARCHAR2
153 ,   p_attribute10                   IN  VARCHAR2
154 ,   p_attribute11                   IN  VARCHAR2
155 ,   p_attribute12                   IN  VARCHAR2
156 ,   p_attribute13                   IN  VARCHAR2
157 ,   p_attribute14                   IN  VARCHAR2
158 ,   p_attribute15                   IN  VARCHAR2
159 ,   p_attribute2                    IN  VARCHAR2
160 ,   p_attribute3                    IN  VARCHAR2
161 ,   p_attribute4                    IN  VARCHAR2
162 ,   p_attribute5                    IN  VARCHAR2
163 ,   p_attribute6                    IN  VARCHAR2
164 ,   p_attribute7                    IN  VARCHAR2
165 ,   p_attribute8                    IN  VARCHAR2
166 ,   p_attribute9                    IN  VARCHAR2
167 ,   p_context                       IN  VARCHAR2
168 ,   p_created_by                    IN  NUMBER
169 ,   p_creation_date                 IN  DATE
170 ,   p_discount_line_id              IN  NUMBER
171 ,   p_end_date_active               IN  DATE
172 ,   p_last_updated_by               IN  NUMBER
173 ,   p_last_update_date              IN  DATE
174 ,   p_last_update_login             IN  NUMBER
175 ,   p_method_type_code              IN  VARCHAR2
176 ,   p_percent                       IN  NUMBER
177 ,   p_price                         IN  NUMBER
178 ,   p_price_break_high              IN  NUMBER
179 ,   p_price_break_low               IN  NUMBER
180 ,   p_program_application_id        IN  NUMBER
181 ,   p_program_id                    IN  NUMBER
182 ,   p_program_update_date           IN  DATE
183 ,   p_request_id                    IN  NUMBER
184 ,   p_start_date_active             IN  DATE
185 ,   p_unit_code                     IN  VARCHAR2
186 );
187 
188 END OE_OE_Form_Price_Break;