[Home] [Help]
PACKAGE: APPS.OE_OE_FORM_AGREEMENT
Source
1 PACKAGE OE_OE_Form_Agreement AS
2 /* $Header: OEXFAGRS.pls 120.2 2005/12/14 16:10:21 shulin noship $ */
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_accounting_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
12 , x_agreement_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
13 , x_agreement_id OUT NOCOPY /* file.sql.39 change */ NUMBER
14 , x_agreement_num OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_agreement_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
16 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
18 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
20 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
21 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
23 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
26 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
29 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
31 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
32 , x_sold_to_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
33 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
34 , x_freight_terms_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 , x_invoice_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
36 , x_invoice_to_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
37 , x_invoicing_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
38 , x_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39 , x_override_arule_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
40 , x_override_irule_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 , x_price_list_id OUT NOCOPY /* file.sql.39 change */ NUMBER
42 , x_purchase_order_num OUT NOCOPY /* file.sql.39 change */ VARCHAR2
43 , x_revision OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44 , x_revision_date OUT NOCOPY /* file.sql.39 change */ DATE
45 , x_revision_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , x_salesrep_id OUT NOCOPY /* file.sql.39 change */ NUMBER
47 , x_ship_method_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 , x_signature_date OUT NOCOPY /* file.sql.39 change */ DATE
49 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
50 , x_term_id OUT NOCOPY /* file.sql.39 change */ NUMBER
51 , x_accounting_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
52 , x_agreement_contact OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53 , x_agreement OUT NOCOPY /* file.sql.39 change */ VARCHAR2
54 , x_agreement_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
55 , x_customer OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56 , x_freight_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 , x_invoice_contact OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , x_invoice_to_site_use OUT NOCOPY /* file.sql.39 change */ VARCHAR2
59 , x_invoicing_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , x_override_arule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61 , x_override_irule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62 , x_price_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 , x_salesrep OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65 , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 , x_term OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 , x_agreement_source_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
68 --added by rchellam for OKC
69 , x_orig_system_agr_id OUT NOCOPY /* file.sql.39 change */ NUMBER --added by rchellam for OKC
70 , x_agreement_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --added by rchellam for OKC
71 , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
72 );
73
74 -- Procedure : Change_Attribute
75 --
76
77 PROCEDURE Change_Attribute
78 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
80 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
81 , p_agreement_id IN NUMBER
82 , p_attr_id IN NUMBER
83 , p_attr_value IN VARCHAR2
84 , p_attribute1 IN VARCHAR2
85 , p_attribute10 IN VARCHAR2
86 , p_attribute11 IN VARCHAR2
87 , p_attribute12 IN VARCHAR2
88 , p_attribute13 IN VARCHAR2
89 , p_attribute14 IN VARCHAR2
90 , p_attribute15 IN VARCHAR2
91 , p_attribute2 IN VARCHAR2
92 , p_attribute3 IN VARCHAR2
93 , p_attribute4 IN VARCHAR2
94 , p_attribute5 IN VARCHAR2
95 , p_attribute6 IN VARCHAR2
96 , p_attribute7 IN VARCHAR2
97 , p_attribute8 IN VARCHAR2
98 , p_attribute9 IN VARCHAR2
99 , p_context IN VARCHAR2
100 , x_accounting_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
101 , x_agreement_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
102 , x_agreement_id OUT NOCOPY /* file.sql.39 change */ NUMBER
103 , x_agreement_num OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104 , x_agreement_type_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
105 , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106 , x_attribute10 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
107 , x_attribute11 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 , x_attribute12 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
109 , x_attribute13 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
110 , x_attribute14 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111 , x_attribute15 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112 , x_attribute2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113 , x_attribute3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 , x_attribute4 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 , x_attribute5 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
116 , x_attribute6 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
117 , x_attribute7 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 , x_attribute8 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 , x_attribute9 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 , x_context OUT NOCOPY /* file.sql.39 change */ VARCHAR2
121 , x_sold_to_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
122 , x_end_date_active OUT NOCOPY /* file.sql.39 change */ DATE
123 , x_freight_terms_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124 , x_invoice_contact_id OUT NOCOPY /* file.sql.39 change */ NUMBER
125 , x_invoice_to_org_id OUT NOCOPY /* file.sql.39 change */ NUMBER
126 , x_invoicing_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
127 , x_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128 , x_override_arule_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
129 , x_override_irule_flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130 , x_price_list_id OUT NOCOPY /* file.sql.39 change */ NUMBER
131 , x_purchase_order_num OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 , x_revision OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 , x_revision_date OUT NOCOPY /* file.sql.39 change */ DATE
134 , x_revision_reason_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
135 , x_salesrep_id OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_ship_method_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
137 , x_signature_date OUT NOCOPY /* file.sql.39 change */ DATE
138 , x_start_date_active OUT NOCOPY /* file.sql.39 change */ DATE
139 , x_term_id OUT NOCOPY /* file.sql.39 change */ NUMBER
140 , x_accounting_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141 , x_agreement_contact OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142 , x_agreement OUT NOCOPY /* file.sql.39 change */ VARCHAR2
143 , x_agreement_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 , x_customer OUT NOCOPY /* file.sql.39 change */ VARCHAR2
145 , x_freight_terms OUT NOCOPY /* file.sql.39 change */ VARCHAR2
146 , x_invoice_contact OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147 , x_invoice_to_site_use OUT NOCOPY /* file.sql.39 change */ VARCHAR2
148 , x_invoicing_rule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
149 , x_override_arule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
150 , x_override_irule OUT NOCOPY /* file.sql.39 change */ VARCHAR2
151 , x_price_list OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 , x_revision_reason OUT NOCOPY /* file.sql.39 change */ VARCHAR2
153 , x_salesrep OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154 , x_ship_method OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155 , x_term OUT NOCOPY /* file.sql.39 change */ VARCHAR2
156 , x_agreement_source_code OUT NOCOPY /* file.sql.39 change */ VARCHAR2
157 --added by rchellam for OKC
158 , x_orig_system_agr_id OUT NOCOPY /* file.sql.39 change */ NUMBER --added by rchellam for OKC
159 , x_agreement_source OUT NOCOPY /* file.sql.39 change */ VARCHAR2 --added by rchellam for OKC
160 , x_invoice_to_customer_id OUT NOCOPY NUMBER -- Added for bug#4029589
161 );
162
163 -- Procedure Validate_And_Write
164 --
165
166 PROCEDURE Validate_And_Write
167 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
169 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170 , p_agreement_id IN NUMBER
171 , x_creation_date OUT NOCOPY /* file.sql.39 change */ DATE
172 , x_created_by OUT NOCOPY /* file.sql.39 change */ NUMBER
173 , x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
174 , x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
175 , x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
176 );
177
178 -- Procedure Delete_Row
179 --
180
181 PROCEDURE Delete_Row
182 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
183 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
184 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
185 , p_agreement_id IN NUMBER
186 );
187
188 -- Procedure Process_Entity
189 --
190
191 PROCEDURE Process_Entity
192 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
193 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
194 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
195 );
196
197 -- Procedure lock_Row
198 --
199
200 PROCEDURE Lock_Row
201 ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
202 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
203 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
204 , p_accounting_rule_id IN NUMBER
205 , p_agreement_contact_id IN NUMBER
206 , p_agreement_id IN NUMBER
207 , p_agreement_num IN VARCHAR2
208 , p_agreement_type_code IN VARCHAR2
209 , p_attribute1 IN VARCHAR2
210 , p_attribute10 IN VARCHAR2
211 , p_attribute11 IN VARCHAR2
212 , p_attribute12 IN VARCHAR2
213 , p_attribute13 IN VARCHAR2
214 , p_attribute14 IN VARCHAR2
215 , p_attribute15 IN VARCHAR2
216 , p_attribute2 IN VARCHAR2
217 , p_attribute3 IN VARCHAR2
218 , p_attribute4 IN VARCHAR2
219 , p_attribute5 IN VARCHAR2
220 , p_attribute6 IN VARCHAR2
221 , p_attribute7 IN VARCHAR2
222 , p_attribute8 IN VARCHAR2
223 , p_attribute9 IN VARCHAR2
224 , p_context IN VARCHAR2
225 , p_created_by IN NUMBER
226 , p_creation_date IN DATE
227 , p_sold_to_org_id IN NUMBER
228 , p_end_date_active IN DATE
229 , p_freight_terms_code IN VARCHAR2
230 , p_invoice_contact_id IN NUMBER
231 , p_invoice_to_org_id IN NUMBER
232 , p_invoicing_rule_id IN NUMBER
233 , p_last_updated_by IN NUMBER
234 , p_last_update_date IN DATE
235 , p_last_update_login IN NUMBER
236 , p_name IN VARCHAR2
237 , p_override_arule_flag IN VARCHAR2
238 , p_override_irule_flag IN VARCHAR2
239 , p_price_list_id IN NUMBER
240 , p_purchase_order_num IN VARCHAR2
241 , p_revision IN VARCHAR2
242 , p_revision_date IN DATE
243 , p_revision_reason_code IN VARCHAR2
244 , p_salesrep_id IN NUMBER
245 , p_ship_method_code IN VARCHAR2
246 , p_signature_date IN DATE
247 , p_start_date_active IN DATE
248 , p_term_id IN NUMBER
249 , p_agreement_source_code IN VARCHAR2
250 --added by rchellam for OKC
251 , p_orig_system_agr_id IN NUMBER --added by rchellam for OKC
252 , p_invoice_to_customer_id IN NUMBER -- Added for bug#4029589
253 );
254
255 END OE_OE_Form_Agreement;