DBA Data[Home] [Help]

PACKAGE: APPS.OE_OE_FORM_PRICE_LHEADER

Source


1 PACKAGE OE_OE_Form_Price_Lheader AS
2 /* $Header: OEXFPLHS.pls 120.1 2005/06/08 23:09:07 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_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_comments                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 ,   x_currency_code                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 ,   x_description                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 ,   x_end_date_active               OUT NOCOPY /* file.sql.39 change */ DATE
31 ,   x_freight_terms_code            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 ,   x_name                          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 ,   x_price_list_id                 OUT NOCOPY /* file.sql.39 change */ NUMBER
34 ,   x_rounding_factor               OUT NOCOPY /* file.sql.39 change */ NUMBER
35 ,   x_secondary_price_list_id       OUT NOCOPY /* file.sql.39 change */ NUMBER
36 ,   x_ship_method_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ,   x_start_date_active             OUT NOCOPY /* file.sql.39 change */ DATE
38 ,   x_terms_id                      OUT NOCOPY /* file.sql.39 change */ NUMBER
39 ,   x_currency                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 ,   x_freight_terms                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 ,   x_price_list                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42 ,   x_secondary_price_list          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 ,   x_ship_method                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 ,   x_terms                         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
45 );
46 
47 --  Procedure   :   Change_Attribute
48 --
49 
50 PROCEDURE Change_Attribute
51 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
53 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 ,   p_price_list_id                 IN  NUMBER
55 ,   p_attr_id                       IN  NUMBER
56 ,   p_attr_value                    IN  VARCHAR2
57 ,   p_attribute1                    IN  VARCHAR2
58 ,   p_attribute10                   IN  VARCHAR2
59 ,   p_attribute11                   IN  VARCHAR2
60 ,   p_attribute12                   IN  VARCHAR2
61 ,   p_attribute13                   IN  VARCHAR2
62 ,   p_attribute14                   IN  VARCHAR2
63 ,   p_attribute15                   IN  VARCHAR2
64 ,   p_attribute2                    IN  VARCHAR2
65 ,   p_attribute3                    IN  VARCHAR2
66 ,   p_attribute4                    IN  VARCHAR2
67 ,   p_attribute5                    IN  VARCHAR2
68 ,   p_attribute6                    IN  VARCHAR2
69 ,   p_attribute7                    IN  VARCHAR2
70 ,   p_attribute8                    IN  VARCHAR2
71 ,   p_attribute9                    IN  VARCHAR2
72 ,   p_context                       IN  VARCHAR2
73 ,   x_attribute1                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 ,   x_attribute10                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 ,   x_attribute11                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
76 ,   x_attribute12                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 ,   x_attribute13                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
78 ,   x_attribute14                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 ,   x_attribute15                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 ,   x_attribute2                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 ,   x_attribute3                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
82 ,   x_attribute4                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
83 ,   x_attribute5                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
84 ,   x_attribute6                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85 ,   x_attribute7                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
86 ,   x_attribute8                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
87 ,   x_attribute9                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
88 ,   x_comments                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
89 ,   x_context                       OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90 ,   x_currency_code                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91 ,   x_description                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92 ,   x_end_date_active               OUT NOCOPY /* file.sql.39 change */ DATE
93 ,   x_freight_terms_code            OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 ,   x_name                          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ,   x_price_list_id                 OUT NOCOPY /* file.sql.39 change */ NUMBER
96 ,   x_rounding_factor               OUT NOCOPY /* file.sql.39 change */ NUMBER
97 ,   x_secondary_price_list_id       OUT NOCOPY /* file.sql.39 change */ NUMBER
98 ,   x_ship_method_code              OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 ,   x_start_date_active             OUT NOCOPY /* file.sql.39 change */ DATE
100 ,   x_terms_id                      OUT NOCOPY /* file.sql.39 change */ NUMBER
101 ,   x_currency                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 ,   x_freight_terms                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
103 ,   x_price_list                    OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 ,   x_secondary_price_list          OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 ,   x_ship_method                   OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 ,   x_terms                         OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 );
108 
109 --  Procedure       Validate_And_Write
110 --
111 
112 PROCEDURE Validate_And_Write
113 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
115 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 ,   p_price_list_id                 IN  NUMBER
117 ,   x_creation_date                 OUT NOCOPY /* file.sql.39 change */ DATE
118 ,   x_created_by                    OUT NOCOPY /* file.sql.39 change */ NUMBER
119 ,   x_last_update_date              OUT NOCOPY /* file.sql.39 change */ DATE
120 ,   x_last_updated_by               OUT NOCOPY /* file.sql.39 change */ NUMBER
121 ,   x_last_update_login             OUT NOCOPY /* file.sql.39 change */ NUMBER
122 );
123 
124 --  Procedure       Delete_Row
125 --
126 
127 PROCEDURE Delete_Row
128 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
130 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
131 ,   p_price_list_id                 IN  NUMBER
132 );
133 
134 --  Procedure       Process_Entity
135 --
136 
137 PROCEDURE Process_Entity
138 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
140 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 );
142 
143 --  Procedure       lock_Row
144 --
145 
146 PROCEDURE Lock_Row
147 (   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 ,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
149 ,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 ,   p_attribute1                    IN  VARCHAR2
151 ,   p_attribute10                   IN  VARCHAR2
152 ,   p_attribute11                   IN  VARCHAR2
153 ,   p_attribute12                   IN  VARCHAR2
154 ,   p_attribute13                   IN  VARCHAR2
155 ,   p_attribute14                   IN  VARCHAR2
156 ,   p_attribute15                   IN  VARCHAR2
157 ,   p_attribute2                    IN  VARCHAR2
158 ,   p_attribute3                    IN  VARCHAR2
159 ,   p_attribute4                    IN  VARCHAR2
160 ,   p_attribute5                    IN  VARCHAR2
161 ,   p_attribute6                    IN  VARCHAR2
162 ,   p_attribute7                    IN  VARCHAR2
163 ,   p_attribute8                    IN  VARCHAR2
164 ,   p_attribute9                    IN  VARCHAR2
165 ,   p_comments                      IN  VARCHAR2
166 ,   p_context                       IN  VARCHAR2
167 ,   p_created_by                    IN  NUMBER
168 ,   p_creation_date                 IN  DATE
169 ,   p_currency_code                 IN  VARCHAR2
170 ,   p_description                   IN  VARCHAR2
171 ,   p_end_date_active               IN  DATE
172 ,   p_freight_terms_code            IN  VARCHAR2
173 ,   p_last_updated_by               IN  NUMBER
174 ,   p_last_update_date              IN  DATE
175 ,   p_last_update_login             IN  NUMBER
176 ,   p_name                          IN  VARCHAR2
177 ,   p_price_list_id                 IN  NUMBER
178 ,   p_program_application_id        IN  NUMBER
179 ,   p_program_id                    IN  NUMBER
180 ,   p_program_update_date           IN  DATE
181 ,   p_request_id                    IN  NUMBER
182 ,   p_rounding_factor               IN  NUMBER
183 ,   p_secondary_price_list_id       IN  NUMBER
184 ,   p_ship_method_code              IN  VARCHAR2
185 ,   p_start_date_active             IN  DATE
186 ,   p_terms_id                      IN  NUMBER
187 ,   p_currency_header_id            IN  NUMBER -- Multi-Currency SunilPandey
188 );
189 
190 END OE_OE_Form_Price_Lheader;