[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
,p_LAST_UPDATE_DATE IN jtf_date_table := NULL
,p_LAST_UPDATED_BY IN jtf_number_table := NULL
,p_LAST_UPDATE_LOGIN IN jtf_number_table := NULL
,p_PROGRAM_APPLICATION_ID IN jtf_number_table := NULL
,p_PROGRAM_ID IN jtf_number_table := NULL
,p_PROGRAM_UPDATE_DATE IN jtf_date_table := NULL
,p_REQUEST_ID IN jtf_number_table := NULL
,p_TOP_MODEL_LINE_ID IN jtf_number_table := NULL
,p_LINK_TO_LINE_ID IN jtf_number_table := NULL
,p_COMPONENT_SEQUENCE_ID IN jtf_number_table := NULL
,p_COMPONENT_CODE IN jtf_varchar2_table_300 := NULL
,p_CONFIG_DISPLAY_SEQUENCE IN jtf_number_table := NULL
,p_SORT_ORDER IN jtf_varchar2_table_300 := NULL
,p_ITEM_TYPE_CODE IN jtf_varchar2_table_100 := NULL
,p_OPTION_NUMBER IN jtf_number_table := NULL
,p_OPTION_FLAG IN jtf_varchar2_table_100 := NULL
,p_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 := NULL
,p_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 := NULL
,p_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 := NULL
,p_ACTUAL_SHIPMENT_DATE IN jtf_date_table := NULL
,p_CUSTOMER_TRX_LINE_ID IN jtf_number_table := NULL
,p_RETURN_CONTEXT IN jtf_varchar2_table_100 := NULL
,p_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
,p_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
,p_ACTUAL_ARRIVAL_DATE IN jtf_date_table := NULL
,p_ATO_LINE_ID IN jtf_number_table := NULL
,p_AUTO_SELECTED_QUANTITY IN jtf_number_table := NULL
,p_COMPONENT_NUMBER IN jtf_number_table := NULL
,p_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table := NULL
,p_EXPLOSION_DATE IN jtf_date_table := NULL
,p_LATEST_ACCEPTABLE_DATE IN jtf_date_table := NULL
,p_MODEL_GROUP_NUMBER IN jtf_number_table := NULL
,p_SCHEDULE_ARRIVAL_DATE IN jtf_date_table := NULL
,p_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 := NULL
,p_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 := NULL
,p_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 := NULL
,p_CANCELLED_FLAG IN jtf_varchar2_table_100 := NULL
,p_OPEN_FLAG IN jtf_varchar2_table_100 := NULL
,p_BOOKED_FLAG IN jtf_varchar2_table_100 := NULL
,p_SALESREP_ID IN jtf_number_table := NULL
,p_RETURN_REASON_CODE IN jtf_varchar2_table_100 := NULL
,p_ARRIVAL_SET_ID IN jtf_number_table := NULL
,p_SHIP_SET_ID IN jtf_number_table := NULL
,p_SPLIT_FROM_LINE_ID IN jtf_number_table := NULL
,p_CUST_PRODUCTION_SEQ_NUM IN jtf_varchar2_table_100 := NULL
,p_AUTHORIZED_TO_SHIP_FLAG IN jtf_varchar2_table_300 := NULL
,p_OVER_SHIP_REASON_CODE IN jtf_varchar2_table_100 := NULL
,p_OVER_SHIP_RESOLVED_FLAG IN jtf_varchar2_table_100 := NULL
,p_ORDERED_ITEM_ID IN jtf_number_table := NULL
,p_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 := NULL
,p_CONFIGURATION_ID IN jtf_number_table := NULL
,p_COMMITMENT_ID IN jtf_number_table := NULL
,p_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 := NULL
,p_CREDIT_INVOICE_LINE_ID IN jtf_number_table := NULL
,p_FIRST_ACK_CODE IN jtf_varchar2_table_100 := NULL
,p_FIRST_ACK_DATE IN jtf_date_table := NULL
,p_LAST_ACK_CODE IN jtf_varchar2_table_100 := NULL
,p_LAST_ACK_DATE IN jtf_date_table := NULL
,p_PLANNING_PRIORITY IN jtf_number_table := NULL
,p_ORDER_SOURCE_ID IN jtf_number_table := NULL
,p_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 := NULL
,p_CHANGE_SEQUENCE IN jtf_varchar2_table_100 := NULL
,p_DROP_SHIP_FLAG IN jtf_varchar2_table_100 := NULL
,p_CUSTOMER_LINE_NUMBER IN jtf_varchar2_table_100 := NULL
,p_CUSTOMER_SHIPMENT_NUMBER IN jtf_varchar2_table_100 := NULL
,p_CUSTOMER_ITEM_NET_PRICE IN jtf_number_table := NULL
,p_CUSTOMER_PAYMENT_TERM_ID IN jtf_number_table := NULL
,p_FULFILLED_FLAG IN jtf_varchar2_table_100 := NULL
,p_END_ITEM_UNIT_NUMBER IN jtf_varchar2_table_100 := NULL
,p_CONFIG_HEADER_ID IN jtf_number_table := NULL
,p_CONFIG_REV_NBR IN jtf_number_table := NULL
,p_MFG_COMPONENT_SEQUENCE_ID IN jtf_number_table := NULL
,p_SHIPPING_INSTRUCTIONS IN jtf_varchar2_table_300 := NULL
,p_PACKING_INSTRUCTIONS IN jtf_varchar2_table_300 := NULL
,p_INVOICED_QUANTITY IN jtf_number_table := NULL
,p_REF_CUSTOMER_TRX_LINE_ID IN jtf_number_table := NULL
,p_SPLIT_BY IN jtf_varchar2_table_300 := NULL
,p_LINE_SET_ID IN jtf_number_table := NULL
,p_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 := NULL
,p_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 := NULL
,p_SERVICE_DURATION IN jtf_number_table := NULL
,p_SERVICE_START_DATE IN jtf_date_table := NULL
,p_SERVICE_END_DATE IN jtf_date_table := NULL
,p_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 := NULL
,p_UNIT_LIST_PERCENT IN jtf_number_table := NULL
,p_UNIT_SELLING_PERCENT IN jtf_number_table := NULL
,p_UNIT_PERCENT_BASE_PRICE IN jtf_number_table := NULL
,p_SERVICE_NUMBER IN jtf_number_table := NULL
,p_SERVICE_PERIOD IN jtf_varchar2_table_100 := NULL
,p_SHIPPABLE_FLAG IN jtf_varchar2_table_100 := NULL
,p_MODEL_REMNANT_FLAG IN jtf_varchar2_table_100 := NULL
,p_RE_SOURCE_FLAG IN jtf_varchar2_table_300 := NULL
,p_FLOW_STATUS_CODE IN jtf_varchar2_table_100 := NULL
,p_TP_CONTEXT IN jtf_varchar2_table_100 := NULL
,p_TP_ATTRIBUTE1 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE2 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE3 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE4 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE5 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE6 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE7 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE8 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE9 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE10 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE11 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE12 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE13 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE14 IN jtf_varchar2_table_300 := NULL
,p_TP_ATTRIBUTE15 IN jtf_varchar2_table_300 := NULL
,p_FULFILLMENT_METHOD_CODE IN jtf_varchar2_table_300 := NULL
,p_MARKETING_SOURCE_CODE_ID IN jtf_number_table := NULL
,p_SERVICE_REF_TYPE_CODE IN jtf_varchar2_table_100 := NULL
,p_SERVICE_REFERENCE_LINE_ID IN jtf_number_table := NULL
,p_SERVICE_REF_SYSTEM_ID IN jtf_number_table := NULL
,p_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 := NULL
,p_UPGRADED_FLAG IN jtf_varchar2_table_100 := NULL
,p_REVENUE_AMOUNT IN jtf_number_table := NULL
,p_FULFILLMENT_DATE IN jtf_date_table := NULL
,p_PREFERRED_GRADE IN jtf_varchar2_table_100 := NULL
,p_ORDERED_QUANTITY2 IN jtf_number_table := NULL
,p_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 := NULL
,p_SHIPPING_QUANTITY2 IN jtf_number_table := NULL
,p_CANCELLED_QUANTITY2 IN jtf_number_table := NULL
,p_SHIPPED_QUANTITY2 IN jtf_number_table := NULL
,p_SHIPPING_QUANTITY_UOM2 IN jtf_varchar2_table_100 := NULL
,p_FULFILLED_QUANTITY2 IN jtf_number_table := NULL
,p_MFG_LEAD_TIME IN jtf_number_table := NULL
,p_LOCK_CONTROL IN jtf_number_table := NULL
,p_SUBINVENTORY IN jtf_varchar2_table_100 := NULL
,p_UNIT_LIST_PRICE_PER_PQTY IN jtf_number_table := NULL
,p_UNIT_SELL_PRICE_PER_PQTY IN jtf_number_table := NULL
,p_PRICE_REQUEST_CODE IN jtf_varchar2_table_300 := NULL
,p_ORIGINAL_INVENTORY_ITEM_ID IN jtf_number_table := NULL
,p_ORIGINAL_ORDERED_ITEM_ID IN jtf_number_table := NULL
,p_ORIGINAL_ORDERED_ITEM IN jtf_varchar2_table_300 := NULL
,p_ORIGINAL_ITEM_IDENTIF_TYPE IN jtf_varchar2_table_100 := NULL
,p_ITEM_SUBSTIT_TYPE_CODE IN jtf_varchar2_table_100 := NULL
,p_OVERRIDE_ATP_DATE_CODE IN jtf_varchar2_table_100 := NULL
,p_LATE_DEMAND_PENALTY_FACTOR IN jtf_number_table := NULL
,p_ACCOUNTING_RULE_DURATION IN jtf_number_table := NULL
,p_top_model_line_index IN jtf_number_table := NULL
,p_top_model_line_ref IN jtf_varchar2_table_100 := NULL
,p_unit_cost IN jtf_number_table := NULL
,p_xml_transaction_type_code IN jtf_varchar2_table_100 := NULL
,p_Sold_to_address_id IN jtf_number_table := NULL
,p_Split_Action_Code IN jtf_varchar2_table_100 := NULL
,p_split_from_line_ref IN jtf_varchar2_table_100 := NULL
,p_split_from_shipment_ref IN jtf_varchar2_table_100 := NULL
,p_status_flag IN jtf_varchar2_table_100 := NULL
,p_ship_from_edi_loc_code IN jtf_varchar2_table_100 := NULL
,p_ship_set IN jtf_varchar2_table_100 := NULL
,p_Ship_to_address_code IN jtf_varchar2_table_100 := NULL
,p_Ship_to_address_id IN jtf_varchar2_table_300 := NULL
,p_ship_to_customer_id IN jtf_number_table := NULL
,p_ship_to_edi_location_code IN jtf_varchar2_table_100 := NULL
,p_service_ref_line_number IN jtf_number_table := NULL
,p_service_ref_option_number IN jtf_number_table := NULL
,p_service_ref_order_number IN jtf_number_table := NULL
,p_service_ref_ship_number IN jtf_number_table := NULL
,p_service_reference_line IN jtf_varchar2_table_100 := NULL
,p_service_reference_order IN jtf_varchar2_table_100 := NULL
,p_service_reference_system IN jtf_varchar2_table_100 := NULL
,p_reserved_quantity IN jtf_number_table := NULL
,p_return_status IN jtf_varchar2_table_100 := NULL
,p_schedule_action_code IN jtf_varchar2_table_100 := NULL
,p_service_line_index IN jtf_number_table := NULL
,p_intermed_ship_to_cont_id IN jtf_number_table := NULL
,p_intermed_ship_to_org_id IN jtf_number_table := NULL
,p_Invoice_address_id IN jtf_number_table := NULL
,p_invoice_to_customer_id IN jtf_number_table := NULL
,p_item_relationship_type IN jtf_number_table := NULL
,p_link_to_line_index IN jtf_number_table := NULL
,p_link_to_line_ref IN jtf_varchar2_table_100 := NULL
,p_db_flag IN jtf_varchar2_table_100 := NULL
,p_deliver_to_customer_id IN jtf_number_table := NULL
,p_fulfillment_set IN jtf_varchar2_table_100 := NULL
,p_fulfillment_set_id IN jtf_number_table := NULL
,p_change_comments IN jtf_varchar2_table_300 := NULL
,p_change_reason IN jtf_varchar2_table_100 := NULL
,p_change_request_code IN jtf_varchar2_table_100 := NULL
,p_Bill_to_Edi_Location_Code IN jtf_varchar2_table_100 := NULL
,p_Blanket_Line_Number IN jtf_number_table := NULL
,p_Blanket_Number IN jtf_number_table := NULL
,p_Blanket_Version_Number IN jtf_number_table := NULL
,p_arrival_set IN jtf_varchar2_table_100 := NULL
,p_attribute16 IN jtf_varchar2_table_300 := NULL
,p_attribute17 IN jtf_varchar2_table_300 := NULL
,p_attribute18 IN jtf_varchar2_table_300 := NULL
,p_attribute19 IN jtf_varchar2_table_300 := NULL
,p_attribute20 IN jtf_varchar2_table_300 := NULL
)
RETURN OE_Order_PUB.Line_Tbl_Type
IS
l_order_line_tbl OE_Order_PUB.Line_Tbl_Type;
IF ((p_LAST_UPDATE_DATE is not null) and ((p_LAST_UPDATE_DATE(i) is null) or (p_LAST_UPDATE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
l_order_line_tbl(i).LAST_UPDATE_DATE := p_LAST_UPDATE_DATE(i);
IF ((p_LAST_UPDATED_BY is not null) and ((p_LAST_UPDATED_BY(i) is null) or (p_LAST_UPDATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
l_order_line_tbl(i).LAST_UPDATED_BY := p_LAST_UPDATED_BY(i);
IF ((p_LAST_UPDATE_LOGIN is not null) and ((p_LAST_UPDATE_LOGIN(i) is null) or (p_LAST_UPDATE_LOGIN(i) <> ROSETTA_G_MISS_NUM))) THEN
l_order_line_tbl(i).LAST_UPDATE_LOGIN := p_LAST_UPDATE_LOGIN(i);
IF ((p_PROGRAM_UPDATE_DATE is not null) and ((p_PROGRAM_UPDATE_DATE(i) is null) or (p_PROGRAM_UPDATE_DATE(i) <> ROSETTA_G_MISS_DATE))) THEN
l_order_line_tbl(i).PROGRAM_UPDATE_DATE := p_PROGRAM_UPDATE_DATE(i);
IF ((p_AUTO_SELECTED_QUANTITY is not null) and ((p_AUTO_SELECTED_QUANTITY(i) is null) or (p_AUTO_SELECTED_QUANTITY(i) <> ROSETTA_G_MISS_NUM))) THEN
l_order_line_tbl(i).AUTO_SELECTED_QUANTITY := p_AUTO_SELECTED_QUANTITY(i);
p_LAST_UPDATED_BY IN NUMBER := FND_API.G_MISS_NUM,
p_LAST_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
p_LAST_UPDATE_LOGIN IN NUMBER := FND_API.G_MISS_NUM,
p_PROGRAM_APPLICATION_ID IN NUMBER := FND_API.G_MISS_NUM,
p_PROGRAM_ID IN NUMBER := FND_API.G_MISS_NUM,
p_PROGRAM_UPDATE_DATE IN DATE := FND_API.G_MISS_DATE,
p_REQUEST_ID IN NUMBER := FND_API.G_MISS_NUM,
p_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_GLOBAL_ATTRIBUTE20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CANCELLED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_OPEN_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_BOOKED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_SALESREP_ID IN NUMBER := FND_API.G_MISS_NUM,
p_RETURN_REASON_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ORDER_DATE_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_EARLIEST_SCHEDULE_LIMIT IN NUMBER := FND_API.G_MISS_NUM,
p_LATEST_SCHEDULE_LIMIT IN NUMBER := FND_API.G_MISS_NUM,
p_PAYMENT_TYPE_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_PAYMENT_AMOUNT IN NUMBER := FND_API.G_MISS_NUM,
p_CHECK_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CREDIT_CARD_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CREDIT_CARD_HOLDER_NAME IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CREDIT_CARD_NUMBER IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CREDIT_CARD_EXPIR_DATE IN DATE := FND_API.G_MISS_DATE,
p_CREDIT_CARD_APPROVAL_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_SALES_CHANNEL_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_FIRST_ACK_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_FIRST_ACK_DATE IN DATE := FND_API.G_MISS_DATE,
p_LAST_ACK_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_LAST_ACK_DATE IN DATE := FND_API.G_MISS_DATE,
p_ORDER_CATEGORY_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CHANGE_SEQUENCE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_DROP_SHIP_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CUSTOMER_PAYMENT_TERM_ID IN NUMBER := FND_API.G_MISS_NUM,
p_SHIPPING_INSTRUCTIONS IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_PACKING_INSTRUCTIONS IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_CONTEXT IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_TP_ATTRIBUTE15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_FLOW_STATUS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_MARKETING_SOURCE_CODE_ID IN NUMBER := FND_API.G_MISS_NUM,
p_CREDIT_CARD_APPROVAL_DATE IN DATE := FND_API.G_MISS_DATE,
p_UPGRADED_FLAG IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_CUSTOMER_PREF_SET_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_BOOKED_DATE IN DATE := FND_API.G_MISS_DATE,
p_LOCK_CONTROL IN NUMBER := FND_API.G_MISS_NUM,
p_PRICE_REQUEST_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_XML_MESSAGE_ID IN NUMBER := FND_API.G_MISS_NUM,
p_ACCOUNTING_RULE_DURATION IN NUMBER := FND_API.G_MISS_NUM,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_bill_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_Blanket_Number IN NUMBER := FND_API.G_MISS_NUM,
p_change_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_change_reason IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_change_request_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_db_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_Default_Fulfillment_set IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_deliver_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
p_force_apply_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_Fulfillment_Set_Name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_INVOICE_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
p_SHIP_FROM_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
p_ship_from_edi_loc_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_Line_Set_Name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ready_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_SHIP_TO_ADDRESS_CODE IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_SHIP_TO_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_customer_id IN NUMBER := FND_API.G_MISS_NUM,
p_ship_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_SOLD_TO_ADDRESS_ID IN NUMBER := FND_API.G_MISS_NUM,
p_sold_to_edi_location_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_sold_to_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_status_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_xml_transaction_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR
)
RETURN OE_Order_PUB.Header_Rec_Type
IS
l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
IF p_LAST_UPDATED_BY = ROSETTA_G_MISS_NUM THEN
l_order_header_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
l_order_header_rec.LAST_UPDATED_BY := p_LAST_UPDATED_BY;
IF p_LAST_UPDATE_DATE = ROSETTA_G_MISS_DATE THEN
l_order_header_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
l_order_header_rec.LAST_UPDATE_DATE := p_LAST_UPDATE_DATE;
IF p_LAST_UPDATE_LOGIN = ROSETTA_G_MISS_NUM THEN
l_order_header_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
l_order_header_rec.LAST_UPDATE_LOGIN := p_LAST_UPDATE_LOGIN;
IF p_PROGRAM_UPDATE_DATE = ROSETTA_G_MISS_DATE THEN
l_order_header_rec.PROGRAM_UPDATE_DATE := FND_API.G_MISS_DATE;
l_order_header_rec.PROGRAM_UPDATE_DATE := p_PROGRAM_UPDATE_DATE;
x_last_update_date OUT NOCOPY DATE ,
p_h_HEADER_ID IN NUMBER ,
p_h_OPERATION IN VARCHAR2 ,
p_h_ORG_ID IN NUMBER ,
p_h_ORDER_TYPE_ID IN NUMBER ,
p_h_ORDER_NUMBER IN NUMBER ,
p_h_VERSION_NUMBER IN NUMBER ,
p_h_EXPIRATION_DATE IN DATE ,
p_h_ORDER_SOURCE_ID IN NUMBER ,
p_h_SOURCE_DOCUMENT_TYPE_ID IN NUMBER ,
p_h_ORIG_SYS_DOCUMENT_REF IN VARCHAR2 ,
p_h_SOURCE_DOCUMENT_ID IN NUMBER ,
p_h_ORDERED_DATE IN DATE ,
p_h_REQUEST_DATE IN DATE ,
p_h_PRICING_DATE IN DATE ,
p_h_SHIPMENT_PRIORITY_CODE IN VARCHAR2 ,
p_h_DEMAND_CLASS_CODE IN VARCHAR2 ,
p_h_PRICE_LIST_ID IN NUMBER ,
p_h_MINISITE_ID IN NUMBER , -- bug 8337371, scnagara
p_h_TAX_EXEMPT_FLAG IN VARCHAR2 ,
p_h_TAX_EXEMPT_NUMBER IN VARCHAR2 ,
p_h_TAX_EXEMPT_REASON_CODE IN VARCHAR2 ,
p_h_CONVERSION_RATE IN NUMBER ,
p_h_CONVERSION_TYPE_CODE IN VARCHAR2 ,
p_h_CONVERSION_RATE_DATE IN DATE ,
p_h_PARTIAL_SHIPMENTS_ALLOWED IN VARCHAR2 ,
p_h_SHIP_TOLERANCE_ABOVE IN NUMBER ,
p_h_SHIP_TOLERANCE_BELOW IN NUMBER ,
p_h_TRANSACTIONAL_CURR_CODE IN VARCHAR2 ,
p_h_AGREEMENT_ID IN NUMBER ,
p_h_TAX_POINT_CODE IN VARCHAR2 ,
p_h_CUST_PO_NUMBER IN VARCHAR2 ,
p_h_INVOICING_RULE_ID IN NUMBER ,
p_h_ACCOUNTING_RULE_ID IN NUMBER ,
p_h_PAYMENT_TERM_ID IN NUMBER ,
p_h_SHIPPING_METHOD_CODE IN VARCHAR2 ,
p_h_FREIGHT_CARRIER_CODE IN VARCHAR2 ,
p_h_FOB_POINT_CODE IN VARCHAR2 ,
p_h_FREIGHT_TERMS_CODE IN VARCHAR2 ,
p_h_SOLD_FROM_ORG_ID IN NUMBER ,
p_h_SOLD_TO_ORG_ID IN NUMBER ,
p_h_SHIP_FROM_ORG_ID IN NUMBER ,
p_h_SHIP_TO_ORG_ID IN NUMBER ,
p_h_INVOICE_TO_ORG_ID IN NUMBER ,
p_h_DELIVER_TO_ORG_ID IN NUMBER ,
p_h_SOLD_TO_CONTACT_ID IN NUMBER ,
p_h_SHIP_TO_CONTACT_ID IN NUMBER ,
p_h_INVOICE_TO_CONTACT_ID IN NUMBER ,
p_h_DELIVER_TO_CONTACT_ID IN NUMBER ,
p_h_CREATION_DATE IN DATE ,
p_h_CREATED_BY IN NUMBER ,
p_h_LAST_UPDATED_BY IN NUMBER ,
p_h_LAST_UPDATE_DATE IN DATE ,
p_h_LAST_UPDATE_LOGIN IN NUMBER ,
p_h_PROGRAM_APPLICATION_ID IN NUMBER ,
p_h_PROGRAM_ID IN NUMBER ,
p_h_PROGRAM_UPDATE_DATE IN DATE ,
p_h_REQUEST_ID IN NUMBER ,
p_h_CONTEXT IN VARCHAR2 ,
p_h_ATTRIBUTE1 IN VARCHAR2 ,
p_h_ATTRIBUTE2 IN VARCHAR2 ,
p_h_ATTRIBUTE3 IN VARCHAR2 ,
p_h_ATTRIBUTE4 IN VARCHAR2 ,
p_h_ATTRIBUTE5 IN VARCHAR2 ,
p_h_ATTRIBUTE6 IN VARCHAR2 ,
p_h_ATTRIBUTE7 IN VARCHAR2 ,
p_h_ATTRIBUTE8 IN VARCHAR2 ,
p_h_ATTRIBUTE9 IN VARCHAR2 ,
p_h_ATTRIBUTE10 IN VARCHAR2 ,
p_h_ATTRIBUTE11 IN VARCHAR2 ,
p_h_ATTRIBUTE12 IN VARCHAR2 ,
p_h_ATTRIBUTE13 IN VARCHAR2 ,
p_h_ATTRIBUTE14 IN VARCHAR2 ,
p_h_ATTRIBUTE15 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE1 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE2 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE3 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE4 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE5 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE6 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE7 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE8 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE9 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE10 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE11 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE12 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE13 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE14 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE15 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE16 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE17 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE18 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE19 IN VARCHAR2 ,
p_h_GLOBAL_ATTRIBUTE20 IN VARCHAR2 ,
p_h_CANCELLED_FLAG IN VARCHAR2 ,
p_h_OPEN_FLAG IN VARCHAR2 ,
p_h_BOOKED_FLAG IN VARCHAR2 ,
p_h_SALESREP_ID IN NUMBER ,
p_h_RETURN_REASON_CODE IN VARCHAR2 ,
p_h_ORDER_DATE_TYPE_CODE IN VARCHAR2 ,
p_h_EARLIEST_SCHEDULE_LIMIT IN NUMBER ,
p_h_LATEST_SCHEDULE_LIMIT IN NUMBER ,
p_h_PAYMENT_TYPE_CODE IN VARCHAR2 ,
p_h_PAYMENT_AMOUNT IN NUMBER ,
p_h_CHECK_NUMBER IN VARCHAR2 ,
p_h_CREDIT_CARD_CODE IN VARCHAR2 ,
p_h_CREDIT_CARD_HOLDER_NAME IN VARCHAR2 ,
p_h_CREDIT_CARD_NUMBER IN VARCHAR2 ,
p_h_CREDIT_CARD_EXPIR_DATE IN DATE ,
p_h_CREDIT_CARD_APPROVAL_CODE IN VARCHAR2 ,
p_h_SALES_CHANNEL_CODE IN VARCHAR2 ,
p_h_FIRST_ACK_CODE IN VARCHAR2 ,
p_h_FIRST_ACK_DATE IN DATE ,
p_h_LAST_ACK_CODE IN VARCHAR2 ,
p_h_LAST_ACK_DATE IN DATE ,
p_h_ORDER_CATEGORY_CODE IN VARCHAR2 ,
p_h_CHANGE_SEQUENCE IN VARCHAR2 ,
p_h_DROP_SHIP_FLAG IN VARCHAR2 ,
p_h_CUSTOMER_PAYMENT_TERM_ID IN NUMBER ,
p_h_SHIPPING_INSTRUCTIONS IN VARCHAR2 ,
p_h_PACKING_INSTRUCTIONS IN VARCHAR2 ,
p_h_TP_CONTEXT IN VARCHAR2 ,
p_h_TP_ATTRIBUTE1 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE2 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE3 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE4 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE5 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE6 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE7 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE8 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE9 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE10 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE11 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE12 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE13 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE14 IN VARCHAR2 ,
p_h_TP_ATTRIBUTE15 IN VARCHAR2 ,
p_h_FLOW_STATUS_CODE IN VARCHAR2 ,
p_h_MARKETING_SOURCE_CODE_ID IN NUMBER ,
p_h_CREDIT_CARD_APPROVAL_DATE IN DATE ,
p_h_UPGRADED_FLAG IN VARCHAR2 ,
p_h_CUSTOMER_PREF_SET_CODE IN VARCHAR2 ,
p_h_BOOKED_DATE IN DATE ,
p_h_LOCK_CONTROL IN NUMBER ,
p_h_PRICE_REQUEST_CODE IN VARCHAR2 ,
p_h_XML_MESSAGE_ID IN NUMBER ,
p_h_ACCOUNTING_RULE_DURATION IN NUMBER ,
p_h_attribute16 IN VARCHAR2 ,
p_h_attribute17 IN VARCHAR2 ,
p_h_attribute18 IN VARCHAR2 ,
p_h_attribute19 IN VARCHAR2 ,
p_h_attribute20 IN VARCHAR2 ,
p_h_bill_to_edi_location_code IN VARCHAR2 ,
p_h_Blanket_Number IN NUMBER ,
p_h_change_comments IN VARCHAR2 ,
p_h_change_reason IN VARCHAR2 ,
p_h_change_request_code IN VARCHAR2 ,
p_h_db_flag IN VARCHAR2 ,
p_h_Default_Fulfillment_Set IN VARCHAR2 ,
p_h_deliver_to_customer_id IN NUMBER ,
p_h_force_apply_flag IN VARCHAR2 ,
p_h_Fulfillment_Set_Name IN VARCHAR2 ,
p_h_INVOICE_ADDRESS_ID IN NUMBER ,
p_h_invoice_to_customer_id IN NUMBER ,
p_h_SHIP_FROM_ADDRESS_ID IN NUMBER ,
p_h_ship_from_edi_loc_code IN VARCHAR2 ,
p_h_Line_Set_Name IN VARCHAR2 ,
p_h_ready_flag IN VARCHAR2 ,
p_h_SHIP_TO_ADDRESS_CODE IN VARCHAR2 ,
p_h_SHIP_TO_ADDRESS_ID IN NUMBER ,
p_h_ship_to_customer_id IN NUMBER ,
p_h_ship_to_edi_location_code IN VARCHAR2 ,
p_h_SOLD_TO_ADDRESS_ID IN NUMBER ,
p_h_sold_to_edi_location_code IN VARCHAR2 ,
p_h_sold_to_phone_id IN NUMBER ,
p_h_status_flag IN VARCHAR2 ,
p_h_xml_transaction_type_code IN VARCHAR2 ,
p_l_LINE_ID IN jtf_number_table ,
p_l_OPERATION IN jtf_varchar2_table_100 ,
p_l_ORG_ID IN jtf_number_table ,
p_l_HEADER_ID IN jtf_number_table ,
p_l_LINE_TYPE_ID IN jtf_number_table ,
p_l_LINE_NUMBER IN jtf_number_table ,
p_l_ORDERED_ITEM IN jtf_varchar2_table_300 ,
p_l_REQUEST_DATE IN jtf_date_table ,
p_l_PROMISE_DATE IN jtf_date_table ,
p_l_SCHEDULE_SHIP_DATE IN jtf_date_table ,
p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 ,
p_l_PRICING_QUANTITY IN jtf_number_table ,
p_l_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 ,
p_l_CANCELLED_QUANTITY IN jtf_number_table ,
p_l_SHIPPED_QUANTITY IN jtf_number_table ,
p_l_ORDERED_QUANTITY IN jtf_number_table ,
p_l_FULFILLED_QUANTITY IN jtf_number_table ,
p_l_SHIPPING_QUANTITY IN jtf_number_table ,
p_l_SHIPPING_QUANTITY_UOM IN jtf_varchar2_table_100 ,
p_l_DELIVERY_LEAD_TIME IN jtf_number_table ,
p_l_TAX_EXEMPT_FLAG IN jtf_varchar2_table_100 ,
p_l_TAX_EXEMPT_NUMBER IN jtf_varchar2_table_100 ,
p_l_TAX_EXEMPT_REASON_CODE IN jtf_varchar2_table_100 ,
p_l_SHIP_FROM_ORG_ID IN jtf_number_table ,
p_l_SHIP_TO_ORG_ID IN jtf_number_table ,
p_l_INVOICE_TO_ORG_ID IN jtf_number_table ,
p_l_DELIVER_TO_ORG_ID IN jtf_number_table ,
p_l_SHIP_TO_CONTACT_ID IN jtf_number_table ,
p_l_DELIVER_TO_CONTACT_ID IN jtf_number_table ,
p_l_INVOICE_TO_CONTACT_ID IN jtf_number_table ,
p_l_SOLD_FROM_ORG_ID IN jtf_number_table ,
p_l_SOLD_TO_ORG_ID IN jtf_number_table ,
p_l_CUST_PO_NUMBER IN jtf_varchar2_table_100 ,
p_l_SHIP_TOLERANCE_ABOVE IN jtf_number_table ,
p_l_SHIP_TOLERANCE_BELOW IN jtf_number_table ,
p_l_DEMAND_BUCKET_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_VEH_CUS_ITEM_CUM_KEY_ID IN jtf_number_table ,
p_l_RLA_SCHEDULE_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_DOCK_CODE IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_JOB IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_PRODUCTION_LINE IN jtf_varchar2_table_100 ,
p_l_CUST_MODEL_SERIAL_NUMBER IN jtf_varchar2_table_100 ,
p_l_PROJECT_ID IN jtf_number_table ,
p_l_TASK_ID IN jtf_number_table ,
p_l_INVENTORY_ITEM_ID IN jtf_number_table ,
p_l_TAX_DATE IN jtf_date_table ,
p_l_TAX_CODE IN jtf_varchar2_table_100 ,
p_l_TAX_RATE IN jtf_number_table ,
-- p_l_INVOICE_INTERFACE_STATUS_CODE IN jtf_varchar2_table_100 ,
p_l_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 ,
p_l_DEMAND_CLASS_CODE IN jtf_varchar2_table_100 ,
p_l_PRICE_LIST_ID IN jtf_number_table ,
p_l_PRICING_DATE IN jtf_date_table ,
p_l_SHIPMENT_NUMBER IN jtf_number_table ,
p_l_AGREEMENT_ID IN jtf_number_table ,
p_l_SHIPMENT_PRIORITY_CODE IN jtf_varchar2_table_100 ,
p_l_SHIPPING_METHOD_CODE IN jtf_varchar2_table_100 ,
p_l_FREIGHT_CARRIER_CODE IN jtf_varchar2_table_100 ,
p_l_FREIGHT_TERMS_CODE IN jtf_varchar2_table_100 ,
p_l_FOB_POINT_CODE IN jtf_varchar2_table_100 ,
p_l_TAX_POINT_CODE IN jtf_varchar2_table_100 ,
p_l_PAYMENT_TERM_ID IN jtf_number_table ,
p_l_INVOICING_RULE_ID IN jtf_number_table ,
p_l_ACCOUNTING_RULE_ID IN jtf_number_table ,
p_l_SOURCE_DOCUMENT_TYPE_ID IN jtf_number_table ,
p_l_ORIG_SYS_DOCUMENT_REF IN jtf_varchar2_table_100 ,
p_l_SOURCE_DOCUMENT_ID IN jtf_number_table ,
p_l_ORIG_SYS_LINE_REF IN jtf_varchar2_table_100 ,
p_l_SOURCE_DOCUMENT_LINE_ID IN jtf_number_table ,
p_l_REFERENCE_LINE_ID IN jtf_number_table ,
p_l_REFERENCE_TYPE IN jtf_varchar2_table_300 ,
p_l_REFERENCE_HEADER_ID IN jtf_number_table ,
p_l_ITEM_REVISION IN jtf_varchar2_table_100 ,
p_l_UNIT_SELLING_PRICE IN jtf_number_table ,
p_l_UNIT_LIST_PRICE IN jtf_number_table ,
p_l_TAX_VALUE IN jtf_number_table ,
p_l_CONTEXT IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
p_l_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE_CATEGORY IN jtf_varchar2_table_100 ,
p_l_GLOBAL_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE16 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE17 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE18 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE19 IN jtf_varchar2_table_300 ,
p_l_GLOBAL_ATTRIBUTE20 IN jtf_varchar2_table_300 ,
p_l_PRICING_CONTEXT IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_PRICING_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_CONTEXT IN jtf_varchar2_table_100 ,
p_l_INDUSTRY_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE16 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE17 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE18 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE19 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE20 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE21 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE22 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE23 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE24 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE25 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE26 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE27 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE28 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 ,
p_l_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 ,
p_l_CREATION_DATE IN jtf_date_table ,
p_l_CREATED_BY IN jtf_number_table ,
p_l_LAST_UPDATE_DATE IN jtf_date_table ,
p_l_LAST_UPDATED_BY IN jtf_number_table ,
p_l_LAST_UPDATE_LOGIN IN jtf_number_table ,
p_l_PROGRAM_APPLICATION_ID IN jtf_number_table ,
p_l_PROGRAM_ID IN jtf_number_table ,
p_l_PROGRAM_UPDATE_DATE IN jtf_date_table ,
p_l_REQUEST_ID IN jtf_number_table ,
p_l_TOP_MODEL_LINE_ID IN jtf_number_table ,
p_l_LINK_TO_LINE_ID IN jtf_number_table ,
p_l_COMPONENT_SEQUENCE_ID IN jtf_number_table ,
p_l_COMPONENT_CODE IN jtf_varchar2_table_300 ,
p_l_CONFIG_DISPLAY_SEQUENCE IN jtf_number_table ,
p_l_SORT_ORDER IN jtf_varchar2_table_300 ,
p_l_ITEM_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_OPTION_NUMBER IN jtf_number_table ,
p_l_OPTION_FLAG IN jtf_varchar2_table_100 ,
p_l_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 ,
p_l_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 ,
p_l_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 ,
p_l_ACTUAL_SHIPMENT_DATE IN jtf_date_table ,
p_l_CUSTOMER_TRX_LINE_ID IN jtf_number_table ,
p_l_RETURN_CONTEXT IN jtf_varchar2_table_100 ,
p_l_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
p_l_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table ,
p_l_ATO_LINE_ID IN jtf_number_table ,
p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table ,
p_l_COMPONENT_NUMBER IN jtf_number_table ,
p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table ,
p_l_EXPLOSION_DATE IN jtf_date_table ,
p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table ,
p_l_MODEL_GROUP_NUMBER IN jtf_number_table ,
p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table ,
p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 ,
p_l_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 ,
p_l_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_CANCELLED_FLAG IN jtf_varchar2_table_100 ,
p_l_OPEN_FLAG IN jtf_varchar2_table_100 ,
p_l_BOOKED_FLAG IN jtf_varchar2_table_100 ,
p_l_SALESREP_ID IN jtf_number_table ,
p_l_RETURN_REASON_CODE IN jtf_varchar2_table_100 ,
p_l_ARRIVAL_SET_ID IN jtf_number_table ,
p_l_SHIP_SET_ID IN jtf_number_table ,
p_l_SPLIT_FROM_LINE_ID IN jtf_number_table ,
p_l_CUST_PRODUCTION_SEQ_NUM IN jtf_varchar2_table_100 ,
p_l_AUTHORIZED_TO_SHIP_FLAG IN jtf_varchar2_table_300 ,
p_l_OVER_SHIP_REASON_CODE IN jtf_varchar2_table_100 ,
p_l_OVER_SHIP_RESOLVED_FLAG IN jtf_varchar2_table_100 ,
p_l_ORDERED_ITEM_ID IN jtf_number_table ,
p_l_ITEM_IDENTIFIER_TYPE IN jtf_varchar2_table_100 ,
p_l_CONFIGURATION_ID IN jtf_number_table ,
p_l_COMMITMENT_ID IN jtf_number_table ,
p_l_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 ,
p_l_CREDIT_INVOICE_LINE_ID IN jtf_number_table ,
p_l_FIRST_ACK_CODE IN jtf_varchar2_table_100 ,
p_l_FIRST_ACK_DATE IN jtf_date_table ,
p_l_LAST_ACK_CODE IN jtf_varchar2_table_100 ,
p_l_LAST_ACK_DATE IN jtf_date_table ,
p_l_PLANNING_PRIORITY IN jtf_number_table ,
p_l_ORDER_SOURCE_ID IN jtf_number_table ,
p_l_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 ,
p_l_CHANGE_SEQUENCE IN jtf_varchar2_table_100 ,
p_l_DROP_SHIP_FLAG IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_LINE_NUMBER IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_SHIPMENT_NUMBER IN jtf_varchar2_table_100 ,
p_l_CUSTOMER_ITEM_NET_PRICE IN jtf_number_table ,
p_l_CUSTOMER_PAYMENT_TERM_ID IN jtf_number_table ,
p_l_FULFILLED_FLAG IN jtf_varchar2_table_100 ,
p_l_END_ITEM_UNIT_NUMBER IN jtf_varchar2_table_100 ,
p_l_CONFIG_HEADER_ID IN jtf_number_table ,
p_l_CONFIG_REV_NBR IN jtf_number_table ,
p_l_MFG_COMPONENT_SEQUENCE_ID IN jtf_number_table ,
p_l_SHIPPING_INSTRUCTIONS IN jtf_varchar2_table_300 ,
p_l_PACKING_INSTRUCTIONS IN jtf_varchar2_table_300 ,
p_l_INVOICED_QUANTITY IN jtf_number_table ,
p_l_REF_CUSTOMER_TRX_LINE_ID IN jtf_number_table ,
p_l_SPLIT_BY IN jtf_varchar2_table_300 ,
p_l_LINE_SET_ID IN jtf_number_table ,
p_l_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 ,
p_l_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 ,
p_l_SERVICE_DURATION IN jtf_number_table ,
p_l_SERVICE_START_DATE IN jtf_date_table ,
p_l_SERVICE_END_DATE IN jtf_date_table ,
p_l_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 ,
p_l_UNIT_LIST_PERCENT IN jtf_number_table ,
p_l_UNIT_SELLING_PERCENT IN jtf_number_table ,
p_l_UNIT_PERCENT_BASE_PRICE IN jtf_number_table ,
p_l_SERVICE_NUMBER IN jtf_number_table ,
p_l_SERVICE_PERIOD IN jtf_varchar2_table_100 ,
p_l_SHIPPABLE_FLAG IN jtf_varchar2_table_100 ,
p_l_MODEL_REMNANT_FLAG IN jtf_varchar2_table_100 ,
p_l_RE_SOURCE_FLAG IN jtf_varchar2_table_300 ,
p_l_FLOW_STATUS_CODE IN jtf_varchar2_table_100 ,
p_l_TP_CONTEXT IN jtf_varchar2_table_100 ,
p_l_TP_ATTRIBUTE1 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE2 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE3 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE4 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE5 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE6 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE7 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE8 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE9 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE10 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE11 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE12 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE13 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE14 IN jtf_varchar2_table_300 ,
p_l_TP_ATTRIBUTE15 IN jtf_varchar2_table_300 ,
p_l_FULFILLMENT_METHOD_CODE IN jtf_varchar2_table_300 ,
p_l_MARKETING_SOURCE_CODE_ID IN jtf_number_table ,
p_l_SERVICE_REF_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_SERVICE_REFERENCE_LINE_ID IN jtf_number_table ,
p_l_SERVICE_REF_SYSTEM_ID IN jtf_number_table ,
p_l_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 ,
p_l_UPGRADED_FLAG IN jtf_varchar2_table_100 ,
p_l_REVENUE_AMOUNT IN jtf_number_table ,
p_l_FULFILLMENT_DATE IN jtf_date_table ,
p_l_PREFERRED_GRADE IN jtf_varchar2_table_100 ,
p_l_ORDERED_QUANTITY2 IN jtf_number_table ,
p_l_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 ,
p_l_SHIPPING_QUANTITY2 IN jtf_number_table ,
p_l_CANCELLED_QUANTITY2 IN jtf_number_table ,
p_l_SHIPPED_QUANTITY2 IN jtf_number_table ,
p_l_SHIPPING_QUANTITY_UOM2 IN jtf_varchar2_table_100 ,
p_l_FULFILLED_QUANTITY2 IN jtf_number_table ,
p_l_MFG_LEAD_TIME IN jtf_number_table ,
p_l_LOCK_CONTROL IN jtf_number_table ,
p_l_SUBINVENTORY IN jtf_varchar2_table_100 ,
p_l_UNIT_LIST_PRICE_PER_PQTY IN jtf_number_table ,
-- p_l_UNIT_SELLING_PRICE_PER_PQTY IN jtf_number_table ,
p_l_UNIT_SELL_PRICE_PER_PQTY IN jtf_number_table ,
p_l_PRICE_REQUEST_CODE IN jtf_varchar2_table_300 ,
p_l_ORIGINAL_INVENTORY_ITEM_ID IN jtf_number_table ,
p_l_ORIGINAL_ORDERED_ITEM_ID IN jtf_number_table ,
p_l_ORIGINAL_ORDERED_ITEM IN jtf_varchar2_table_300 ,
p_l_ORIGINAL_ITEM_IDENTIF_TYPE IN jtf_varchar2_table_100 ,
p_l_ITEM_SUBSTIT_TYPE_CODE IN jtf_varchar2_table_100 ,
p_l_OVERRIDE_ATP_DATE_CODE IN jtf_varchar2_table_100 ,
p_l_LATE_DEMAND_PENALTY_FACTOR IN jtf_number_table ,
p_l_ACCOUNTING_RULE_DURATION IN jtf_number_table ,
p_l_top_model_line_index IN jtf_number_table ,
p_l_top_model_line_ref IN jtf_varchar2_table_100 ,
p_l_unit_cost IN jtf_number_table ,
p_l_xml_transaction_type_code IN jtf_varchar2_table_100 ,
p_l_Sold_to_address_id IN jtf_number_table ,
p_l_Split_Action_Code IN jtf_varchar2_table_100 ,
p_l_split_from_line_ref IN jtf_varchar2_table_100 ,
p_l_split_from_shipment_ref IN jtf_varchar2_table_100 ,
p_l_status_flag IN jtf_varchar2_table_100 ,
p_l_ship_from_edi_loc_code IN jtf_varchar2_table_100 ,
p_l_ship_set IN jtf_varchar2_table_100 ,
p_l_Ship_to_address_code IN jtf_varchar2_table_100 ,
p_l_Ship_to_address_id IN jtf_varchar2_table_300 ,
p_l_ship_to_customer_id IN jtf_number_table ,
p_l_ship_to_edi_location_code IN jtf_varchar2_table_100 ,
p_l_service_ref_line_number IN jtf_number_table ,
p_l_service_ref_option_number IN jtf_number_table ,
p_l_service_ref_order_number IN jtf_number_table ,
p_l_service_ref_ship_number IN jtf_number_table ,
p_l_service_reference_line IN jtf_varchar2_table_100 ,
p_l_service_reference_order IN jtf_varchar2_table_100 ,
p_l_service_reference_system IN jtf_varchar2_table_100 ,
p_l_reserved_quantity IN jtf_number_table ,
p_l_return_status IN jtf_varchar2_table_100 ,
p_l_schedule_action_code IN jtf_varchar2_table_100 ,
p_l_service_line_index IN jtf_number_table ,
p_l_intermed_ship_to_cont_id IN jtf_number_table ,
p_l_intermed_ship_to_org_id IN jtf_number_table ,
p_l_Invoice_address_id IN jtf_number_table ,
p_l_invoice_to_customer_id IN jtf_number_table ,
p_l_item_relationship_type IN jtf_number_table ,
p_l_link_to_line_index IN jtf_number_table ,
p_l_link_to_line_ref IN jtf_varchar2_table_100 ,
p_l_db_flag IN jtf_varchar2_table_100 ,
p_l_deliver_to_customer_id IN jtf_number_table ,
p_l_fulfillment_set IN jtf_varchar2_table_100 ,
p_l_fulfillment_set_id IN jtf_number_table ,
p_l_change_comments IN jtf_varchar2_table_300 ,
p_l_change_reason IN jtf_varchar2_table_100 ,
p_l_change_request_code IN jtf_varchar2_table_100 ,
p_l_Bill_to_Edi_Location_Code IN jtf_varchar2_table_100 ,
p_l_Blanket_Line_Number IN jtf_number_table ,
p_l_Blanket_Number IN jtf_number_table ,
p_l_Blanket_Version_Number IN jtf_number_table ,
p_l_arrival_set IN jtf_varchar2_table_100 ,
p_l_attribute16 IN jtf_varchar2_table_300 ,
p_l_attribute17 IN jtf_varchar2_table_300 ,
p_l_attribute18 IN jtf_varchar2_table_300 ,
p_l_attribute19 IN jtf_varchar2_table_300 ,
p_l_attribute20 IN jtf_varchar2_table_300 ,
p_c_CANCEL_FLAG IN VARCHAR2 ,
p_c_SUBMIT_FLAG IN VARCHAR2 ,
p_c_CHKCONSTRAINT_FLAG IN VARCHAR2 ,
p_party_id IN NUMBER ,
p_shipto_partysite_id IN NUMBER ,
p_billto_partysite_id IN NUMBER ,
p_save_type IN NUMBER
)
IS
l_order_header_rec OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC;
p_LAST_UPDATED_BY => p_h_LAST_UPDATED_BY ,
p_LAST_UPDATE_DATE => p_h_LAST_UPDATE_DATE ,
p_LAST_UPDATE_LOGIN => p_h_LAST_UPDATE_LOGIN ,
p_PROGRAM_APPLICATION_ID => p_h_PROGRAM_APPLICATION_ID ,
p_PROGRAM_ID => p_h_PROGRAM_ID ,
p_PROGRAM_UPDATE_DATE => p_h_PROGRAM_UPDATE_DATE ,
p_REQUEST_ID => p_h_REQUEST_ID ,
p_CONTEXT => p_h_CONTEXT ,
p_ATTRIBUTE1 => p_h_ATTRIBUTE1 ,
p_ATTRIBUTE2 => p_h_ATTRIBUTE2 ,
p_ATTRIBUTE3 => p_h_ATTRIBUTE3 ,
p_ATTRIBUTE4 => p_h_ATTRIBUTE4 ,
p_ATTRIBUTE5 => p_h_ATTRIBUTE5 ,
p_ATTRIBUTE6 => p_h_ATTRIBUTE6 ,
p_ATTRIBUTE7 => p_h_ATTRIBUTE7 ,
p_ATTRIBUTE8 => p_h_ATTRIBUTE8 ,
p_ATTRIBUTE9 => p_h_ATTRIBUTE9 ,
p_ATTRIBUTE10 => p_h_ATTRIBUTE10 ,
p_ATTRIBUTE11 => p_h_ATTRIBUTE11 ,
p_ATTRIBUTE12 => p_h_ATTRIBUTE12 ,
p_ATTRIBUTE13 => p_h_ATTRIBUTE13 ,
p_ATTRIBUTE14 => p_h_ATTRIBUTE14 ,
p_ATTRIBUTE15 => p_h_ATTRIBUTE15 ,
p_GLOBAL_ATTRIBUTE_CATEGORY => p_h_GLOBAL_ATTRIBUTE_CATEGORY,
p_GLOBAL_ATTRIBUTE1 => p_h_GLOBAL_ATTRIBUTE1 ,
p_GLOBAL_ATTRIBUTE2 => p_h_GLOBAL_ATTRIBUTE2 ,
p_GLOBAL_ATTRIBUTE3 => p_h_GLOBAL_ATTRIBUTE3 ,
p_GLOBAL_ATTRIBUTE4 => p_h_GLOBAL_ATTRIBUTE4 ,
p_GLOBAL_ATTRIBUTE5 => p_h_GLOBAL_ATTRIBUTE5 ,
p_GLOBAL_ATTRIBUTE6 => p_h_GLOBAL_ATTRIBUTE6 ,
p_GLOBAL_ATTRIBUTE7 => p_h_GLOBAL_ATTRIBUTE7 ,
p_GLOBAL_ATTRIBUTE8 => p_h_GLOBAL_ATTRIBUTE8 ,
p_GLOBAL_ATTRIBUTE9 => p_h_GLOBAL_ATTRIBUTE9 ,
p_GLOBAL_ATTRIBUTE10 => p_h_GLOBAL_ATTRIBUTE10 ,
p_GLOBAL_ATTRIBUTE11 => p_h_GLOBAL_ATTRIBUTE11 ,
p_GLOBAL_ATTRIBUTE12 => p_h_GLOBAL_ATTRIBUTE12 ,
p_GLOBAL_ATTRIBUTE13 => p_h_GLOBAL_ATTRIBUTE13 ,
p_GLOBAL_ATTRIBUTE14 => p_h_GLOBAL_ATTRIBUTE14 ,
p_GLOBAL_ATTRIBUTE15 => p_h_GLOBAL_ATTRIBUTE15 ,
p_GLOBAL_ATTRIBUTE16 => p_h_GLOBAL_ATTRIBUTE16 ,
p_GLOBAL_ATTRIBUTE17 => p_h_GLOBAL_ATTRIBUTE17 ,
p_GLOBAL_ATTRIBUTE18 => p_h_GLOBAL_ATTRIBUTE18 ,
p_GLOBAL_ATTRIBUTE19 => p_h_GLOBAL_ATTRIBUTE19 ,
p_GLOBAL_ATTRIBUTE20 => p_h_GLOBAL_ATTRIBUTE20 ,
p_CANCELLED_FLAG => p_h_CANCELLED_FLAG ,
p_OPEN_FLAG => p_h_OPEN_FLAG ,
p_BOOKED_FLAG => p_h_BOOKED_FLAG ,
p_SALESREP_ID => p_h_SALESREP_ID ,
p_RETURN_REASON_CODE => p_h_RETURN_REASON_CODE ,
p_ORDER_DATE_TYPE_CODE => p_h_ORDER_DATE_TYPE_CODE ,
p_EARLIEST_SCHEDULE_LIMIT => p_h_EARLIEST_SCHEDULE_LIMIT ,
p_LATEST_SCHEDULE_LIMIT => p_h_LATEST_SCHEDULE_LIMIT ,
p_PAYMENT_TYPE_CODE => p_h_PAYMENT_TYPE_CODE ,
p_PAYMENT_AMOUNT => p_h_PAYMENT_AMOUNT ,
p_CHECK_NUMBER => p_h_CHECK_NUMBER ,
p_CREDIT_CARD_CODE => p_h_CREDIT_CARD_CODE ,
p_CREDIT_CARD_HOLDER_NAME => p_h_CREDIT_CARD_HOLDER_NAME ,
p_CREDIT_CARD_NUMBER => p_h_CREDIT_CARD_NUMBER ,
p_CREDIT_CARD_EXPIR_DATE => p_h_CREDIT_CARD_EXPIR_DATE ,
p_CREDIT_CARD_APPROVAL_CODE => p_h_CREDIT_CARD_APPROVAL_CODE ,
p_SALES_CHANNEL_CODE => p_h_SALES_CHANNEL_CODE ,
p_FIRST_ACK_CODE => p_h_FIRST_ACK_CODE ,
p_FIRST_ACK_DATE => p_h_FIRST_ACK_DATE ,
p_LAST_ACK_CODE => p_h_LAST_ACK_CODE ,
p_LAST_ACK_DATE => p_h_LAST_ACK_DATE ,
p_ORDER_CATEGORY_CODE => p_h_ORDER_CATEGORY_CODE ,
p_CHANGE_SEQUENCE => p_h_CHANGE_SEQUENCE ,
p_DROP_SHIP_FLAG => p_h_DROP_SHIP_FLAG ,
p_CUSTOMER_PAYMENT_TERM_ID => p_h_CUSTOMER_PAYMENT_TERM_ID ,
p_SHIPPING_INSTRUCTIONS => p_h_SHIPPING_INSTRUCTIONS ,
p_PACKING_INSTRUCTIONS => p_h_PACKING_INSTRUCTIONS ,
p_TP_CONTEXT => p_h_TP_CONTEXT ,
p_TP_ATTRIBUTE1 => p_h_TP_ATTRIBUTE1 ,
p_TP_ATTRIBUTE2 => p_h_TP_ATTRIBUTE2 ,
p_TP_ATTRIBUTE3 => p_h_TP_ATTRIBUTE3 ,
p_TP_ATTRIBUTE4 => p_h_TP_ATTRIBUTE4 ,
p_TP_ATTRIBUTE5 => p_h_TP_ATTRIBUTE5 ,
p_TP_ATTRIBUTE6 => p_h_TP_ATTRIBUTE6 ,
p_TP_ATTRIBUTE7 => p_h_TP_ATTRIBUTE7 ,
p_TP_ATTRIBUTE8 => p_h_TP_ATTRIBUTE8 ,
p_TP_ATTRIBUTE9 => p_h_TP_ATTRIBUTE9 ,
p_TP_ATTRIBUTE10 => p_h_TP_ATTRIBUTE10 ,
p_TP_ATTRIBUTE11 => p_h_TP_ATTRIBUTE11 ,
p_TP_ATTRIBUTE12 => p_h_TP_ATTRIBUTE12 ,
p_TP_ATTRIBUTE13 => p_h_TP_ATTRIBUTE13 ,
p_TP_ATTRIBUTE14 => p_h_TP_ATTRIBUTE14 ,
p_TP_ATTRIBUTE15 => p_h_TP_ATTRIBUTE15 ,
p_FLOW_STATUS_CODE => p_h_FLOW_STATUS_CODE ,
p_MARKETING_SOURCE_CODE_ID => p_h_MARKETING_SOURCE_CODE_ID ,
p_CREDIT_CARD_APPROVAL_DATE => p_h_CREDIT_CARD_APPROVAL_DATE ,
p_UPGRADED_FLAG => p_h_UPGRADED_FLAG ,
p_CUSTOMER_PREF_SET_CODE => p_h_CUSTOMER_PREF_SET_CODE ,
p_BOOKED_DATE => p_h_BOOKED_DATE ,
p_LOCK_CONTROL => p_h_LOCK_CONTROL ,
p_PRICE_REQUEST_CODE => p_h_PRICE_REQUEST_CODE ,
p_XML_MESSAGE_ID => p_h_XML_MESSAGE_ID ,
p_ACCOUNTING_RULE_DURATION => p_h_ACCOUNTING_RULE_DURATION ,
p_attribute16 => p_h_attribute16 ,
p_attribute17 => p_h_attribute17 ,
p_attribute18 => p_h_attribute18 ,
p_attribute19 => p_h_attribute19 ,
p_attribute20 => p_h_attribute20 ,
p_bill_to_edi_location_code => p_h_bill_to_edi_location_code,
p_Blanket_Number => p_h_Blanket_Number ,
p_change_comments => p_h_change_comments ,
p_change_reason => p_h_change_reason ,
p_change_request_code => p_h_change_request_code ,
p_db_flag => p_h_db_flag ,
p_Default_Fulfillment_Set => p_h_Default_Fulfillment_Set,
p_deliver_to_customer_id => p_h_deliver_to_customer_id,
p_force_apply_flag => p_h_force_apply_flag ,
p_Fulfillment_Set_Name => p_h_Fulfillment_Set_Name ,
p_INVOICE_ADDRESS_ID => p_h_INVOICE_ADDRESS_ID ,
p_invoice_to_customer_id => p_h_invoice_to_customer_id,
p_SHIP_FROM_ADDRESS_ID => p_h_SHIP_FROM_ADDRESS_ID ,
p_ship_from_edi_loc_code => p_h_ship_from_edi_loc_code ,
p_Line_Set_Name => p_h_Line_Set_Name ,
p_ready_flag => p_h_ready_flag ,
p_SHIP_TO_ADDRESS_CODE => p_h_SHIP_TO_ADDRESS_CODE,
p_SHIP_TO_ADDRESS_ID => p_h_SHIP_TO_ADDRESS_ID ,
p_ship_to_customer_id => p_h_ship_to_customer_id ,
p_ship_to_edi_location_code => p_h_ship_to_edi_location_code,
p_SOLD_TO_ADDRESS_ID => p_h_SOLD_TO_ADDRESS_ID ,
p_sold_to_edi_location_code => p_h_sold_to_edi_location_code,
p_sold_to_phone_id => p_h_sold_to_phone_id ,
p_status_flag => p_h_status_flag ,
p_xml_transaction_type_code => p_h_xml_transaction_type_code
);
p_LAST_UPDATE_DATE => p_l_LAST_UPDATE_DATE ,
p_LAST_UPDATED_BY => p_l_LAST_UPDATED_BY ,
p_LAST_UPDATE_LOGIN => p_l_LAST_UPDATE_LOGIN ,
p_PROGRAM_APPLICATION_ID => p_l_PROGRAM_APPLICATION_ID ,
p_PROGRAM_ID => p_l_PROGRAM_ID ,
p_PROGRAM_UPDATE_DATE => p_l_PROGRAM_UPDATE_DATE ,
p_REQUEST_ID => p_l_REQUEST_ID ,
p_TOP_MODEL_LINE_ID => p_l_TOP_MODEL_LINE_ID ,
p_LINK_TO_LINE_ID => p_l_LINK_TO_LINE_ID ,
p_COMPONENT_SEQUENCE_ID => p_l_COMPONENT_SEQUENCE_ID ,
p_COMPONENT_CODE => p_l_COMPONENT_CODE ,
p_CONFIG_DISPLAY_SEQUENCE => p_l_CONFIG_DISPLAY_SEQUENCE ,
p_SORT_ORDER => p_l_SORT_ORDER ,
p_ITEM_TYPE_CODE => p_l_ITEM_TYPE_CODE ,
p_OPTION_NUMBER => p_l_OPTION_NUMBER ,
p_OPTION_FLAG => p_l_OPTION_FLAG ,
p_DEP_PLAN_REQUIRED_FLAG => p_l_DEP_PLAN_REQUIRED_FLAG ,
p_VISIBLE_DEMAND_FLAG => p_l_VISIBLE_DEMAND_FLAG ,
p_LINE_CATEGORY_CODE => p_l_LINE_CATEGORY_CODE ,
p_ACTUAL_SHIPMENT_DATE => p_l_ACTUAL_SHIPMENT_DATE ,
p_CUSTOMER_TRX_LINE_ID => p_l_CUSTOMER_TRX_LINE_ID ,
p_RETURN_CONTEXT => p_l_RETURN_CONTEXT ,
p_RETURN_ATTRIBUTE1 => p_l_RETURN_ATTRIBUTE1 ,
p_RETURN_ATTRIBUTE2 => p_l_RETURN_ATTRIBUTE2 ,
p_RETURN_ATTRIBUTE3 => p_l_RETURN_ATTRIBUTE3 ,
p_RETURN_ATTRIBUTE4 => p_l_RETURN_ATTRIBUTE4 ,
p_RETURN_ATTRIBUTE5 => p_l_RETURN_ATTRIBUTE5 ,
p_RETURN_ATTRIBUTE6 => p_l_RETURN_ATTRIBUTE6 ,
p_RETURN_ATTRIBUTE7 => p_l_RETURN_ATTRIBUTE7 ,
p_RETURN_ATTRIBUTE8 => p_l_RETURN_ATTRIBUTE8 ,
p_RETURN_ATTRIBUTE9 => p_l_RETURN_ATTRIBUTE9 ,
p_RETURN_ATTRIBUTE10 => p_l_RETURN_ATTRIBUTE10 ,
p_RETURN_ATTRIBUTE11 => p_l_RETURN_ATTRIBUTE11 ,
p_RETURN_ATTRIBUTE12 => p_l_RETURN_ATTRIBUTE12 ,
p_RETURN_ATTRIBUTE13 => p_l_RETURN_ATTRIBUTE13 ,
p_RETURN_ATTRIBUTE14 => p_l_RETURN_ATTRIBUTE14 ,
p_RETURN_ATTRIBUTE15 => p_l_RETURN_ATTRIBUTE15 ,
p_ACTUAL_ARRIVAL_DATE => p_l_ACTUAL_ARRIVAL_DATE ,
p_ATO_LINE_ID => p_l_ATO_LINE_ID ,
p_AUTO_SELECTED_QUANTITY => p_l_AUTO_SELECTED_QUANTITY ,
p_COMPONENT_NUMBER => p_l_COMPONENT_NUMBER ,
p_EARLIEST_ACCEPTABLE_DATE => p_l_EARLIEST_ACCEPTABLE_DATE ,
p_EXPLOSION_DATE => p_l_EXPLOSION_DATE ,
p_LATEST_ACCEPTABLE_DATE => p_l_LATEST_ACCEPTABLE_DATE ,
p_MODEL_GROUP_NUMBER => p_l_MODEL_GROUP_NUMBER ,
p_SCHEDULE_ARRIVAL_DATE => p_l_SCHEDULE_ARRIVAL_DATE ,
p_SHIP_MODEL_COMPLETE_FLAG => p_l_SHIP_MODEL_COMPLETE_FLAG ,
p_SCHEDULE_STATUS_CODE => p_l_SCHEDULE_STATUS_CODE ,
p_SOURCE_TYPE_CODE => p_l_SOURCE_TYPE_CODE ,
p_CANCELLED_FLAG => p_l_CANCELLED_FLAG ,
p_OPEN_FLAG => p_l_OPEN_FLAG ,
p_BOOKED_FLAG => p_l_BOOKED_FLAG ,
p_SALESREP_ID => p_l_SALESREP_ID ,
p_RETURN_REASON_CODE => p_l_RETURN_REASON_CODE ,
p_ARRIVAL_SET_ID => p_l_ARRIVAL_SET_ID ,
p_SHIP_SET_ID => p_l_SHIP_SET_ID ,
p_SPLIT_FROM_LINE_ID => p_l_SPLIT_FROM_LINE_ID ,
p_CUST_PRODUCTION_SEQ_NUM => p_l_CUST_PRODUCTION_SEQ_NUM ,
p_AUTHORIZED_TO_SHIP_FLAG => p_l_AUTHORIZED_TO_SHIP_FLAG ,
p_OVER_SHIP_REASON_CODE => p_l_OVER_SHIP_REASON_CODE ,
p_OVER_SHIP_RESOLVED_FLAG => p_l_OVER_SHIP_RESOLVED_FLAG ,
p_ORDERED_ITEM_ID => p_l_ORDERED_ITEM_ID ,
p_ITEM_IDENTIFIER_TYPE => p_l_ITEM_IDENTIFIER_TYPE ,
p_CONFIGURATION_ID => p_l_CONFIGURATION_ID ,
p_COMMITMENT_ID => p_l_COMMITMENT_ID ,
p_SHIPPING_INTERFACED_FLAG => p_l_SHIPPING_INTERFACED_FLAG ,
p_CREDIT_INVOICE_LINE_ID => p_l_CREDIT_INVOICE_LINE_ID ,
p_FIRST_ACK_CODE => p_l_FIRST_ACK_CODE ,
p_FIRST_ACK_DATE => p_l_FIRST_ACK_DATE ,
p_LAST_ACK_CODE => p_l_LAST_ACK_CODE ,
p_LAST_ACK_DATE => p_l_LAST_ACK_DATE ,
p_PLANNING_PRIORITY => p_l_PLANNING_PRIORITY ,
p_ORDER_SOURCE_ID => p_l_ORDER_SOURCE_ID ,
p_ORIG_SYS_SHIPMENT_REF => p_l_ORIG_SYS_SHIPMENT_REF ,
p_CHANGE_SEQUENCE => p_l_CHANGE_SEQUENCE ,
p_DROP_SHIP_FLAG => p_l_DROP_SHIP_FLAG ,
p_CUSTOMER_LINE_NUMBER => p_l_CUSTOMER_LINE_NUMBER ,
p_CUSTOMER_SHIPMENT_NUMBER => p_l_CUSTOMER_SHIPMENT_NUMBER ,
p_CUSTOMER_ITEM_NET_PRICE => p_l_CUSTOMER_ITEM_NET_PRICE ,
p_CUSTOMER_PAYMENT_TERM_ID => p_l_CUSTOMER_PAYMENT_TERM_ID ,
p_FULFILLED_FLAG => p_l_FULFILLED_FLAG ,
p_END_ITEM_UNIT_NUMBER => p_l_END_ITEM_UNIT_NUMBER ,
p_CONFIG_HEADER_ID => p_l_CONFIG_HEADER_ID ,
p_CONFIG_REV_NBR => p_l_CONFIG_REV_NBR ,
p_MFG_COMPONENT_SEQUENCE_ID => p_l_MFG_COMPONENT_SEQUENCE_ID ,
p_SHIPPING_INSTRUCTIONS => p_l_SHIPPING_INSTRUCTIONS ,
p_PACKING_INSTRUCTIONS => p_l_PACKING_INSTRUCTIONS ,
p_INVOICED_QUANTITY => p_l_INVOICED_QUANTITY ,
p_REF_CUSTOMER_TRX_LINE_ID => p_l_REF_CUSTOMER_TRX_LINE_ID ,
p_SPLIT_BY => p_l_SPLIT_BY ,
p_LINE_SET_ID => p_l_LINE_SET_ID ,
p_SERVICE_TXN_REASON_CODE => p_l_SERVICE_TXN_REASON_CODE ,
p_SERVICE_TXN_COMMENTS => p_l_SERVICE_TXN_COMMENTS ,
p_SERVICE_DURATION => p_l_SERVICE_DURATION ,
p_SERVICE_START_DATE => p_l_SERVICE_START_DATE ,
p_SERVICE_END_DATE => p_l_SERVICE_END_DATE ,
p_SERVICE_COTERMINATE_FLAG => p_l_SERVICE_COTERMINATE_FLAG ,
p_UNIT_LIST_PERCENT => p_l_UNIT_LIST_PERCENT ,
p_UNIT_SELLING_PERCENT => p_l_UNIT_SELLING_PERCENT ,
p_UNIT_PERCENT_BASE_PRICE => p_l_UNIT_PERCENT_BASE_PRICE ,
p_SERVICE_NUMBER => p_l_SERVICE_NUMBER ,
p_SERVICE_PERIOD => p_l_SERVICE_PERIOD ,
p_SHIPPABLE_FLAG => p_l_SHIPPABLE_FLAG ,
p_MODEL_REMNANT_FLAG => p_l_MODEL_REMNANT_FLAG ,
p_RE_SOURCE_FLAG => p_l_RE_SOURCE_FLAG ,
p_FLOW_STATUS_CODE => p_l_FLOW_STATUS_CODE ,
p_TP_CONTEXT => p_l_TP_CONTEXT ,
p_TP_ATTRIBUTE1 => p_l_TP_ATTRIBUTE1 ,
p_TP_ATTRIBUTE2 => p_l_TP_ATTRIBUTE2 ,
p_TP_ATTRIBUTE3 => p_l_TP_ATTRIBUTE3 ,
p_TP_ATTRIBUTE4 => p_l_TP_ATTRIBUTE4 ,
p_TP_ATTRIBUTE5 => p_l_TP_ATTRIBUTE5 ,
p_TP_ATTRIBUTE6 => p_l_TP_ATTRIBUTE6 ,
p_TP_ATTRIBUTE7 => p_l_TP_ATTRIBUTE7 ,
p_TP_ATTRIBUTE8 => p_l_TP_ATTRIBUTE8 ,
p_TP_ATTRIBUTE9 => p_l_TP_ATTRIBUTE9 ,
p_TP_ATTRIBUTE10 => p_l_TP_ATTRIBUTE10 ,
p_TP_ATTRIBUTE11 => p_l_TP_ATTRIBUTE11 ,
p_TP_ATTRIBUTE12 => p_l_TP_ATTRIBUTE12 ,
p_TP_ATTRIBUTE13 => p_l_TP_ATTRIBUTE13 ,
p_TP_ATTRIBUTE14 => p_l_TP_ATTRIBUTE14 ,
p_TP_ATTRIBUTE15 => p_l_TP_ATTRIBUTE15 ,
p_FULFILLMENT_METHOD_CODE => p_l_FULFILLMENT_METHOD_CODE ,
p_MARKETING_SOURCE_CODE_ID => p_l_MARKETING_SOURCE_CODE_ID ,
p_SERVICE_REF_TYPE_CODE => p_l_SERVICE_REF_TYPE_CODE ,
p_SERVICE_REFERENCE_LINE_ID => p_l_SERVICE_REFERENCE_LINE_ID ,
p_SERVICE_REF_SYSTEM_ID => p_l_SERVICE_REF_SYSTEM_ID ,
p_CALCULATE_PRICE_FLAG => p_l_CALCULATE_PRICE_FLAG ,
p_UPGRADED_FLAG => p_l_UPGRADED_FLAG ,
p_REVENUE_AMOUNT => p_l_REVENUE_AMOUNT ,
p_FULFILLMENT_DATE => p_l_FULFILLMENT_DATE ,
p_PREFERRED_GRADE => p_l_PREFERRED_GRADE ,
p_ORDERED_QUANTITY2 => p_l_ORDERED_QUANTITY2 ,
p_ORDERED_QUANTITY_UOM2 => p_l_ORDERED_QUANTITY_UOM2 ,
p_SHIPPING_QUANTITY2 => p_l_SHIPPING_QUANTITY2 ,
p_CANCELLED_QUANTITY2 => p_l_CANCELLED_QUANTITY2 ,
p_SHIPPED_QUANTITY2 => p_l_SHIPPED_QUANTITY2 ,
p_SHIPPING_QUANTITY_UOM2 => p_l_SHIPPING_QUANTITY_UOM2 ,
p_FULFILLED_QUANTITY2 => p_l_FULFILLED_QUANTITY2 ,
p_MFG_LEAD_TIME => p_l_MFG_LEAD_TIME ,
p_LOCK_CONTROL => p_l_LOCK_CONTROL ,
p_SUBINVENTORY => p_l_SUBINVENTORY ,
p_UNIT_LIST_PRICE_PER_PQTY => p_l_UNIT_LIST_PRICE_PER_PQTY ,
p_UNIT_SELL_PRICE_PER_PQTY => p_l_UNIT_SELL_PRICE_PER_PQTY ,
p_PRICE_REQUEST_CODE => p_l_PRICE_REQUEST_CODE ,
p_ORIGINAL_INVENTORY_ITEM_ID => p_l_ORIGINAL_INVENTORY_ITEM_ID ,
p_ORIGINAL_ORDERED_ITEM_ID => p_l_ORIGINAL_ORDERED_ITEM_ID ,
p_ORIGINAL_ORDERED_ITEM => p_l_ORIGINAL_ORDERED_ITEM ,
p_ORIGINAL_ITEM_IDENTIF_TYPE => p_l_ORIGINAL_ITEM_IDENTIF_TYPE ,
p_ITEM_SUBSTIT_TYPE_CODE => p_l_ITEM_SUBSTIT_TYPE_CODE ,
p_OVERRIDE_ATP_DATE_CODE => p_l_OVERRIDE_ATP_DATE_CODE ,
p_LATE_DEMAND_PENALTY_FACTOR => p_l_LATE_DEMAND_PENALTY_FACTOR ,
p_ACCOUNTING_RULE_DURATION => p_l_ACCOUNTING_RULE_DURATION ,
p_top_model_line_index => p_l_top_model_line_index ,
p_top_model_line_ref => p_l_top_model_line_ref ,
p_unit_cost => p_l_unit_cost ,
p_xml_transaction_type_code => p_l_xml_transaction_type_code ,
p_Sold_to_address_id => p_l_Sold_to_address_id ,
p_Split_Action_Code => p_l_Split_Action_Code ,
p_split_from_line_ref => p_l_split_from_line_ref ,
p_split_from_shipment_ref => p_l_split_from_shipment_ref ,
p_status_flag => p_l_status_flag ,
p_ship_from_edi_loc_code => p_l_ship_from_edi_loc_code ,
p_ship_set => p_l_ship_set ,
p_Ship_to_address_code => p_l_Ship_to_address_code ,
p_Ship_to_address_id => p_l_Ship_to_address_id ,
p_ship_to_customer_id => p_l_ship_to_customer_id ,
p_ship_to_edi_location_code => p_l_ship_to_edi_location_code ,
p_service_ref_line_number => p_l_service_ref_line_number ,
p_service_ref_option_number => p_l_service_ref_option_number ,
p_service_ref_order_number => p_l_service_ref_order_number ,
p_service_ref_ship_number => p_l_service_ref_ship_number ,
p_service_reference_line => p_l_service_reference_line ,
p_service_reference_order => p_l_service_reference_order ,
p_service_reference_system => p_l_service_reference_system ,
p_reserved_quantity => p_l_reserved_quantity ,
p_return_status => p_l_return_status ,
p_schedule_action_code => p_l_schedule_action_code ,
p_service_line_index => p_l_service_line_index ,
p_intermed_ship_to_cont_id => p_l_intermed_ship_to_cont_id ,
p_intermed_ship_to_org_id => p_l_intermed_ship_to_org_id ,
p_Invoice_address_id => p_l_Invoice_address_id ,
p_invoice_to_customer_id => p_l_invoice_to_customer_id ,
p_item_relationship_type => p_l_item_relationship_type ,
p_link_to_line_index => p_l_link_to_line_index ,
p_link_to_line_ref => p_l_link_to_line_ref ,
p_db_flag => p_l_db_flag ,
p_deliver_to_customer_id => p_l_deliver_to_customer_id ,
p_fulfillment_set => p_l_fulfillment_set ,
p_fulfillment_set_id => p_l_fulfillment_set_id ,
p_change_comments => p_l_change_comments ,
p_change_reason => p_l_change_reason ,
p_change_request_code => p_l_change_request_code ,
p_Bill_to_Edi_Location_Code => p_l_Bill_to_Edi_Location_Code ,
p_Blanket_Line_Number => p_l_Blanket_Line_Number ,
p_Blanket_Number => p_l_Blanket_Number ,
p_Blanket_Version_Number => p_l_Blanket_Version_Number ,
p_arrival_set => p_l_arrival_set ,
p_attribute16 => p_l_attribute16 ,
p_attribute17 => p_l_attribute17 ,
p_attribute18 => p_l_attribute18 ,
p_attribute19 => p_l_attribute19 ,
p_attribute20 => p_l_attribute20
);
,x_last_update_date => x_last_update_date
);
,x_last_update_date => x_last_update_date
,X_failed_line_ids => X_failed_line_ids --3272918
);