eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_PUB_W1 dependencies on JTF_NUMBER_TABLE

Line 25: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,

21: RETURN n;
22: END;
23: PROCEDURE Check_Atp (
24: /* OUT parameters for quote line record ASO_ATP_INT.Atp_Tbl_Typ */
25: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
26: x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
27: x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
28: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
29: x_atp_source_organization_id OUT NOCOPY jtf_number_table,

Line 29: x_atp_source_organization_id OUT NOCOPY jtf_number_table,

25: x_atp_inventory_item_id OUT NOCOPY jtf_number_table,
26: x_atp_inventory_item_name OUT NOCOPY jtf_varchar2_table_300,
27: x_inventory_item_description OUT NOCOPY JTF_VARCHAR2_TABLE_300,
28: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
29: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
30: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
31: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,

Line 32: x_atp_identifier OUT NOCOPY jtf_number_table,

28: x_padded_concatenated_segments OUT NOCOPY JTF_VARCHAR2_TABLE_300,
29: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
30: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
31: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,

Line 33: x_atp_customer_id OUT NOCOPY jtf_number_table,

29: x_atp_source_organization_id OUT NOCOPY jtf_number_table,
30: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
31: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,

30: x_atp_source_organization_code OUT NOCOPY jtf_varchar2_table_300,
31: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,

Line 35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,

31: x_atp_source_organization_name OUT NOCOPY JTF_VARCHAR2_TABLE_300,
32: x_atp_identifier OUT NOCOPY jtf_number_table,
33: x_atp_customer_id OUT NOCOPY jtf_number_table,
34: x_atp_customer_site_id OUT NOCOPY jtf_number_table,
35: x_atp_quantity_ordered OUT NOCOPY jtf_number_table,
36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,

Line 40: x_atp_available_quantity OUT NOCOPY jtf_number_table,

36: x_atp_quantity_uom OUT NOCOPY jtf_varchar2_table_100,
37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,
40: x_atp_available_quantity OUT NOCOPY jtf_number_table,
41: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
42: x_atp_error_code OUT NOCOPY jtf_number_table,
43: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
44:

Line 41: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,

37: x_atp_uom_meaning OUT NOCOPY JTF_VARCHAR2_TABLE_100,
38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,
40: x_atp_available_quantity OUT NOCOPY jtf_number_table,
41: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
42: x_atp_error_code OUT NOCOPY jtf_number_table,
43: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
44:
45: x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,

Line 42: x_atp_error_code OUT NOCOPY jtf_number_table,

38: x_atp_requested_ship_date OUT NOCOPY jtf_date_table,
39: x_atp_ship_date OUT NOCOPY jtf_date_table,
40: x_atp_available_quantity OUT NOCOPY jtf_number_table,
41: x_atp_request_date_quantity OUT NOCOPY jtf_number_table,
42: x_atp_error_code OUT NOCOPY jtf_number_table,
43: x_atp_message OUT NOCOPY jtf_varchar2_table_2000,
44:
45: x_atp_request_date_type OUT NOCOPY jtf_varchar2_table_300,
46: x_atp_req_date_type_meaning OUT NOCOPY jtf_varchar2_table_300,

Line 56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,

52: x_atp_group_ship_date OUT NOCOPY jtf_date_table,
53: x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
54: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
55: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,

Line 57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,

53: x_atp_requested_arrival_date OUT NOCOPY jtf_date_table,
54: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
55: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,

Line 58: x_atp_calling_module OUT NOCOPY jtf_number_table,

54: x_atp_ship_method_code OUT NOCOPY jtf_varchar2_table_300,
55: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,

Line 59: x_atp_quote_number OUT NOCOPY jtf_number_table,

55: x_atp_ship_method_meaning OUT NOCOPY jtf_varchar2_table_300,
56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,

Line 60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,

56: x_atp_quantity_on_hand OUT NOCOPY jtf_number_table,
57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,

Line 61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,

57: x_atp_quote_header_id OUT NOCOPY jtf_number_table,
58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,

Line 62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,

58: x_atp_calling_module OUT NOCOPY jtf_number_table,
59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,

Line 63: x_atp_action OUT NOCOPY jtf_number_table,

59: x_atp_quote_number OUT NOCOPY jtf_number_table,
60: x_atp_ato_line_id OUT NOCOPY jtf_number_table,
61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,

Line 65: x_atp_organization_id OUT NOCOPY jtf_number_table,

61: x_atp_ref_line_id OUT NOCOPY jtf_number_table,
62: x_atp_top_model_line_id OUT NOCOPY jtf_number_table,
63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,

Line 67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,

63: x_atp_action OUT NOCOPY jtf_number_table,
64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
70: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
71: x_atp_country OUT NOCOPY jtf_varchar2_table_600,

Line 68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,

64: x_atp_arrival_date OUT NOCOPY jtf_date_table,
65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
70: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
71: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
72: x_atp_state OUT NOCOPY jtf_varchar2_table_600,

Line 69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,

65: x_atp_organization_id OUT NOCOPY jtf_number_table,
66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
70: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
71: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
72: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
73: x_atp_city OUT NOCOPY jtf_varchar2_table_600,

Line 70: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,

66: x_atp_component_code OUT NOCOPY jtf_varchar2_table_1200,
67: x_atp_component_sequence_id OUT NOCOPY jtf_number_table,
68: x_atp_included_item_flag OUT NOCOPY jtf_number_table,
69: x_atp_cascade_mdl_info_to_comp OUT NOCOPY jtf_number_table,
70: x_atp_ship_to_party_site_id OUT NOCOPY jtf_number_table,
71: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
72: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
73: x_atp_city OUT NOCOPY jtf_varchar2_table_600,
74: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,

Line 75: x_atp_match_item_id OUT NOCOPY jtf_number_table,

71: x_atp_country OUT NOCOPY jtf_varchar2_table_600,
72: x_atp_state OUT NOCOPY jtf_varchar2_table_600,
73: x_atp_city OUT NOCOPY jtf_varchar2_table_600,
74: x_atp_postal_code OUT NOCOPY jtf_varchar2_table_600,
75: x_atp_match_item_id OUT NOCOPY jtf_number_table,
76:
77: /* parameters for the quote header record */
78: p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
79: p_q_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 218: p_ql_created_by IN jtf_number_table := NULL,

214: p_q_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217: p_ql_creation_date IN jtf_date_table := NULL,
218: p_ql_created_by IN jtf_number_table := NULL,
219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,

Line 219: p_ql_last_updated_by IN jtf_number_table := NULL,

215:
216: /* Parameters for quote line record ASO_QUOTE_PUB.Quote_Line_Tbl_Type */
217: p_ql_creation_date IN jtf_date_table := NULL,
218: p_ql_created_by IN jtf_number_table := NULL,
219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,

Line 221: p_ql_last_update_login IN jtf_number_table := NULL,

217: p_ql_creation_date IN jtf_date_table := NULL,
218: p_ql_created_by IN jtf_number_table := NULL,
219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,

Line 222: p_ql_request_id IN jtf_number_table := NULL,

218: p_ql_created_by IN jtf_number_table := NULL,
219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,

Line 223: p_ql_program_application_id IN jtf_number_table := NULL,

219: p_ql_last_updated_by IN jtf_number_table := NULL,
220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,

Line 224: p_ql_program_id IN jtf_number_table := NULL,

220: p_ql_last_update_date IN jtf_date_table := NULL,
221: p_ql_last_update_login IN jtf_number_table := NULL,
222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,

Line 226: p_ql_quote_line_id IN jtf_number_table := NULL,

222: p_ql_request_id IN jtf_number_table := NULL,
223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,

Line 227: p_ql_quote_header_id IN jtf_number_table := NULL,

223: p_ql_program_application_id IN jtf_number_table := NULL,
224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,

Line 228: p_ql_org_id IN jtf_number_table := NULL,

224: p_ql_program_id IN jtf_number_table := NULL,
225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,

Line 229: p_ql_line_number IN jtf_number_table := NULL,

225: p_ql_program_update_date IN jtf_date_table := NULL,
226: p_ql_quote_line_id IN jtf_number_table := NULL,
227: p_ql_quote_header_id IN jtf_number_table := NULL,
228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,

Line 232: p_ql_inventory_item_id IN jtf_number_table := NULL,

228: p_ql_org_id IN jtf_number_table := NULL,
229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,

Line 233: p_ql_organization_id IN jtf_number_table := NULL,

229: p_ql_line_number IN jtf_number_table := NULL,
230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,

Line 234: p_ql_quantity IN jtf_number_table := NULL,

230: p_ql_line_category_code IN jtf_varchar2_table_100 := NULL,
231: p_ql_item_type_code IN jtf_varchar2_table_100 := NULL,
232: p_ql_inventory_item_id IN jtf_number_table := NULL,
233: p_ql_organization_id IN jtf_number_table := NULL,
234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,

Line 238: p_ql_order_line_type_id IN jtf_number_table := NULL,

234: p_ql_quantity IN jtf_number_table := NULL,
235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,

Line 239: p_ql_price_list_id IN jtf_number_table := NULL,

235: p_ql_uom_code IN jtf_varchar2_table_100 := NULL,
236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,

Line 240: p_ql_price_list_line_id IN jtf_number_table := NULL,

236: p_ql_start_date_active IN jtf_date_table := NULL,
237: p_ql_end_date_active IN jtf_date_table := NULL,
238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,

Line 242: p_ql_line_list_price IN jtf_number_table := NULL,

238: p_ql_order_line_type_id IN jtf_number_table := NULL,
239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,

Line 243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,

239: p_ql_price_list_id IN jtf_number_table := NULL,
240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,

Line 244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,

240: p_ql_price_list_line_id IN jtf_number_table := NULL,
241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,

Line 245: p_ql_line_quote_price IN jtf_number_table := NULL,

241: p_ql_currency_code IN jtf_varchar2_table_100 := NULL,
242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,

Line 246: p_ql_related_item_id IN jtf_number_table := NULL,

242: p_ql_line_list_price IN jtf_number_table := NULL,
243: p_ql_line_adjusted_amount IN jtf_number_table := NULL,
244: p_ql_line_adjusted_percent IN jtf_number_table := NULL,
245: p_ql_line_quote_price IN jtf_number_table := NULL,
246: p_ql_related_item_id IN jtf_number_table := NULL,
247: p_ql_item_relationship_type IN jtf_varchar2_table_100 := NULL,
248: p_ql_split_shipment_flag IN jtf_varchar2_table_100 := NULL,
249: p_ql_backorder_flag IN jtf_varchar2_table_100 := NULL,
250: p_ql_selling_price_change IN jtf_varchar2_table_100 := NULL,

Line 273: p_ql_accounting_rule_id IN jtf_number_table := NULL,

269: p_ql_attribute17 IN jtf_varchar2_table_300 := NULL,
270: p_ql_attribute18 IN jtf_varchar2_table_300 := NULL,
271: p_ql_attribute19 IN jtf_varchar2_table_300 := NULL,
272: p_ql_attribute20 IN jtf_varchar2_table_300 := NULL,
273: p_ql_accounting_rule_id IN jtf_number_table := NULL,
274: p_ql_ffm_content_name IN jtf_varchar2_table_300 := NULL,
275: p_ql_ffm_content_type IN jtf_varchar2_table_300 := NULL,
276: p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
277: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,

Line 280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,

276: p_ql_ffm_document_type IN jtf_varchar2_table_300 := NULL,
277: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
278: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
279: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,

Line 281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,

277: p_ql_ffm_media_id IN jtf_varchar2_table_300 := NULL,
278: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
279: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,

Line 282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,

278: p_ql_ffm_media_type IN jtf_varchar2_table_300 := NULL,
279: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,

Line 283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,

279: p_ql_ffm_user_note IN jtf_varchar2_table_300 := NULL,
280: p_ql_invoice_to_party_id IN jtf_number_table := NULL,
281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,

Line 285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,

281: p_ql_invoice_to_party_site_id IN jtf_number_table := NULL,
282: p_ql_invoicing_rule_id IN jtf_number_table := NULL,
283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,

Line 287: p_ql_minisite_id IN jtf_number_table := NULL,

283: p_ql_marketing_source_code_id IN jtf_number_table := NULL,
284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,

Line 288: p_ql_section_id IN jtf_number_table := NULL,

284: p_ql_operation_code IN jtf_varchar2_table_100 := NULL,
285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,

Line 289: p_ql_priced_price_list_id IN jtf_number_table := NULL,

285: p_ql_invoice_to_cust_acct_id IN jtf_number_table := NULL,
286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,

Line 290: p_ql_agreement_id IN jtf_number_table := NULL,

286: p_ql_pricing_quantity_uom IN jtf_varchar2_table_100 := NULL,
287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:

Line 291: p_ql_commitment_id IN jtf_number_table := NULL,

287: p_ql_minisite_id IN jtf_number_table := NULL,
288: p_ql_section_id IN jtf_number_table := NULL,
289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */

Line 293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,

289: p_ql_priced_price_list_id IN jtf_number_table := NULL,
290: p_ql_agreement_id IN jtf_number_table := NULL,
291: p_ql_commitment_id IN jtf_number_table := NULL,
292: p_ql_display_arithmetic_op IN jtf_varchar2_table_100 := NULL,
293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,

Line 297: p_qls_qte_line_index IN jtf_number_table := NULL,

293: p_ql_invoice_to_cust_party_id IN jtf_number_table := NULL,
294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,
298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,

Line 298: p_qls_shipment_id IN jtf_number_table := NULL,

294:
295: /* parameters for quote shipment record ASO_QUOTE_PUB.Shipment_Tbl_Type */
296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,
298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,

Line 300: p_qls_created_by IN jtf_number_table := NULL,

296: p_qls_operation_code IN jtf_varchar2_table_100 := NULL,
297: p_qls_qte_line_index IN jtf_number_table := NULL,
298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,

Line 302: p_qls_last_updated_by IN jtf_number_table := NULL,

298: p_qls_shipment_id IN jtf_number_table := NULL,
299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,

Line 303: p_qls_last_update_login IN jtf_number_table := NULL,

299: p_qls_creation_date IN jtf_date_table := NULL,
300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,

Line 304: p_qls_request_id IN jtf_number_table := NULL,

300: p_qls_created_by IN jtf_number_table := NULL,
301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,
308: p_qls_quote_header_id IN jtf_number_table := NULL,

Line 305: p_qls_program_application_id IN jtf_number_table := NULL,

301: p_qls_last_update_date IN jtf_date_table := NULL,
302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,
308: p_qls_quote_header_id IN jtf_number_table := NULL,
309: p_qls_quote_line_id IN jtf_number_table := NULL,

Line 306: p_qls_program_id IN jtf_number_table := NULL,

302: p_qls_last_updated_by IN jtf_number_table := NULL,
303: p_qls_last_update_login IN jtf_number_table := NULL,
304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,
308: p_qls_quote_header_id IN jtf_number_table := NULL,
309: p_qls_quote_line_id IN jtf_number_table := NULL,
310: p_qls_promise_date IN jtf_date_table := NULL,

Line 308: p_qls_quote_header_id IN jtf_number_table := NULL,

304: p_qls_request_id IN jtf_number_table := NULL,
305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,
308: p_qls_quote_header_id IN jtf_number_table := NULL,
309: p_qls_quote_line_id IN jtf_number_table := NULL,
310: p_qls_promise_date IN jtf_date_table := NULL,
311: p_qls_request_date IN jtf_date_table := NULL,
312: p_qls_schedule_ship_date IN jtf_date_table := NULL,

Line 309: p_qls_quote_line_id IN jtf_number_table := NULL,

305: p_qls_program_application_id IN jtf_number_table := NULL,
306: p_qls_program_id IN jtf_number_table := NULL,
307: p_qls_program_update_date IN jtf_date_table := NULL,
308: p_qls_quote_header_id IN jtf_number_table := NULL,
309: p_qls_quote_line_id IN jtf_number_table := NULL,
310: p_qls_promise_date IN jtf_date_table := NULL,
311: p_qls_request_date IN jtf_date_table := NULL,
312: p_qls_schedule_ship_date IN jtf_date_table := NULL,
313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,

Line 313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,

309: p_qls_quote_line_id IN jtf_number_table := NULL,
310: p_qls_promise_date IN jtf_date_table := NULL,
311: p_qls_request_date IN jtf_date_table := NULL,
312: p_qls_schedule_ship_date IN jtf_date_table := NULL,
313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
314: p_qls_ship_to_party_id IN jtf_number_table := NULL,
315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,

Line 314: p_qls_ship_to_party_id IN jtf_number_table := NULL,

310: p_qls_promise_date IN jtf_date_table := NULL,
311: p_qls_request_date IN jtf_date_table := NULL,
312: p_qls_schedule_ship_date IN jtf_date_table := NULL,
313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
314: p_qls_ship_to_party_id IN jtf_number_table := NULL,
315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,

Line 315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,

311: p_qls_request_date IN jtf_date_table := NULL,
312: p_qls_schedule_ship_date IN jtf_date_table := NULL,
313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
314: p_qls_ship_to_party_id IN jtf_number_table := NULL,
315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,

Line 317: p_qls_ship_set_id IN jtf_number_table := NULL,

313: p_qls_ship_to_party_site_id IN jtf_number_table := NULL,
314: p_qls_ship_to_party_id IN jtf_number_table := NULL,
315: p_qls_ship_to_cust_account_id IN jtf_number_table := NULL,
316: p_qls_ship_partial_flag IN jtf_varchar2_table_300 := NULL,
317: p_qls_ship_set_id IN jtf_number_table := NULL,
318: p_qls_ship_method_code IN jtf_varchar2_table_100 := NULL,
319: p_qls_freight_terms_code IN jtf_varchar2_table_100 := NULL,
320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,

Line 324: p_qls_quantity IN jtf_number_table := NULL,

320: p_qls_freight_carrier_code IN jtf_varchar2_table_100 := NULL,
321: p_qls_fob_code IN jtf_varchar2_table_100 := NULL,
322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324: p_qls_quantity IN jtf_number_table := NULL,
325: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
326: p_qls_reservation_id IN jtf_number_table := NULL,
327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,

Line 326: p_qls_reservation_id IN jtf_number_table := NULL,

322: p_qls_shipping_instructions IN jtf_varchar2_table_2000 := NULL,
323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324: p_qls_quantity IN jtf_number_table := NULL,
325: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
326: p_qls_reservation_id IN jtf_number_table := NULL,
327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,

Line 327: p_qls_order_line_id IN jtf_number_table := NULL,

323: p_qls_packing_instructions IN jtf_varchar2_table_2000 := NULL,
324: p_qls_quantity IN jtf_number_table := NULL,
325: p_qls_reserved_quantity IN jtf_varchar2_table_300 := NULL,
326: p_qls_reservation_id IN jtf_number_table := NULL,
327: p_qls_order_line_id IN jtf_number_table := NULL,
328: p_qls_ship_to_party_name IN jtf_varchar2_table_300 := NULL,
329: p_qls_ship_to_cont_first_name IN jtf_varchar2_table_100 := NULL,
330: p_qls_ship_to_cont_mid_name IN jtf_varchar2_table_100 := NULL,
331: p_qls_ship_to_cont_last_name IN jtf_varchar2_table_100 := NULL,

Line 364: p_qls_ship_quote_price IN jtf_number_table := NULL,

360: p_qls_attribute17 IN jtf_varchar2_table_300 := NULL,
361: p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
362: p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
363: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
364: p_qls_ship_quote_price IN jtf_number_table := NULL,
365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,

Line 365: p_qls_pricing_quantity IN jtf_number_table := NULL,

361: p_qls_attribute18 IN jtf_varchar2_table_300 := NULL,
362: p_qls_attribute19 IN jtf_varchar2_table_300 := NULL,
363: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
364: p_qls_ship_quote_price IN jtf_number_table := NULL,
365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,

Line 367: p_qls_ship_from_org_id IN jtf_number_table := NULL,

363: p_qls_attribute20 IN jtf_varchar2_table_300 := NULL,
364: p_qls_ship_quote_price IN jtf_number_table := NULL,
365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,

Line 368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,

364: p_qls_ship_quote_price IN jtf_number_table := NULL,
365: p_qls_pricing_quantity IN jtf_number_table := NULL,
366: p_qls_shipment_priority_code IN jtf_varchar2_table_100 := NULL,
367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */

Line 371: p_qls_object_version_number IN jtf_number_table := NULL,

367: p_qls_ship_from_org_id IN jtf_number_table := NULL,
368: p_qls_ship_to_cust_party_id IN jtf_number_table := NULL,
369: p_qls_request_date_type IN jtf_varchar2_table_100 := NULL,
370: p_qls_demand_class_code IN jtf_varchar2_table_100 := NULL,
371: p_qls_object_version_number IN jtf_number_table := NULL,
372: /* Standard IN parameters */
373: P_API_VERSION_NUMBER IN NUMBER := 1,
374: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_TRUE,
375: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,

Line 396: l_ship_site_use_id JTF_NUMBER_TABLE := NULL;

392: := ASO_QUOTE_PUB.G_MISS_Shipment_TBL;
393:
394: lx_ln_atp_tbl ASO_ATP_INT.Atp_Tbl_Typ;
395:
396: l_ship_site_use_id JTF_NUMBER_TABLE := NULL;
397:
398: l_qls_ship_to_party_site_id JTF_NUMBER_TABLE := NULL;
399: l_qls_ship_to_cust_account_id JTF_NUMBER_TABLE := NULL;
400: ddindx binary_integer;

Line 398: l_qls_ship_to_party_site_id JTF_NUMBER_TABLE := NULL;

394: lx_ln_atp_tbl ASO_ATP_INT.Atp_Tbl_Typ;
395:
396: l_ship_site_use_id JTF_NUMBER_TABLE := NULL;
397:
398: l_qls_ship_to_party_site_id JTF_NUMBER_TABLE := NULL;
399: l_qls_ship_to_cust_account_id JTF_NUMBER_TABLE := NULL;
400: ddindx binary_integer;
401: indx binary_integer;
402: l_debug VARCHAR2(1);

Line 399: l_qls_ship_to_cust_account_id JTF_NUMBER_TABLE := NULL;

395:
396: l_ship_site_use_id JTF_NUMBER_TABLE := NULL;
397:
398: l_qls_ship_to_party_site_id JTF_NUMBER_TABLE := NULL;
399: l_qls_ship_to_cust_account_id JTF_NUMBER_TABLE := NULL;
400: ddindx binary_integer;
401: indx binary_integer;
402: l_debug VARCHAR2(1);
403:

Line 420: l_ship_site_use_id := JTF_NUMBER_TABLE();

416: ASO_QUOTE_UTIL_PVT.Enable_Debug_Pvt;
417: END IF;
418: l_qls_ship_to_party_site_id := p_qls_ship_to_party_site_id;
419: l_qls_ship_to_cust_account_id := p_qls_ship_to_cust_account_id;
420: l_ship_site_use_id := JTF_NUMBER_TABLE();
421:
422: -- Workaround: set ship_to_party_site_id to ship_to_site_use_id: this is
423: -- because of a bug in ASO ATP
424: IF l_qls_ship_to_party_site_id IS NOT NULL AND l_qls_ship_to_party_site_id.count > 0