[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;