DBA Data[Home] [Help]

PACKAGE: APPS.OE_OE_FORM_LINE_SCREDIT

Source


1 PACKAGE OE_OE_Form_Line_Scredit AUTHID CURRENT_USER AS
2 /* $Header: OEXFLSCS.pls 120.0 2005/05/31 22:51:20 appldev noship $ */
3 
4 --  Procedure : Default_Attributes
5 --
6 
7 PROCEDURE Default_Attributes
8 ( x_return_status OUT NOCOPY VARCHAR2
9 
10 , x_msg_count OUT NOCOPY NUMBER
11 
12 , x_msg_data OUT NOCOPY VARCHAR2
13 
14 ,   p_line_id                       IN  NUMBER
15 , x_attribute1 OUT NOCOPY VARCHAR2
16 
17 , x_attribute10 OUT NOCOPY VARCHAR2
18 
19 , x_attribute11 OUT NOCOPY VARCHAR2
20 
21 , x_attribute12 OUT NOCOPY VARCHAR2
22 
23 , x_attribute13 OUT NOCOPY VARCHAR2
24 
25 , x_attribute14 OUT NOCOPY VARCHAR2
26 
27 , x_attribute15 OUT NOCOPY VARCHAR2
28 
29 , x_attribute2 OUT NOCOPY VARCHAR2
30 
31 , x_attribute3 OUT NOCOPY VARCHAR2
32 
33 , x_attribute4 OUT NOCOPY VARCHAR2
34 
35 , x_attribute5 OUT NOCOPY VARCHAR2
36 
37 , x_attribute6 OUT NOCOPY VARCHAR2
38 
39 , x_attribute7 OUT NOCOPY VARCHAR2
40 
41 , x_attribute8 OUT NOCOPY VARCHAR2
42 
43 , x_attribute9 OUT NOCOPY VARCHAR2
44 
45 , x_context OUT NOCOPY VARCHAR2
46 
47 , x_dw_update_advice_flag OUT NOCOPY VARCHAR2
48 
49 , x_header_id OUT NOCOPY NUMBER
50 
51 , x_line_id OUT NOCOPY NUMBER
52 
53 , x_percent OUT NOCOPY NUMBER
54 
55 , x_salesrep_id OUT NOCOPY NUMBER
56 
57 , x_sales_credit_type_id OUT NOCOPY NUMBER
58 
59 , x_sales_credit_id OUT NOCOPY NUMBER
60 
61 , x_wh_update_date OUT NOCOPY DATE
62 
63 , x_salesrep OUT NOCOPY VARCHAR2
64 
65 , x_sales_credit_type OUT NOCOPY VARCHAR2
66 --SG {
67 ,   x_sales_group_id                OUT NOCOPY /* file.sql.39 change */ NUMBER
68 ,   x_sales_group_updated_flag           OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 --SG}
70 
71 );
72 
73 --  Procedure   :   Change_Attribute
74 --
75 
76 PROCEDURE Change_Attribute
77 ( x_return_status OUT NOCOPY VARCHAR2
78 
79 , x_msg_count OUT NOCOPY NUMBER
80 
81 , x_msg_data OUT NOCOPY VARCHAR2
82 
83 ,   p_sales_credit_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 --SG{
103 ,   p_sales_group_id                IN  NUMBER
104 ,   p_sales_group_updated_flag           IN  VARCHAR2
105 --SG}
106 , x_attribute1 OUT NOCOPY VARCHAR2
107 
108 , x_attribute10 OUT NOCOPY VARCHAR2
109 
110 , x_attribute11 OUT NOCOPY VARCHAR2
111 
112 , x_attribute12 OUT NOCOPY VARCHAR2
113 
114 , x_attribute13 OUT NOCOPY VARCHAR2
115 
116 , x_attribute14 OUT NOCOPY VARCHAR2
117 
118 , x_attribute15 OUT NOCOPY VARCHAR2
119 
120 , x_attribute2 OUT NOCOPY VARCHAR2
121 
122 , x_attribute3 OUT NOCOPY VARCHAR2
123 
124 , x_attribute4 OUT NOCOPY VARCHAR2
125 
126 , x_attribute5 OUT NOCOPY VARCHAR2
127 
128 , x_attribute6 OUT NOCOPY VARCHAR2
129 
130 , x_attribute7 OUT NOCOPY VARCHAR2
131 
132 , x_attribute8 OUT NOCOPY VARCHAR2
133 
134 , x_attribute9 OUT NOCOPY VARCHAR2
135 
136 , x_context OUT NOCOPY VARCHAR2
137 
138 , x_dw_update_advice_flag OUT NOCOPY VARCHAR2
139 
140 , x_header_id OUT NOCOPY NUMBER
141 
142 , x_line_id OUT NOCOPY NUMBER
143 
144 , x_percent OUT NOCOPY NUMBER
145 
146 , x_salesrep_id OUT NOCOPY NUMBER
147 
148 , x_sales_credit_type_id OUT NOCOPY NUMBER
149 
150 , x_sales_credit_id OUT NOCOPY NUMBER
151 
152 , x_wh_update_date OUT NOCOPY DATE
153 
154 , x_salesrep OUT NOCOPY VARCHAR2
155 
156 , x_sales_credit_type OUT NOCOPY VARCHAR2
157 --SG{
158 ,   x_sales_group         OUT NOCOPY  VARCHAR2
159 ,   x_sales_group_id      OUT NOCOPY  NUMBER
160 ,   x_sales_group_updated_flag OUT NOCOPY  VARCHAR2
161 --SG}
162 
163 );
164 
165 --  Procedure       Validate_And_Write
166 --
167 
168 PROCEDURE Validate_And_Write
169 ( x_return_status OUT NOCOPY VARCHAR2
170 
171 , x_msg_count OUT NOCOPY NUMBER
172 
173 , x_msg_data OUT NOCOPY VARCHAR2
174 
175 ,   p_sales_credit_id               IN  NUMBER
176 ,   p_change_reason_code            IN  VARCHAR2
177 ,   p_change_comments               IN  VARCHAR2
178 , x_creation_date OUT NOCOPY DATE
179 
180 , x_created_by OUT NOCOPY NUMBER
181 
182 , x_last_update_date OUT NOCOPY DATE
183 
184 , x_last_updated_by OUT NOCOPY NUMBER
185 
186 , x_last_update_login OUT NOCOPY NUMBER
187 
188 , x_lock_control OUT NOCOPY NUMBER);
189 
190 
191 --  Procedure       Delete_Row
192 --
193 
194 PROCEDURE Delete_Row
195 ( x_return_status OUT NOCOPY VARCHAR2
196 
197 , x_msg_count OUT NOCOPY NUMBER
198 
199 , x_msg_data OUT NOCOPY VARCHAR2
200 
201 ,   p_sales_credit_id               IN  NUMBER
202 , p_change_reason_code            IN  VARCHAR2 Default Null
203 , p_change_comments               IN  VARCHAR2 Default Null
204 );
205 
206 --  Procedure       Process_Entity
207 --
208 
209 PROCEDURE Process_Entity
210 ( x_return_status OUT NOCOPY VARCHAR2
211 
212 , x_msg_count OUT NOCOPY NUMBER
213 
214 , x_msg_data OUT NOCOPY VARCHAR2
215 
216 );
217 
218 --  Procedure       lock_Row
219 --
220 
221 
222 PROCEDURE Lock_Row
223 ( x_return_status OUT NOCOPY VARCHAR2
224 
225 , x_msg_count OUT NOCOPY NUMBER
226 
227 , x_msg_data OUT NOCOPY VARCHAR2
228 
229 ,   p_sales_credit_id               IN  NUMBER
230 ,   p_lock_control                  IN  NUMBER
231 );
232 
233 END OE_OE_Form_Line_Scredit;