1 PACKAGE ASO_Config_Operations_Int_W as
2 /* $Header: asovqwcs.pls 120.2 2005/10/03 15:38:45 skulkarn ship $ */
3
4 PROCEDURE Is_Container
5 (p_api_version IN NUMBER := 1 ,
6 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
7 p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
8 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
9 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
10 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
11 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
12 p_ap_usage_name IN VARCHAR2:= FND_API.G_MISS_CHAR ,
13 p_ap_publication_mode IN VARCHAR2:= FND_API.G_MISS_CHAR ,
14 p_ap_language IN VARCHAR2:= FND_API.G_MISS_CHAR ,
15 x_return_value OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
16 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
17 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
18 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
19 );
20
21 PROCEDURE Get_Contained_Models
22 (x_model_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE ,
23 p_api_version IN NUMBER := 1 ,
24 p_inventory_item_id IN NUMBER := FND_API.G_MISS_NUM ,
25 p_organization_id IN NUMBER := FND_API.G_MISS_NUM ,
26 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE ,
27 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE ,
28 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE ,
29 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM ,
30 p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR ,
31 p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
32 p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR ,
33 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
34 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
35 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
36 );
37
38
39 PROCEDURE Config_Operations
40 (x_q_quote_header_id OUT NOCOPY NUMBER,
41 x_q_last_update_date OUT NOCOPY DATE,
42 x_q_object_version_number OUT NOCOPY NUMBER,
43 p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
44 p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
45 p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
46 p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
47 p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
48 p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
49 p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
50 p_c_functionality_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
51 p_c_copy_task_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
52 p_c_copy_notes_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
53 p_c_copy_att_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
54 p_c_deactivate_all IN VARCHAR2 := FND_API.G_MISS_CHAR,
55 p_c_price_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
56 p_c_dependency_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
57 p_c_defaulting_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
58 p_c_defaulting_fwk_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
59 p_c_application_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
60 p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
61 p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
62 p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
63 p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
64 p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
65 p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
66 p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
67 p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
68 p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
69 p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
70 p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
71 p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
72 p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
73 p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
74 p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
75 p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
76 p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
77 p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
78 p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
79 p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
80 p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
81 p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
82 p_q_invoice_to_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM,
83 p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
84 p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
85 p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
86 p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
87 p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
88 p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
89 p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
90 p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
91 p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
92 p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
93 p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
94 p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
95 p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
96 p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
97 p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
98 p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
99 p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
100 p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
101 p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
102 p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
103 p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
104 p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
105 p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
106 p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
107 p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
108 p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
109 p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
110 p_q_salesrep_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
111 p_q_salesrep_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
112 p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
113 p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
114 p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
115 p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
116 p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
117 p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
118 p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
119 p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
120 p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
121 p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
122 p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
123 p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
124 p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
125 p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
126 p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
127 p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
128 p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
129 p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
130 p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
131 p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132 p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133 p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134 p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135 p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
136 p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
137 p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138 p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
139 p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
140 p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
141 p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
142 p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
143 p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
144 p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
145 p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
146 p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
147 p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
148 p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
149 p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
150 p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
151 p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
152 p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
153 p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
154 p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
155 p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
156 p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
157 p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
158 p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
159 p_q_contract_template_id IN NUMBER := FND_API.G_MISS_NUM,
160 p_q_contract_template_maj_ver IN NUMBER := FND_API.G_MISS_NUM,
161 p_q_contract_requester_id IN NUMBER := FND_API.G_MISS_NUM,
162 p_q_contract_approval_level IN VARCHAR2 := FND_API.G_MISS_CHAR,
163 p_q_publish_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
164 p_q_resource_grp_id IN NUMBER := FND_API.G_MISS_NUM,
165 p_q_sold_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
166 p_q_display_arithmetic_op IN VARCHAR2 := FND_API.G_MISS_CHAR,
167 p_q_quote_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
168 p_q_quote_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
169 p_q_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
170 p_q_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
171 p_q_invoice_to_cust_party_id IN NUMBER := FND_API.G_MISS_NUM,
172 p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
173 p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
174 p_q_price_updated_date IN DATE := FND_API.G_MISS_DATE,
175 p_q_tax_updated_date IN DATE := FND_API.G_MISS_DATE,
176 p_q_recalculate_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
177 p_q_price_request_id IN NUMBER := FND_API.G_MISS_NUM,
178 p_q_credit_update_date IN DATE := FND_API.G_MISS_DATE,
179 p_q_customer_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
180 p_q_customer_signature_date IN DATE := FND_API.G_MISS_DATE,
181 p_q_supplier_name_and_title IN VARCHAR2 := FND_API.G_MISS_CHAR,
182 p_q_supplier_signature_date IN DATE := FND_API.G_MISS_DATE,
183 p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
184 p_ql_creation_date IN jtf_date_table := NULL,
185 p_ql_created_by IN jtf_number_table := NULL,
186 p_ql_last_updated_by IN jtf_number_table := NULL,
187 p_ql_last_update_date IN jtf_date_table := NULL,
188 p_ql_last_update_login IN jtf_number_table := NULL,
189 p_ql_request_id IN jtf_number_table := NULL,
190 p_ql_program_application_id IN jtf_number_table := NULL,
191 p_ql_program_id IN jtf_number_table := NULL,
192 p_ql_program_update_date IN jtf_date_table := NULL,
193 p_ql_quote_line_id IN jtf_number_table := NULL,
194 p_ql_quote_header_id IN jtf_number_table := NULL,
195 p_ql_org_id IN jtf_number_table := NULL,
196 p_ql_line_number IN jtf_number_table := NULL,
197 p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
198 p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
199 p_ql_inventory_item_id IN jtf_number_table := NULL,
200 p_ql_organization_id IN jtf_number_table := NULL,
201 p_ql_quantity IN jtf_number_table := NULL,
202 p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
203 p_ql_start_date_active IN jtf_date_table := NULL,
204 p_ql_end_date_active IN jtf_date_table := NULL,
205 p_ql_order_line_type_id IN jtf_number_table := NULL,
206 p_ql_price_list_id IN jtf_number_table := NULL,
207 p_ql_price_list_line_id IN jtf_number_table := NULL,
208 p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
209 p_ql_line_list_price IN jtf_number_table := NULL,
210 p_ql_line_adjusted_amount IN jtf_number_table := NULL,
211 p_ql_line_adjusted_percent IN jtf_number_table := NULL,
212 p_ql_line_quote_price IN jtf_number_table := NULL,
213 p_ql_related_item_id IN jtf_number_table := NULL,
214 p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
215 p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
216 p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
217 p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
218 p_ql_recalculate_flag IN jtf_varchar2_table_100 := NULL,
219 p_ql_attribute_category IN jtf_varchar2_table_100 := NULL,
220 p_ql_attribute1 IN jtf_varchar2_table_300 := NULL,
221 p_ql_attribute2 IN jtf_varchar2_table_300 := NULL,
222 p_ql_attribute3 IN jtf_varchar2_table_300 := NULL,
223 p_ql_attribute4 IN jtf_varchar2_table_300 := NULL,
224 p_ql_attribute5 IN jtf_varchar2_table_300 := NULL,
225 p_ql_attribute6 IN jtf_varchar2_table_300 := NULL,
226 p_ql_attribute7 IN jtf_varchar2_table_300 := NULL,
227 p_ql_attribute8 IN jtf_varchar2_table_300 := NULL,
228 p_ql_attribute9 IN jtf_varchar2_table_300 := NULL,
229 p_ql_attribute10 IN jtf_varchar2_table_300 := NULL,
230 p_ql_attribute11 IN jtf_varchar2_table_300 := NULL,
231 p_ql_attribute12 IN jtf_varchar2_table_300 := NULL,
232 p_ql_attribute13 IN jtf_varchar2_table_300 := NULL,
233 p_ql_attribute14 IN jtf_varchar2_table_300 := NULL,
234 p_ql_attribute15 IN jtf_varchar2_table_300 := NULL,
235 p_ql_accounting_rule_id IN jtf_number_table := NULL,
236 p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
237 p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
238 p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
239 p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
243 p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
240 p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
241 p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
242 p_ql_invoice_to_party_id IN jtf_number_table := NULL,
244 p_ql_invoicing_rule_id IN jtf_number_table := NULL,
245 p_ql_marketing_source_code_id IN jtf_number_table := NULL,
246 p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
247 p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
248 p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
249 p_ql_minisite_id IN jtf_number_table := NULL,
250 p_ql_section_id IN jtf_number_table := NULL,
251 p_ql_priced_price_list_id IN jtf_number_table := NULL,
252 p_ql_agreement_id IN jtf_number_table := NULL,
253 p_ql_commitment_id IN jtf_number_table := NULL,
254 p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
255 p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
256 p_i_instance_id IN JTF_NUMBER_TABLE := NULL ,
257 p_i_price_list_id IN JTF_NUMBER_TABLE := NULL ,
258 p_operation_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
259 p_api_version_number IN NUMBER := 1 ,
260 p_init_msg_list IN VARCHAR2:= FND_API.G_TRUE ,
261 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
262 p_validation_level IN NUMBER := FND_API.G_MISS_NUM,
263 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ,
264 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER ,
265 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
266 );
267
268
269 FUNCTION Construct_Appl_Param_Rec(
270 p_ap_config_creation_date IN DATE := FND_API.G_MISS_DATE,
271 p_ap_config_model_lookup_date IN DATE := FND_API.G_MISS_DATE,
272 p_ap_config_effective_date IN DATE := FND_API.G_MISS_DATE,
273 p_ap_calling_application_id IN NUMBER := FND_API.G_MISS_NUM,
274 p_ap_usage_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275 p_ap_publication_mode IN VARCHAR2 := FND_API.G_MISS_CHAR,
276 p_ap_language IN VARCHAR2 := FND_API.G_MISS_CHAR
277 )
278 RETURN CZ_API_PUB.appl_param_rec_type;
279
280 END ASO_Config_Operations_Int_W;