4:
5: PROCEDURE Check_Atp
6: (
7: /* OUT parameters for quote line record ASO_ATP_INT.Atp_Tbl_Typ */
8: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
9: x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
10: x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
8: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
9: x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
10: x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
11: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
13: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15: x_atp_identifier OUT NOCOPY jtf_number_table,
16: x_atp_customer_id OUT NOCOPY jtf_number_table,
11: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
12: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
13: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15: x_atp_identifier OUT NOCOPY jtf_number_table,
16: x_atp_customer_id OUT NOCOPY jtf_number_table,
17: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
12: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
13: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15: x_atp_identifier OUT NOCOPY jtf_number_table,
16: x_atp_customer_id OUT NOCOPY jtf_number_table,
17: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
13: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
14: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15: x_atp_identifier OUT NOCOPY jtf_number_table,
16: x_atp_customer_id OUT NOCOPY jtf_number_table,
17: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
14: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
15: x_atp_identifier OUT NOCOPY jtf_number_table,
16: x_atp_customer_id OUT NOCOPY jtf_number_table,
17: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
18: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
19: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22: x_atp_ship_date OUT NOCOPY jtf_date_table,
19: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
20: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22: x_atp_ship_date OUT NOCOPY jtf_date_table,
23: x_atp_available_quantity OUT NOCOPY jtf_number_table,
24: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
25: x_atp_error_code OUT NOCOPY jtf_number_table,
26: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
27:
20: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22: x_atp_ship_date OUT NOCOPY jtf_date_table,
23: x_atp_available_quantity OUT NOCOPY jtf_number_table,
24: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
25: x_atp_error_code OUT NOCOPY jtf_number_table,
26: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
27:
28: x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
22: x_atp_ship_date OUT NOCOPY jtf_date_table,
23: x_atp_available_quantity OUT NOCOPY jtf_number_table,
24: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
25: x_atp_error_code OUT NOCOPY jtf_number_table,
26: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
27:
28: x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
29: x_atp_req_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,
35: x_atp_group_ship_date OUT NOCOPY jtf_date_table,
36: x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
37: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
38: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
36: x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
37: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
38: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
37: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
38: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
38: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
40: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
41: x_atp_calling_module OUT NOCOPY jtf_number_table,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
42: x_atp_quote_number OUT NOCOPY jtf_number_table,
43: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
44: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
45: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
46: x_atp_action OUT NOCOPY jtf_number_table,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
47: x_atp_arrival_date OUT NOCOPY jtf_date_table,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
56: x_atp_city OUT NOCOPY jtf_varchar2_table_600,
49: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
51: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
53: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
56: x_atp_city OUT NOCOPY jtf_varchar2_table_600,
57: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
55: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
56: x_atp_city OUT NOCOPY jtf_varchar2_table_600,
57: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
58: x_atp_match_item_id OUT NOCOPY jtf_number_table,
59: /* Parameters for quote header record */
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,
196: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
197:
198: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
199: p_ql_creation_date IN jtf_date_table := NULL,
200: p_ql_created_by IN jtf_number_table := NULL,
201: p_ql_last_updated_by IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
197:
198: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
199: p_ql_creation_date IN jtf_date_table := NULL,
200: p_ql_created_by IN jtf_number_table := NULL,
201: p_ql_last_updated_by IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
199: p_ql_creation_date IN jtf_date_table := NULL,
200: p_ql_created_by IN jtf_number_table := NULL,
201: p_ql_last_updated_by IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
200: p_ql_created_by IN jtf_number_table := NULL,
201: p_ql_last_updated_by IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
201: p_ql_last_updated_by IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
202: p_ql_last_update_date IN jtf_date_table := NULL,
203: p_ql_last_update_login IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
204: p_ql_request_id IN jtf_number_table := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
205: p_ql_program_application_id IN jtf_number_table := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
206: p_ql_program_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,
207: p_ql_program_update_date IN jtf_date_table := NULL,
208: p_ql_quote_line_id IN jtf_number_table := NULL,
209: p_ql_quote_header_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,
215: p_ql_organization_id IN jtf_number_table := NULL,
210: p_ql_org_id IN jtf_number_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,
215: p_ql_organization_id IN jtf_number_table := NULL,
216: p_ql_quantity IN jtf_number_table := NULL,
217: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
211: p_ql_line_number IN jtf_number_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,
215: p_ql_organization_id IN jtf_number_table := NULL,
216: p_ql_quantity IN jtf_number_table := NULL,
217: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
219: p_ql_end_date_active IN jtf_date_table := NULL,
212: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,
215: p_ql_organization_id IN jtf_number_table := NULL,
216: p_ql_quantity IN jtf_number_table := NULL,
217: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
219: p_ql_end_date_active IN jtf_date_table := NULL,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,
216: p_ql_quantity IN jtf_number_table := NULL,
217: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
219: p_ql_end_date_active IN jtf_date_table := NULL,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,
221: p_ql_price_list_id IN jtf_number_table := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
217: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
219: p_ql_end_date_active IN jtf_date_table := NULL,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,
221: p_ql_price_list_id IN jtf_number_table := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
218: p_ql_start_date_active IN jtf_date_table := NULL,
219: p_ql_end_date_active IN jtf_date_table := NULL,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,
221: p_ql_price_list_id IN jtf_number_table := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,
221: p_ql_price_list_id IN jtf_number_table := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227: p_ql_line_quote_price IN jtf_number_table := NULL,
228: p_ql_related_item_id IN jtf_number_table := NULL,
221: p_ql_price_list_id IN jtf_number_table := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227: p_ql_line_quote_price IN jtf_number_table := NULL,
228: p_ql_related_item_id IN jtf_number_table := NULL,
229: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
222: p_ql_price_list_line_id IN jtf_number_table := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227: p_ql_line_quote_price IN jtf_number_table := NULL,
228: p_ql_related_item_id IN jtf_number_table := NULL,
229: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
230: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
223: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227: p_ql_line_quote_price IN jtf_number_table := NULL,
228: p_ql_related_item_id IN jtf_number_table := NULL,
229: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
230: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
231: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
224: p_ql_line_list_price IN jtf_number_table := NULL,
225: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
226: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
227: p_ql_line_quote_price IN jtf_number_table := NULL,
228: p_ql_related_item_id IN jtf_number_table := NULL,
229: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
230: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
231: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
232: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,
251: p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
252: p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
253: p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
254: p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
255: p_ql_accounting_rule_id IN jtf_number_table := NULL,
256: p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
257: p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
258: p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
259: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
258: p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
259: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
260: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
261: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
259: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
260: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
261: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
260: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
261: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
261: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
262: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
263: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
263: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
264: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
265: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
266: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
274: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
267: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
274: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
268: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
274: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276:
269: p_ql_minisite_id IN jtf_number_table := NULL,
270: p_ql_section_id IN jtf_number_table := NULL,
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
274: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276:
277: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
271: p_ql_priced_price_list_id IN jtf_number_table := NULL,
272: p_ql_agreement_id IN jtf_number_table := NULL,
273: p_ql_commitment_id IN jtf_number_table := NULL,
274: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
275: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276:
277: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
278: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279: p_qls_qte_line_index IN jtf_number_table := NULL,
275: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
276:
277: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
278: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279: p_qls_qte_line_index IN jtf_number_table := NULL,
280: p_qls_shipment_id IN jtf_number_table := NULL,
281: p_qls_creation_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
276:
277: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
278: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279: p_qls_qte_line_index IN jtf_number_table := NULL,
280: p_qls_shipment_id IN jtf_number_table := NULL,
281: p_qls_creation_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
278: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279: p_qls_qte_line_index IN jtf_number_table := NULL,
280: p_qls_shipment_id IN jtf_number_table := NULL,
281: p_qls_creation_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
280: p_qls_shipment_id IN jtf_number_table := NULL,
281: p_qls_creation_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
281: p_qls_creation_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
282: p_qls_created_by IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
290: p_qls_quote_header_id IN jtf_number_table := NULL,
283: p_qls_last_update_date IN jtf_date_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
290: p_qls_quote_header_id IN jtf_number_table := NULL,
291: p_qls_quote_line_id IN jtf_number_table := NULL,
284: p_qls_last_updated_by IN jtf_number_table := NULL,
285: p_qls_last_update_login IN jtf_number_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
290: p_qls_quote_header_id IN jtf_number_table := NULL,
291: p_qls_quote_line_id IN jtf_number_table := NULL,
292: p_qls_promise_date IN jtf_date_table := NULL,
286: p_qls_request_id IN jtf_number_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
290: p_qls_quote_header_id IN jtf_number_table := NULL,
291: p_qls_quote_line_id IN jtf_number_table := NULL,
292: p_qls_promise_date IN jtf_date_table := NULL,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,
287: p_qls_program_application_id IN jtf_number_table := NULL,
288: p_qls_program_id IN jtf_number_table := NULL,
289: p_qls_program_update_date IN jtf_date_table := NULL,
290: p_qls_quote_header_id IN jtf_number_table := NULL,
291: p_qls_quote_line_id IN jtf_number_table := NULL,
292: p_qls_promise_date IN jtf_date_table := NULL,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
291: p_qls_quote_line_id IN jtf_number_table := NULL,
292: p_qls_promise_date IN jtf_date_table := NULL,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296: p_qls_ship_to_party_id IN jtf_number_table := NULL,
297: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299: p_qls_ship_set_id IN jtf_number_table := NULL,
292: p_qls_promise_date IN jtf_date_table := NULL,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296: p_qls_ship_to_party_id IN jtf_number_table := NULL,
297: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299: p_qls_ship_set_id IN jtf_number_table := NULL,
300: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296: p_qls_ship_to_party_id IN jtf_number_table := NULL,
297: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299: p_qls_ship_set_id IN jtf_number_table := NULL,
300: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
301: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
296: p_qls_ship_to_party_id IN jtf_number_table := NULL,
297: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
298: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
299: p_qls_ship_set_id IN jtf_number_table := NULL,
300: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
301: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
302: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
303: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
302: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
303: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
304: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
305: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
306: p_qls_quantity IN jtf_number_table := NULL,
307: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
308: p_qls_reservation_id IN jtf_number_table := NULL,
309: p_qls_order_line_id IN jtf_number_table := NULL,
310: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
304: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
305: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
306: p_qls_quantity IN jtf_number_table := NULL,
307: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
308: p_qls_reservation_id IN jtf_number_table := NULL,
309: p_qls_order_line_id IN jtf_number_table := NULL,
310: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
311: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
312: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
305: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
306: p_qls_quantity IN jtf_number_table := NULL,
307: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
308: p_qls_reservation_id IN jtf_number_table := NULL,
309: p_qls_order_line_id IN jtf_number_table := NULL,
310: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
311: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
312: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
313: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,
342: p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
343: p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
344: p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
345: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
346: p_qls_ship_quote_price IN jtf_number_table := NULL,
347: p_qls_pricing_quantity IN jtf_number_table := NULL,
348: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349: p_qls_ship_from_org_id IN jtf_number_table := NULL,
350: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
343: p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
344: p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
345: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
346: p_qls_ship_quote_price IN jtf_number_table := NULL,
347: p_qls_pricing_quantity IN jtf_number_table := NULL,
348: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349: p_qls_ship_from_org_id IN jtf_number_table := NULL,
350: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
345: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
346: p_qls_ship_quote_price IN jtf_number_table := NULL,
347: p_qls_pricing_quantity IN jtf_number_table := NULL,
348: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349: p_qls_ship_from_org_id IN jtf_number_table := NULL,
350: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
352: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
353: p_qls_object_version_number IN jtf_number_table := NULL,
346: p_qls_ship_quote_price IN jtf_number_table := NULL,
347: p_qls_pricing_quantity IN jtf_number_table := NULL,
348: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
349: p_qls_ship_from_org_id IN jtf_number_table := NULL,
350: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
352: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
353: p_qls_object_version_number IN jtf_number_table := NULL,
354: /* Standard IN parameters */
349: p_qls_ship_from_org_id IN jtf_number_table := NULL,
350: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
351: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
352: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
353: p_qls_object_version_number IN jtf_number_table := NULL,
354: /* Standard IN parameters */
355: P_API_VERSION_NUMBER IN NUMBER := 1,
356: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
357: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,