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

Line 889: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,

885: (
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY VARCHAR2,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: x_quote_line_id OUT NOCOPY JTF_NUMBER_TABLE,
890: x_changed_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
891: x_valid_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
892: x_complete_flag OUT NOCOPY JTF_VARCHAR2_TABLE_100,
893: p_quote_header_id IN NUMBER :=FND_API.G_MISS_NUM,

Line 1205: p_qp_qte_line_index IN jtf_number_table := NULL,

1201: p_qs_demand_class_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1202: p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
1203: -- hd payment record
1204: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
1205: p_qp_qte_line_index IN jtf_number_table := NULL,
1206: p_qp_payment_id IN jtf_number_table := NULL,
1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,

Line 1206: p_qp_payment_id IN jtf_number_table := NULL,

1202: p_qs_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
1203: -- hd payment record
1204: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
1205: p_qp_qte_line_index IN jtf_number_table := NULL,
1206: p_qp_payment_id IN jtf_number_table := NULL,
1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,

Line 1208: p_qp_created_by IN jtf_number_table := NULL,

1204: p_qp_operation_code IN jtf_varchar2_table_100 := NULL,
1205: p_qp_qte_line_index IN jtf_number_table := NULL,
1206: p_qp_payment_id IN jtf_number_table := NULL,
1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,

Line 1210: p_qp_last_updated_by IN jtf_number_table := NULL,

1206: p_qp_payment_id IN jtf_number_table := NULL,
1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,

Line 1211: p_qp_last_update_login IN jtf_number_table := NULL,

1207: p_qp_creation_date IN jtf_date_table := NULL,
1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,

Line 1212: p_qp_request_id IN jtf_number_table := NULL,

1208: p_qp_created_by IN jtf_number_table := NULL,
1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,

Line 1213: p_qp_program_application_id IN jtf_number_table := NULL,

1209: p_qp_last_update_date IN jtf_date_table := NULL,
1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,
1217: p_qp_quote_line_id IN jtf_number_table := NULL,

Line 1214: p_qp_program_id IN jtf_number_table := NULL,

1210: p_qp_last_updated_by IN jtf_number_table := NULL,
1211: p_qp_last_update_login IN jtf_number_table := NULL,
1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,
1217: p_qp_quote_line_id IN jtf_number_table := NULL,
1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,

Line 1216: p_qp_quote_header_id IN jtf_number_table := NULL,

1212: p_qp_request_id IN jtf_number_table := NULL,
1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,
1217: p_qp_quote_line_id IN jtf_number_table := NULL,
1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,

Line 1217: p_qp_quote_line_id IN jtf_number_table := NULL,

1213: p_qp_program_application_id IN jtf_number_table := NULL,
1214: p_qp_program_id IN jtf_number_table := NULL,
1215: p_qp_program_update_date IN jtf_date_table := NULL,
1216: p_qp_quote_header_id IN jtf_number_table := NULL,
1217: p_qp_quote_line_id IN jtf_number_table := NULL,
1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221: p_qp_payment_term_id IN jtf_number_table := NULL,

Line 1221: p_qp_payment_term_id IN jtf_number_table := NULL,

1217: p_qp_quote_line_id IN jtf_number_table := NULL,
1218: p_qp_payment_type_code IN jtf_varchar2_table_100 := NULL,
1219: p_qp_payment_ref_number IN jtf_varchar2_table_300 := NULL,
1220: p_qp_payment_option IN jtf_varchar2_table_300 := NULL,
1221: p_qp_payment_term_id IN jtf_number_table := NULL,
1222: p_qp_credit_card_code IN jtf_varchar2_table_100 := NULL,
1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,

Line 1227: p_qp_payment_amount IN jtf_number_table := NULL,

1223: p_qp_credit_card_holder_name IN jtf_varchar2_table_100 := NULL,
1224: p_qp_credit_card_exp_date IN jtf_date_table := NULL,
1225: p_qp_credit_card_aprv_code IN jtf_varchar2_table_100 := NULL,
1226: p_qp_credit_card_aprv_date IN jtf_date_table := NULL,
1227: p_qp_payment_amount IN jtf_number_table := NULL,
1228: p_qp_attribute_category IN jtf_varchar2_table_100 := NULL,
1229: p_qp_attribute1 IN jtf_varchar2_table_300 := NULL,
1230: p_qp_attribute2 IN jtf_varchar2_table_300 := NULL,
1231: p_qp_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 1249: p_qp_shipment_index IN jtf_number_table := NULL,

1245: p_qp_attribute17 IN jtf_varchar2_table_300 := NULL,
1246: p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
1247: p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
1248: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
1249: p_qp_shipment_index IN jtf_number_table := NULL,
1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,

Line 1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,

1246: p_qp_attribute18 IN jtf_varchar2_table_300 := NULL,
1247: p_qp_attribute19 IN jtf_varchar2_table_300 := NULL,
1248: p_qp_attribute20 IN jtf_varchar2_table_300 := NULL,
1249: p_qp_shipment_index IN jtf_number_table := NULL,
1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,

Line 1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,

1249: p_qp_shipment_index IN jtf_number_table := NULL,
1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,

Line 1254: p_qp_instrument_id IN jtf_number_table := NULL,

1250: p_qp_quote_shipment_id IN jtf_number_table := NULL,
1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes

Line 1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,

1251: p_qp_cust_po_number IN jtf_varchar2_table_100 := NULL,
1252: p_qp_cust_po_line_number IN jtf_varchar2_table_100 := NULL,
1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,

Line 1257: p_qp_object_version_number IN jtf_number_table := NULL,

1253: p_qp_trxn_extension_id IN jtf_number_table := NULL,
1254: p_qp_instrument_id IN jtf_number_table := NULL,
1255: p_qp_instr_assignment_id IN jtf_number_table := NULL,
1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,
1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,

Line 1260: p_qpa_qte_line_index IN jtf_number_table := NULL,

1256: p_qp_cvv2 IN jtf_varchar2_table_100 := NULL,
1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,
1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,

Line 1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,

1257: p_qp_object_version_number IN jtf_number_table := NULL,
1258: -- hd price attributes
1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,
1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,

Line 1263: p_qpa_created_by IN jtf_number_table := NULL,

1259: p_qpa_operation_code IN jtf_varchar2_table_100 := NULL,
1260: p_qpa_qte_line_index IN jtf_number_table := NULL,
1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,

Line 1265: p_qpa_last_updated_by IN jtf_number_table := NULL,

1261: p_qpa_price_attribute_id IN jtf_number_table := NULL,
1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,

Line 1266: p_qpa_last_update_login IN jtf_number_table := NULL,

1262: p_qpa_creation_date IN jtf_date_table := NULL,
1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,

Line 1267: p_qpa_request_id IN jtf_number_table := NULL,

1263: p_qpa_created_by IN jtf_number_table := NULL,
1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,

Line 1268: p_qpa_program_application_id IN jtf_number_table := NULL,

1264: p_qpa_last_update_date IN jtf_date_table := NULL,
1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,

Line 1269: p_qpa_program_id IN jtf_number_table := NULL,

1265: p_qpa_last_updated_by IN jtf_number_table := NULL,
1266: p_qpa_last_update_login IN jtf_number_table := NULL,
1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,
1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,

Line 1271: p_qpa_quote_header_id IN jtf_number_table := NULL,

1267: p_qpa_request_id IN jtf_number_table := NULL,
1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,
1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
1274: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
1275: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 1272: p_qpa_quote_line_id IN jtf_number_table := NULL,

1268: p_qpa_program_application_id IN jtf_number_table := NULL,
1269: p_qpa_program_id IN jtf_number_table := NULL,
1270: p_qpa_program_update_date IN jtf_date_table := NULL,
1271: p_qpa_quote_header_id IN jtf_number_table := NULL,
1272: p_qpa_quote_line_id IN jtf_number_table := NULL,
1273: p_qpa_flex_title IN jtf_varchar2_table_100 := NULL,
1274: p_qpa_pricing_context IN jtf_varchar2_table_100 := NULL,
1275: p_qpa_pricing_attribute1 IN jtf_varchar2_table_300 := NULL,
1276: p_qpa_pricing_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 1396: p_qpa_object_version_number IN jtf_number_table := NULL,

1392: p_qpa_attribute17 IN jtf_varchar2_table_300 := NULL,
1393: p_qpa_attribute18 IN jtf_varchar2_table_300 := NULL,
1394: p_qpa_attribute19 IN jtf_varchar2_table_300 := NULL,
1395: p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
1396: p_qpa_object_version_number IN jtf_number_table := NULL,
1397: --hd tax details
1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,

Line 1399: p_qt_qte_line_index IN jtf_number_table := NULL,

1395: p_qpa_attribute20 IN jtf_varchar2_table_300 := NULL,
1396: p_qpa_object_version_number IN jtf_number_table := NULL,
1397: --hd tax details
1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,

Line 1400: p_qt_shipment_index IN jtf_number_table := NULL,

1396: p_qpa_object_version_number IN jtf_number_table := NULL,
1397: --hd tax details
1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,

Line 1401: p_qt_tax_detail_id IN jtf_number_table := NULL,

1397: --hd tax details
1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,

Line 1402: p_qt_quote_header_id IN jtf_number_table := NULL,

1398: p_qt_operation_code IN jtf_varchar2_table_100 := NULL,
1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,

Line 1403: p_qt_quote_line_id IN jtf_number_table := NULL,

1399: p_qt_qte_line_index IN jtf_number_table := NULL,
1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,

Line 1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,

1400: p_qt_shipment_index IN jtf_number_table := NULL,
1401: p_qt_tax_detail_id IN jtf_number_table := NULL,
1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,

Line 1406: p_qt_created_by IN jtf_number_table := NULL,

1402: p_qt_quote_header_id IN jtf_number_table := NULL,
1403: p_qt_quote_line_id IN jtf_number_table := NULL,
1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,

Line 1408: p_qt_last_updated_by IN jtf_number_table := NULL,

1404: p_qt_quote_shipment_id IN jtf_number_table := NULL,
1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,
1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,

Line 1409: p_qt_last_update_login IN jtf_number_table := NULL,

1405: p_qt_creation_date IN jtf_date_table := NULL,
1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,
1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,

Line 1410: p_qt_request_id IN jtf_number_table := NULL,

1406: p_qt_created_by IN jtf_number_table := NULL,
1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,
1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,
1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,

Line 1411: p_qt_program_application_id IN jtf_number_table := NULL,

1407: p_qt_last_update_date IN jtf_date_table := NULL,
1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,
1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,
1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,

Line 1412: p_qt_program_id IN jtf_number_table := NULL,

1408: p_qt_last_updated_by IN jtf_number_table := NULL,
1409: p_qt_last_update_login IN jtf_number_table := NULL,
1410: p_qt_request_id IN jtf_number_table := NULL,
1411: p_qt_program_application_id IN jtf_number_table := NULL,
1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,
1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416: p_qt_tax_rate IN jtf_number_table := NULL,

Line 1416: p_qt_tax_rate IN jtf_number_table := NULL,

1412: p_qt_program_id IN jtf_number_table := NULL,
1413: p_qt_program_update_date IN jtf_date_table := NULL,
1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416: p_qt_tax_rate IN jtf_number_table := NULL,
1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,

Line 1418: p_qt_tax_amount IN jtf_number_table := NULL,

1414: p_qt_orig_tax_code IN jtf_varchar2_table_300 := NULL,
1415: p_qt_tax_code IN jtf_varchar2_table_100 := NULL,
1416: p_qt_tax_rate IN jtf_number_table := NULL,
1417: p_qt_tax_date IN jtf_date_table := NULL,
1418: p_qt_tax_amount IN jtf_number_table := NULL,
1419: p_qt_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1420: p_qt_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1421: p_qt_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1422: p_qt_attribute_category IN jtf_varchar2_table_100 := NULL,

Line 1443: p_qt_object_version_number IN jtf_number_table := NULL,

1439: p_qt_attribute17 IN jtf_varchar2_table_300 := NULL,
1440: p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
1441: p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
1442: p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
1443: p_qt_object_version_number IN jtf_number_table := NULL,
1444: p_qt_tax_rate_id IN jtf_number_table := NULL,
1445: -- qh sales credit recore
1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,

Line 1444: p_qt_tax_rate_id IN jtf_number_table := NULL,

1440: p_qt_attribute18 IN jtf_varchar2_table_300 := NULL,
1441: p_qt_attribute19 IN jtf_varchar2_table_300 := NULL,
1442: p_qt_attribute20 IN jtf_varchar2_table_300 := NULL,
1443: p_qt_object_version_number IN jtf_number_table := NULL,
1444: p_qt_tax_rate_id IN jtf_number_table := NULL,
1445: -- qh sales credit recore
1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,
1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,

Line 1447: p_qsc_qte_line_index IN jtf_number_table := NULL,

1443: p_qt_object_version_number IN jtf_number_table := NULL,
1444: p_qt_tax_rate_id IN jtf_number_table := NULL,
1445: -- qh sales credit recore
1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,
1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,
1449: p_qsc_creation_date IN jtf_date_table := NULL,
1450: p_qsc_created_by IN jtf_number_table := NULL,
1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,

Line 1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,

1444: p_qt_tax_rate_id IN jtf_number_table := NULL,
1445: -- qh sales credit recore
1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,
1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,
1449: p_qsc_creation_date IN jtf_date_table := NULL,
1450: p_qsc_created_by IN jtf_number_table := NULL,
1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452: p_qsc_last_update_date IN jtf_date_table := NULL,

Line 1450: p_qsc_created_by IN jtf_number_table := NULL,

1446: p_qsc_operation_code IN jtf_varchar2_table_100 := NULL,
1447: p_qsc_qte_line_index IN jtf_number_table := NULL,
1448: p_qsc_sales_credit_id IN jtf_number_table := NULL,
1449: p_qsc_creation_date IN jtf_date_table := NULL,
1450: p_qsc_created_by IN jtf_number_table := NULL,
1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452: p_qsc_last_update_date IN jtf_date_table := NULL,
1453: p_qsc_last_update_login IN jtf_number_table := NULL,
1454: p_qsc_request_id IN jtf_number_table := NULL,

Line 1453: p_qsc_last_update_login IN jtf_number_table := NULL,

1449: p_qsc_creation_date IN jtf_date_table := NULL,
1450: p_qsc_created_by IN jtf_number_table := NULL,
1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452: p_qsc_last_update_date IN jtf_date_table := NULL,
1453: p_qsc_last_update_login IN jtf_number_table := NULL,
1454: p_qsc_request_id IN jtf_number_table := NULL,
1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,

Line 1454: p_qsc_request_id IN jtf_number_table := NULL,

1450: p_qsc_created_by IN jtf_number_table := NULL,
1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452: p_qsc_last_update_date IN jtf_date_table := NULL,
1453: p_qsc_last_update_login IN jtf_number_table := NULL,
1454: p_qsc_request_id IN jtf_number_table := NULL,
1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,

Line 1455: p_qsc_program_application_id IN jtf_number_table := NULL,

1451: p_qsc_last_updated_by IN jtf_varchar2_table_300 := NULL,
1452: p_qsc_last_update_date IN jtf_date_table := NULL,
1453: p_qsc_last_update_login IN jtf_number_table := NULL,
1454: p_qsc_request_id IN jtf_number_table := NULL,
1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,

Line 1456: p_qsc_program_id IN jtf_number_table := NULL,

1452: p_qsc_last_update_date IN jtf_date_table := NULL,
1453: p_qsc_last_update_login IN jtf_number_table := NULL,
1454: p_qsc_request_id IN jtf_number_table := NULL,
1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,
1460: p_qsc_percent IN jtf_number_table := NULL,

Line 1458: p_qsc_quote_header_id IN jtf_number_table := NULL,

1454: p_qsc_request_id IN jtf_number_table := NULL,
1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,
1460: p_qsc_percent IN jtf_number_table := NULL,
1461: p_qsc_resource_id IN jtf_number_table := NULL,
1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,

Line 1459: p_qsc_quote_line_id IN jtf_number_table := NULL,

1455: p_qsc_program_application_id IN jtf_number_table := NULL,
1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,
1460: p_qsc_percent IN jtf_number_table := NULL,
1461: p_qsc_resource_id IN jtf_number_table := NULL,
1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,

Line 1460: p_qsc_percent IN jtf_number_table := NULL,

1456: p_qsc_program_id IN jtf_number_table := NULL,
1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,
1460: p_qsc_percent IN jtf_number_table := NULL,
1461: p_qsc_resource_id IN jtf_number_table := NULL,
1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,

Line 1461: p_qsc_resource_id IN jtf_number_table := NULL,

1457: p_qsc_program_update_date IN jtf_date_table := NULL,
1458: p_qsc_quote_header_id IN jtf_number_table := NULL,
1459: p_qsc_quote_line_id IN jtf_number_table := NULL,
1460: p_qsc_percent IN jtf_number_table := NULL,
1461: p_qsc_resource_id IN jtf_number_table := NULL,
1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465: p_qsc_resource_group_id IN jtf_number_table := NULL,

Line 1465: p_qsc_resource_group_id IN jtf_number_table := NULL,

1461: p_qsc_resource_id IN jtf_number_table := NULL,
1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465: p_qsc_resource_group_id IN jtf_number_table := NULL,
1466: p_qsc_employee_person_id IN jtf_number_table := NULL,
1467: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
1468: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
1469: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,

Line 1466: p_qsc_employee_person_id IN jtf_number_table := NULL,

1462: p_qsc_first_name IN jtf_varchar2_table_300 := NULL,
1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465: p_qsc_resource_group_id IN jtf_number_table := NULL,
1466: p_qsc_employee_person_id IN jtf_number_table := NULL,
1467: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
1468: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
1469: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
1470: p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,

Line 1467: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,

1463: p_qsc_last_name IN jtf_varchar2_table_300 := NULL,
1464: p_qsc_sales_credit_type IN jtf_varchar2_table_300 := NULL,
1465: p_qsc_resource_group_id IN jtf_number_table := NULL,
1466: p_qsc_employee_person_id IN jtf_number_table := NULL,
1467: p_qsc_sales_credit_type_id IN jtf_number_table := NULL,
1468: p_qsc_attribute_category IN jtf_varchar2_table_100 := NULL,
1469: p_qsc_attribute1 IN jtf_varchar2_table_300 := NULL,
1470: p_qsc_attribute2 IN jtf_varchar2_table_300 := NULL,
1471: p_qsc_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,

1486: p_qsc_attribute18 IN jtf_varchar2_table_300 := NULL,
1487: p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
1488: p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
1489: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,

Line 1491: p_qsc_object_version_number IN jtf_number_table := NULL,

1487: p_qsc_attribute19 IN jtf_varchar2_table_300 := NULL,
1488: p_qsc_attribute20 IN jtf_varchar2_table_300 := NULL,
1489: p_qsc_system_assigned_flag IN jtf_varchar2_table_100 := NULL,
1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,

Line 1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,

1490: p_qsc_credit_rule_id IN jtf_number_table := NULL,
1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,

Line 1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,

1491: p_qsc_object_version_number IN jtf_number_table := NULL,
1492: -- price adjustment record
1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,

Line 1497: p_qlpaj_created_by IN jtf_number_table := NULL,

1493: p_qlpaj_operation_code IN jtf_varchar2_table_100 := NULL,
1494: p_qlpaj_qte_line_index IN jtf_number_table := NULL,
1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,

Line 1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,

1495: p_qlpaj_price_adjustment_id IN jtf_number_table := NULL,
1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,

Line 1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,

1496: p_qlpaj_creation_date IN jtf_date_table := NULL,
1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,

Line 1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,

1497: p_qlpaj_created_by IN jtf_number_table := NULL,
1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,

Line 1502: p_qlpaj_program_id IN jtf_number_table := NULL,

1498: p_qlpaj_last_update_date IN jtf_date_table := NULL,
1499: p_qlpaj_last_updated_by IN jtf_number_table := NULL,
1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,

Line 1504: p_qlpaj_request_id IN jtf_number_table := NULL,

1500: p_qlpaj_last_update_login IN jtf_number_table := NULL,
1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,

Line 1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,

1501: p_qlpaj_program_application_id IN jtf_number_table := NULL,
1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,

Line 1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,

1502: p_qlpaj_program_id IN jtf_number_table := NULL,
1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,

Line 1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,

1503: p_qlpaj_program_update_date IN jtf_date_table := NULL,
1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,

Line 1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,

1504: p_qlpaj_request_id IN jtf_number_table := NULL,
1505: p_qlpaj_quote_header_id IN jtf_number_table := NULL,
1506: p_qlpaj_quote_line_id IN jtf_number_table := NULL,
1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,

Line 1511: p_qlpaj_modified_from IN jtf_number_table := NULL,

1507: p_qlpaj_modifier_header_id IN jtf_number_table := NULL,
1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,

Line 1512: p_qlpaj_modified_to IN jtf_number_table := NULL,

1508: p_qlpaj_modifier_line_id IN jtf_number_table := NULL,
1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,

Line 1513: p_qlpaj_operand IN jtf_number_table := NULL,

1509: p_qlpaj_mod_line_type_code IN jtf_varchar2_table_100 := NULL,
1510: p_qlpaj_mod_mech_type_code IN jtf_varchar2_table_100 := NULL,
1511: p_qlpaj_modified_from IN jtf_number_table := NULL,
1512: p_qlpaj_modified_to IN jtf_number_table := NULL,
1513: p_qlpaj_operand IN jtf_number_table := NULL,
1514: p_qlpaj_arithmetic_operator IN jtf_varchar2_table_100 := NULL,
1515: p_qlpaj_automatic_flag IN jtf_varchar2_table_100 := NULL,
1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,

Line 1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,

1516: p_qlpaj_update_allowable_flag IN jtf_varchar2_table_100 := NULL,
1517: p_qlpaj_updated_flag IN jtf_varchar2_table_100 := NULL,
1518: p_qlpaj_applied_flag IN jtf_varchar2_table_100 := NULL,
1519: p_qlpaj_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1520: p_qlpaj_pricing_phase_id IN jtf_number_table := NULL,
1521: p_qlpaj_attribute_category IN jtf_varchar2_table_100 := NULL,
1522: p_qlpaj_attribute1 IN jtf_varchar2_table_300 := NULL,
1523: p_qlpaj_attribute2 IN jtf_varchar2_table_300 := NULL,
1524: p_qlpaj_attribute3 IN jtf_varchar2_table_300 := NULL,

Line 1547: p_qlpaj_cost_id IN jtf_number_table := NULL,

1543: p_qlpaj_change_sequence IN jtf_varchar2_table_100 := NULL,
1544: p_qlpaj_update_allowed IN jtf_varchar2_table_100 := NULL,
1545: p_qlpaj_change_reason_code IN jtf_varchar2_table_100 := NULL,
1546: p_qlpaj_change_reason_text IN jtf_varchar2_table_2000 := NULL,
1547: p_qlpaj_cost_id IN jtf_number_table := NULL,
1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,

Line 1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,

1548: p_qlpaj_tax_code IN jtf_varchar2_table_100 := NULL,
1549: p_qlpaj_tax_exempt_flag IN jtf_varchar2_table_100 := NULL,
1550: p_qlpaj_tax_exempt_number IN jtf_varchar2_table_100 := NULL,
1551: p_qlpaj_tax_exempt_reason_code IN jtf_varchar2_table_100 := NULL,
1552: p_qlpaj_parent_adjustment_id IN jtf_number_table := NULL,
1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,

Line 1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,

1553: p_qlpaj_invoiced_flag IN jtf_varchar2_table_100 := NULL,
1554: p_qlpaj_estimated_flag IN jtf_varchar2_table_100 := NULL,
1555: p_qlpaj_inc_in_sales_perfce IN jtf_varchar2_table_100 := NULL,
1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,

Line 1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,

1556: p_qlpaj_split_action_code IN jtf_varchar2_table_100 := NULL,
1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,

Line 1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,

1557: p_qlpaj_adjusted_amount IN jtf_number_table := NULL,
1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,

Line 1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,

1558: p_qlpaj_charge_type_code IN jtf_varchar2_table_100 := NULL,
1559: p_qlpaj_charge_subtype_code IN jtf_varchar2_table_100 := NULL,
1560: p_qlpaj_range_break_quantity IN jtf_number_table := NULL,
1561: p_qlpaj_accrual_conv_rate IN jtf_number_table := NULL,
1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,

Line 1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,

1562: p_qlpaj_pricing_group_sequence IN jtf_number_table := NULL,
1563: p_qlpaj_accrual_flag IN jtf_varchar2_table_100 := NULL,
1564: p_qlpaj_list_line_no IN jtf_varchar2_table_300 := NULL,
1565: p_qlpaj_source_system_code IN jtf_varchar2_table_100 := NULL,
1566: p_qlpaj_benefit_qty IN jtf_number_table := NULL,
1567: p_qlpaj_benefit_uom_code IN jtf_varchar2_table_100 := NULL,
1568: p_qlpaj_print_on_invoice_flag IN jtf_varchar2_table_100 := NULL,
1569: p_qlpaj_expiration_date IN jtf_date_table := NULL,
1570: p_qlpaj_rebate_trans_type_code IN jtf_varchar2_table_100 := NULL,

Line 1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,

1577: p_qlpaj_substitution_attribute IN jtf_varchar2_table_100 := NULL,
1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1584: p_api_version_number IN NUMBER := 1 ,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

Line 1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,

1578: p_qlpaj_proration_type_code IN jtf_varchar2_table_100 := NULL,
1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1584: p_api_version_number IN NUMBER := 1 ,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

Line 1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,

1579: p_qlpaj_include_on_ret_flag IN jtf_varchar2_table_100 := NULL,
1580: p_qlpaj_credit_or_charge_flag IN jtf_varchar2_table_100 := NULL,
1581: p_qlpaj_shipment_index IN jtf_number_table := NULL,
1582: p_qlpaj_quote_shipment_id IN jtf_number_table := NULL,
1583: p_qlpaj_object_version_number IN jtf_number_table := NULL,
1584: p_api_version_number IN NUMBER := 1 ,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1587: x_return_status OUT NOCOPY VARCHAR2 ,