[Home] [Help]
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,
374: (
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY VARCHAR2,
377: x_msg_data OUT NOCOPY VARCHAR2,
378: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
379: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
380: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
381: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
382: p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,
644: p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
645: p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
646: -- hd payment record
647: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
648: p_qp_qte_line_index IN jtf_number_table := NULL,
649: p_qp_payment_id IN jtf_number_table := NULL,
650: p_qp_creation_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
645: p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
646: -- hd payment record
647: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
648: p_qp_qte_line_index IN jtf_number_table := NULL,
649: p_qp_payment_id IN jtf_number_table := NULL,
650: p_qp_creation_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
647: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
648: p_qp_qte_line_index IN jtf_number_table := NULL,
649: p_qp_payment_id IN jtf_number_table := NULL,
650: p_qp_creation_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
649: p_qp_payment_id IN jtf_number_table := NULL,
650: p_qp_creation_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
650: p_qp_creation_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
651: p_qp_created_by IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
659: p_qp_quote_header_id IN jtf_number_table := NULL,
652: p_qp_last_update_date IN jtf_date_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
659: p_qp_quote_header_id IN jtf_number_table := NULL,
660: p_qp_quote_line_id IN jtf_number_table := NULL,
653: p_qp_last_updated_by IN jtf_number_table := NULL,
654: p_qp_last_update_login IN jtf_number_table := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
659: p_qp_quote_header_id IN jtf_number_table := NULL,
660: p_qp_quote_line_id IN jtf_number_table := NULL,
661: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
655: p_qp_request_id IN jtf_number_table := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
659: p_qp_quote_header_id IN jtf_number_table := NULL,
660: p_qp_quote_line_id IN jtf_number_table := NULL,
661: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
662: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
663: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
656: p_qp_program_application_id IN jtf_number_table := NULL,
657: p_qp_program_id IN jtf_number_table := NULL,
658: p_qp_program_update_date IN jtf_date_table := NULL,
659: p_qp_quote_header_id IN jtf_number_table := NULL,
660: p_qp_quote_line_id IN jtf_number_table := NULL,
661: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
662: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
663: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
664: p_qp_payment_term_id IN jtf_number_table := NULL,
660: p_qp_quote_line_id IN jtf_number_table := NULL,
661: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
662: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
663: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
664: p_qp_payment_term_id IN jtf_number_table := NULL,
665: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
666: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
667: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
668: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
666: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
667: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
668: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
669: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
670: p_qp_payment_amount IN jtf_number_table := NULL,
671: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
672: p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
673: p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
674: p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,
688: p_qp_attribute17 IN jtf_varchar2_table_300 := NULL,
689: p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
690: p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
691: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
692: p_qp_shipment_index IN jtf_number_table := NULL,
693: p_qp_quote_shipment_id IN jtf_number_table := NULL,
694: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
689: p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
690: p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
691: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
692: p_qp_shipment_index IN jtf_number_table := NULL,
693: p_qp_quote_shipment_id IN jtf_number_table := NULL,
694: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
697: p_qp_instrument_id IN jtf_number_table := NULL,
692: p_qp_shipment_index IN jtf_number_table := NULL,
693: p_qp_quote_shipment_id IN jtf_number_table := NULL,
694: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
697: p_qp_instrument_id IN jtf_number_table := NULL,
698: p_qp_instr_assignment_id IN jtf_number_table := NULL,
699: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
693: p_qp_quote_shipment_id IN jtf_number_table := NULL,
694: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
697: p_qp_instrument_id IN jtf_number_table := NULL,
698: p_qp_instr_assignment_id IN jtf_number_table := NULL,
699: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
701: -- hd price attributes
694: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
695: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
697: p_qp_instrument_id IN jtf_number_table := NULL,
698: p_qp_instr_assignment_id IN jtf_number_table := NULL,
699: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
701: -- hd price attributes
702: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
696: p_qp_trxn_extension_id IN jtf_number_table := NULL,
697: p_qp_instrument_id IN jtf_number_table := NULL,
698: p_qp_instr_assignment_id IN jtf_number_table := NULL,
699: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
701: -- hd price attributes
702: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
703: p_qpa_qte_line_index IN jtf_number_table := NULL,
704: p_qpa_price_attribute_id IN jtf_number_table := NULL,
699: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
701: -- hd price attributes
702: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
703: p_qpa_qte_line_index IN jtf_number_table := NULL,
704: p_qpa_price_attribute_id IN jtf_number_table := NULL,
705: p_qpa_creation_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
700: p_qp_object_version_number IN jtf_number_table := NULL,
701: -- hd price attributes
702: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
703: p_qpa_qte_line_index IN jtf_number_table := NULL,
704: p_qpa_price_attribute_id IN jtf_number_table := NULL,
705: p_qpa_creation_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
702: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
703: p_qpa_qte_line_index IN jtf_number_table := NULL,
704: p_qpa_price_attribute_id IN jtf_number_table := NULL,
705: p_qpa_creation_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
704: p_qpa_price_attribute_id IN jtf_number_table := NULL,
705: p_qpa_creation_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
705: p_qpa_creation_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
706: p_qpa_created_by IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
714: p_qpa_quote_header_id IN jtf_number_table := NULL,
707: p_qpa_last_update_date IN jtf_date_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
714: p_qpa_quote_header_id IN jtf_number_table := NULL,
715: p_qpa_quote_line_id IN jtf_number_table := NULL,
708: p_qpa_last_updated_by IN jtf_number_table := NULL,
709: p_qpa_last_update_login IN jtf_number_table := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
714: p_qpa_quote_header_id IN jtf_number_table := NULL,
715: p_qpa_quote_line_id IN jtf_number_table := NULL,
716: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
710: p_qpa_request_id IN jtf_number_table := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
714: p_qpa_quote_header_id IN jtf_number_table := NULL,
715: p_qpa_quote_line_id IN jtf_number_table := NULL,
716: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
717: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
718: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
711: p_qpa_program_application_id IN jtf_number_table := NULL,
712: p_qpa_program_id IN jtf_number_table := NULL,
713: p_qpa_program_update_date IN jtf_date_table := NULL,
714: p_qpa_quote_header_id IN jtf_number_table := NULL,
715: p_qpa_quote_line_id IN jtf_number_table := NULL,
716: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
717: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
718: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
719: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,
835: p_qpa_attribute17 IN jtf_varchar2_table_300 := NULL,
836: p_qpa_attribute18 IN jtf_varchar2_table_300 := NULL,
837: p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
838: p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
839: p_qpa_object_version_number IN jtf_number_table := NULL,
840: --hd tax details
841: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
838: p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
839: p_qpa_object_version_number IN jtf_number_table := NULL,
840: --hd tax details
841: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
839: p_qpa_object_version_number IN jtf_number_table := NULL,
840: --hd tax details
841: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
840: --hd tax details
841: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
841: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
842: p_qt_qte_line_index IN jtf_number_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
843: p_qt_shipment_index IN jtf_number_table := NULL,
844: p_qt_tax_detail_id IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
845: p_qt_quote_header_id IN jtf_number_table := NULL,
846: p_qt_quote_line_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
847: p_qt_quote_shipment_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
854: p_qt_program_application_id IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
848: p_qt_creation_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
854: p_qt_program_application_id IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
856: p_qt_program_update_date IN jtf_date_table := NULL,
849: p_qt_created_by IN jtf_number_table := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
854: p_qt_program_application_id IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
856: p_qt_program_update_date IN jtf_date_table := NULL,
857: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
850: p_qt_last_update_date IN jtf_date_table := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
854: p_qt_program_application_id IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
856: p_qt_program_update_date IN jtf_date_table := NULL,
857: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
858: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
851: p_qt_last_updated_by IN jtf_number_table := NULL,
852: p_qt_last_update_login IN jtf_number_table := NULL,
853: p_qt_request_id IN jtf_number_table := NULL,
854: p_qt_program_application_id IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
856: p_qt_program_update_date IN jtf_date_table := NULL,
857: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
858: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
859: p_qt_tax_rate IN jtf_number_table := NULL,
855: p_qt_program_id IN jtf_number_table := NULL,
856: p_qt_program_update_date IN jtf_date_table := NULL,
857: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
858: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
859: p_qt_tax_rate IN jtf_number_table := NULL,
860: p_qt_tax_date IN jtf_date_table := NULL,
861: p_qt_tax_amount IN jtf_number_table := NULL,
862: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
863: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
857: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
858: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
859: p_qt_tax_rate IN jtf_number_table := NULL,
860: p_qt_tax_date IN jtf_date_table := NULL,
861: p_qt_tax_amount IN jtf_number_table := NULL,
862: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
863: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
864: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
865: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,
882: p_qt_attribute17 IN jtf_varchar2_table_300 := NULL,
883: p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
884: p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
885: p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
886: p_qt_object_version_number IN jtf_number_table := NULL,
887: p_qt_tax_rate_id IN jtf_number_table := NULL,
888: -- qh sales credit recore
889: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890: p_qsc_qte_line_index IN jtf_number_table := NULL,
883: p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
884: p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
885: p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
886: p_qt_object_version_number IN jtf_number_table := NULL,
887: p_qt_tax_rate_id IN jtf_number_table := NULL,
888: -- qh sales credit recore
889: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890: p_qsc_qte_line_index IN jtf_number_table := NULL,
891: p_qsc_sales_credit_id IN jtf_number_table := NULL,
886: p_qt_object_version_number IN jtf_number_table := NULL,
887: p_qt_tax_rate_id IN jtf_number_table := NULL,
888: -- qh sales credit recore
889: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890: p_qsc_qte_line_index IN jtf_number_table := NULL,
891: p_qsc_sales_credit_id IN jtf_number_table := NULL,
892: p_qsc_creation_date IN jtf_date_table := NULL,
893: p_qsc_created_by IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
887: p_qt_tax_rate_id IN jtf_number_table := NULL,
888: -- qh sales credit recore
889: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890: p_qsc_qte_line_index IN jtf_number_table := NULL,
891: p_qsc_sales_credit_id IN jtf_number_table := NULL,
892: p_qsc_creation_date IN jtf_date_table := NULL,
893: p_qsc_created_by IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
889: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
890: p_qsc_qte_line_index IN jtf_number_table := NULL,
891: p_qsc_sales_credit_id IN jtf_number_table := NULL,
892: p_qsc_creation_date IN jtf_date_table := NULL,
893: p_qsc_created_by IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
896: p_qsc_last_update_login IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
892: p_qsc_creation_date IN jtf_date_table := NULL,
893: p_qsc_created_by IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
896: p_qsc_last_update_login IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
893: p_qsc_created_by IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
896: p_qsc_last_update_login IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
894: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
896: p_qsc_last_update_login IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
895: p_qsc_last_update_date IN jtf_date_table := NULL,
896: p_qsc_last_update_login IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
903: p_qsc_percent IN jtf_number_table := NULL,
897: p_qsc_request_id IN jtf_number_table := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
903: p_qsc_percent IN jtf_number_table := NULL,
904: p_qsc_resource_id IN jtf_number_table := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
898: p_qsc_program_application_id IN jtf_number_table := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
903: p_qsc_percent IN jtf_number_table := NULL,
904: p_qsc_resource_id IN jtf_number_table := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
899: p_qsc_program_id IN jtf_number_table := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
903: p_qsc_percent IN jtf_number_table := NULL,
904: p_qsc_resource_id IN jtf_number_table := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
900: p_qsc_program_update_date IN jtf_date_table := NULL,
901: p_qsc_quote_header_id IN jtf_number_table := NULL,
902: p_qsc_quote_line_id IN jtf_number_table := NULL,
903: p_qsc_percent IN jtf_number_table := NULL,
904: p_qsc_resource_id IN jtf_number_table := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
908: p_qsc_resource_group_id IN jtf_number_table := NULL,
904: p_qsc_resource_id IN jtf_number_table := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
908: p_qsc_resource_group_id IN jtf_number_table := NULL,
909: p_qsc_employee_person_id IN jtf_number_table := NULL,
910: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
911: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
912: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
905: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
908: p_qsc_resource_group_id IN jtf_number_table := NULL,
909: p_qsc_employee_person_id IN jtf_number_table := NULL,
910: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
911: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
912: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
913: p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
906: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
907: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
908: p_qsc_resource_group_id IN jtf_number_table := NULL,
909: p_qsc_employee_person_id IN jtf_number_table := NULL,
910: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
911: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
912: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
913: p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
914: p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,
929: p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
930: p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
931: p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
932: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
933: p_qsc_credit_rule_id IN jtf_number_table := NULL,
934: p_qsc_object_version_number IN jtf_number_table := NULL,
935: -- price adjustment record
936: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
930: p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
931: p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
932: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
933: p_qsc_credit_rule_id IN jtf_number_table := NULL,
934: p_qsc_object_version_number IN jtf_number_table := NULL,
935: -- price adjustment record
936: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
938: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
933: p_qsc_credit_rule_id IN jtf_number_table := NULL,
934: p_qsc_object_version_number IN jtf_number_table := NULL,
935: -- price adjustment record
936: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
938: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
939: p_qlpaj_creation_date IN jtf_date_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
934: p_qsc_object_version_number IN jtf_number_table := NULL,
935: -- price adjustment record
936: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
938: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
939: p_qlpaj_creation_date IN jtf_date_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
936: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
937: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
938: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
939: p_qlpaj_creation_date IN jtf_date_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
938: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
939: p_qlpaj_creation_date IN jtf_date_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
939: p_qlpaj_creation_date IN jtf_date_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
940: p_qlpaj_created_by IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
941: p_qlpaj_last_update_date IN jtf_date_table := NULL,
942: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
943: p_qlpaj_last_update_login IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
944: p_qlpaj_program_application_id IN jtf_number_table := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
945: p_qlpaj_program_id IN jtf_number_table := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
946: p_qlpaj_program_update_date IN jtf_date_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954: p_qlpaj_modified_from IN jtf_number_table := NULL,
947: p_qlpaj_request_id IN jtf_number_table := NULL,
948: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
949: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954: p_qlpaj_modified_from IN jtf_number_table := NULL,
955: p_qlpaj_modified_to IN jtf_number_table := NULL,
950: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954: p_qlpaj_modified_from IN jtf_number_table := NULL,
955: p_qlpaj_modified_to IN jtf_number_table := NULL,
956: p_qlpaj_operand IN jtf_number_table := NULL,
957: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
958: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
951: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954: p_qlpaj_modified_from IN jtf_number_table := NULL,
955: p_qlpaj_modified_to IN jtf_number_table := NULL,
956: p_qlpaj_operand IN jtf_number_table := NULL,
957: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
958: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
959: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
952: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
953: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
954: p_qlpaj_modified_from IN jtf_number_table := NULL,
955: p_qlpaj_modified_to IN jtf_number_table := NULL,
956: p_qlpaj_operand IN jtf_number_table := NULL,
957: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
958: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
959: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
960: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
959: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
960: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
961: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
962: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
963: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
964: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
965: p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
966: p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
967: p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,
986: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
987: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
988: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
989: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
990: p_qlpaj_cost_id IN jtf_number_table := NULL,
991: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
992: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
993: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
994: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
991: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
992: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
993: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
994: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
995: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
996: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
997: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
998: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
999: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
996: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
997: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
998: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
999: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1000: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1001: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1002: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1003: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1004: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
999: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1000: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1001: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1002: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1003: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1004: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1005: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1006: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1007: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1000: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1001: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1002: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1003: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1004: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1005: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1006: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1007: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1008: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1001: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1002: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1003: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1004: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1005: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1006: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1007: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1008: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1009: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1005: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1006: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1007: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1008: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1009: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1010: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1011: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1012: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1013: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,
1020: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1021: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1022: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1023: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1024: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1025: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1026: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1027: p_api_version_number IN NUMBER := 1 ,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1021: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1022: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1023: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1024: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1025: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1026: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1027: p_api_version_number IN NUMBER := 1 ,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1029: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1022: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1023: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1024: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1025: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1026: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1027: p_api_version_number IN NUMBER := 1 ,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1029: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1030: x_return_status OUT NOCOPY VARCHAR2 ,