DBA Data[Home] [Help]

APPS.ASO_QUOTE_PUB_W1 dependencies on JTF_NUMBER_TABLE

Line 8: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,

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,

Line 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,

Line 15: x_atp_identifier 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,

Line 16: x_atp_customer_id OUT NOCOPY jtf_number_table,

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,

Line 17: x_atp_customer_site_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,
21: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,

Line 18: x_atp_quantity_ordered OUT NOCOPY jtf_number_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,

Line 23: x_atp_available_quantity 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,
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:

Line 24: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,

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,

Line 25: x_atp_error_code OUT NOCOPY jtf_number_table,

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,

Line 39: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,

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,

Line 40: x_atp_quote_header_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,

Line 41: x_atp_calling_module 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,

Line 42: x_atp_quote_number 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,

Line 43: x_atp_ato_line_id 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,

Line 44: x_atp_ref_line_id 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,
48: x_atp_organization_id OUT NOCOPY jtf_number_table,

Line 45: x_atp_top_model_line_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,

Line 46: x_atp_action 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,
50: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,

Line 48: x_atp_organization_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,

Line 50: x_atp_component_sequence_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,
53: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
54: x_atp_country OUT NOCOPY jtf_varchar2_table_600,

Line 51: x_atp_included_item_flag 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,
55: x_atp_state OUT NOCOPY jtf_varchar2_table_600,

Line 52: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_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,
56: x_atp_city OUT NOCOPY jtf_varchar2_table_600,

Line 53: x_atp_ship_to_party_site_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,
57: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,

Line 58: x_atp_match_item_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,
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,

Line 200: p_ql_created_by IN jtf_number_table := NULL,

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,

Line 201: p_ql_last_updated_by 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,

Line 203: p_ql_last_update_login 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,

Line 204: p_ql_request_id IN jtf_number_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,

Line 205: p_ql_program_application_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,

Line 206: p_ql_program_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,

Line 208: p_ql_quote_line_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,

Line 209: p_ql_quote_header_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,
213: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

Line 210: p_ql_org_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,
214: p_ql_inventory_item_id IN jtf_number_table := NULL,

Line 211: p_ql_line_number 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,

Line 214: p_ql_inventory_item_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,

Line 215: p_ql_organization_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,
219: p_ql_end_date_active IN jtf_date_table := NULL,

Line 216: p_ql_quantity 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,
220: p_ql_order_line_type_id IN jtf_number_table := NULL,

Line 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,

Line 221: p_ql_price_list_id 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,

Line 222: p_ql_price_list_line_id 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,

Line 224: p_ql_line_list_price 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,

Line 225: p_ql_line_adjusted_amount 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,

Line 226: p_ql_line_adjusted_percent 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,
230: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

Line 227: p_ql_line_quote_price 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,
231: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

Line 228: p_ql_related_item_id IN jtf_number_table := 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,

Line 255: p_ql_accounting_rule_id IN jtf_number_table := 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,

Line 262: p_ql_invoice_to_party_id IN jtf_number_table := 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,

Line 263: p_ql_invoice_to_party_site_id IN jtf_number_table := 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,

Line 264: p_ql_invoicing_rule_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,

Line 265: p_ql_marketing_source_code_id IN jtf_number_table := 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,

Line 267: p_ql_invoice_to_cust_acct_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,

Line 269: p_ql_minisite_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,

Line 270: p_ql_section_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,

Line 271: p_ql_priced_price_list_id IN jtf_number_table := 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,

Line 272: p_ql_agreement_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:

Line 273: p_ql_commitment_id IN jtf_number_table := 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:
277: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */

Line 275: p_ql_invoice_to_cust_party_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 */
278: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
279: p_qls_qte_line_index IN jtf_number_table := NULL,

Line 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,

Line 280: p_qls_shipment_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,
284: p_qls_last_updated_by IN jtf_number_table := NULL,

Line 282: p_qls_created_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,

Line 284: p_qls_last_updated_by 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,

Line 285: p_qls_last_update_login 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,

Line 286: p_qls_request_id IN jtf_number_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,

Line 287: p_qls_program_application_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,

Line 288: p_qls_program_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,

Line 290: p_qls_quote_header_id 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,
293: p_qls_request_date IN jtf_date_table := NULL,
294: p_qls_schedule_ship_date IN jtf_date_table := NULL,

Line 291: p_qls_quote_line_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,
295: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,

Line 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,

Line 296: p_qls_ship_to_party_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,

Line 297: p_qls_ship_to_cust_account_id IN jtf_number_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,
301: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,

Line 299: p_qls_ship_set_id IN jtf_number_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,
302: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
303: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,

Line 306: p_qls_quantity IN jtf_number_table := 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,

Line 308: p_qls_reservation_id IN jtf_number_table := 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,

Line 309: p_qls_order_line_id IN jtf_number_table := 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,

Line 346: p_qls_ship_quote_price IN jtf_number_table := 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,

Line 347: p_qls_pricing_quantity 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,

Line 349: p_qls_ship_from_org_id IN jtf_number_table := 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,

Line 350: p_qls_ship_to_cust_party_id 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 */

Line 353: p_qls_object_version_number IN jtf_number_table := 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 */
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,