[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Header_Ack_Code
( p_header_id IN NUMBER,
p_first_ack_code IN VARCHAR2,
p_last_ack_code IN VARCHAR2
)
IS
BEGIN
oe_debug_pub.add ('Entering Update_Header_Ack_Code with params: header id ' ||
p_header_id || ', first_ack_code ' || p_first_ack_code
|| ', last_ack_code ' || p_last_ack_code || '.');
UPDATE oe_header_acks
SET first_ack_code = p_first_ack_code
WHERE header_id = p_header_id;
oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
UPDATE oe_header_acks
SET last_ack_code = p_last_ack_code
WHERE header_id = p_header_id;
oe_debug_pub.add ('rows updated: ' || SQL%ROWCOUNT);
oe_debug_pub.add ('Bad args passed to update_header_ack_code, no header records updated');
oe_debug_pub.add ('When Others in Update_Header_Ack_Code');
END Update_Header_Ack_Code;
PROCEDURE Insert_Row
( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
, p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
, p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type
, p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
, p_buyer_seller_flag IN VARCHAR2
, p_reject_order IN VARCHAR2
, p_ack_type IN VARCHAR2 := NULL
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_line_rec OE_Order_Pub.Line_Rec_Type;
SELECT order_source_id
INTO l_order_source_id
FROM oe_order_headers_all
WHERE header_id = l_line_rec.header_id;
-- the ack code was modified, we should update the header ack code
Update_Header_Ack_Code (l_line_rec.header_id, 'AC', NULL);
SELECT count(*) INTO l_count
FROM OE_LINE_ACKS
WHERE header_id = l_line_rec.header_id
AND line_id = l_line_rec.line_id
AND acknowledgment_flag Is Null
-- Change this condition once ack type is ins for POAO/POCAO
AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR)
AND request_id = l_line_rec.request_id;
SELECT count(*) INTO l_count
FROM OE_LINE_ACKS
WHERE header_id = l_line_rec.header_id
AND line_id = l_line_rec.line_id
AND acknowledgment_flag Is Null
-- Change this condition once ack type is ins for POAO/POCAO
AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(l_line_rec.sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(l_line_val_rec.sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(l_line_rec.change_sequence, FND_API.G_MISS_CHAR);
oe_debug_pub.add('l_count > 0, Calling Delete_Row');
OE_Line_Ack_Util.Delete_Row (p_line_id => l_line_rec.line_id,
p_ack_type => p_ack_type,
p_sold_to_org_id => l_line_rec.sold_to_org_id,
p_sold_to_org => l_line_val_rec.sold_to_org,
p_change_sequence => l_line_rec.change_sequence,
p_request_id => l_line_rec.request_id,
p_header_id => l_line_rec.header_id);
oe_debug_pub.add('l_count <= 0 for line_id, attempting delete by doc ref, line ref and ship ref');
OE_Line_Ack_Util.Delete_Row (p_line_id => NULL,
p_ack_type => p_ack_type,
p_orig_sys_document_ref => l_line_rec.orig_sys_document_ref,
p_orig_sys_line_ref => l_line_rec.orig_sys_line_ref,
p_orig_sys_shipment_ref => l_line_rec.orig_sys_shipment_ref,
p_sold_to_org_id => l_line_rec.sold_to_org_id,
p_sold_to_org => l_line_val_rec.sold_to_org,
p_change_sequence => l_line_rec.change_sequence,
p_request_id => l_line_rec.request_id,
p_header_id => NULL
);
oe_debug_pub.add('inserting line ack record for'||
' source id: ' ||to_char(l_line_rec.order_source_id)||
', order ref: ' ||l_line_rec.orig_sys_document_ref||
', line ref: ' ||l_line_rec.orig_sys_line_ref||
', line id: ' ||to_char(l_line_rec.line_id)||
', line no: ' ||to_char(l_line_rec.line_number)||
', shipment no: '||to_char(l_line_rec.shipment_number)||
', option no: ' ||to_char(l_line_rec.option_number));
SELECT orig_sys_line_ref, orig_sys_shipment_ref
INTO l_line_rec.split_from_line_ref, l_line_rec.split_from_shipment_ref
FROM OE_ORDER_LINES
WHERE line_id = l_line_rec.split_from_line_id;
INSERT INTO OE_LINE_ACKS
(
ACCOUNTING_RULE
,ACCOUNTING_RULE_ID
,ACCOUNTING_RULE_DURATION
,ACKNOWLEDGMENT_FLAG
,ACTUAL_ARRIVAL_DATE
,ACTUAL_SHIPMENT_DATE
,AGREEMENT
,AGREEMENT_ID
,ARRIVAL_SET_ID
-- ,ARRIVAL_SET_NAME
,ATO_LINE_ID
,ATTRIBUTE1
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16 --For bug 2184255
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE2
,ATTRIBUTE20
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,AUTHORIZED_TO_SHIP_FLAG
,BUYER_SELLER_FLAG
,BOOKED_FLAG
-- ,CALCULATE_PRICE_FLAG
,CANCELLED_FLAG
,CANCELLED_QUANTITY
,CHANGE_DATE
,CHANGE_SEQUENCE
-- ,CLOSED_FLAG
,COMPONENT_CODE
,COMPONENT_NUMBER
,COMPONENT_SEQUENCE_ID
,CONFIG_DISPLAY_SEQUENCE
-- ,CONFIG_LINE_REF
,CONFIGURATION_ID
,TOP_MODEL_LINE_ID
,CONTEXT
,CREATED_BY
,CREATION_DATE
,CUST_MODEL_SERIAL_NUMBER
,CUST_PO_NUMBER
,CUST_PRODUCTION_SEQ_NUM
,CUSTOMER_DOCK_CODE
,CUSTOMER_ITEM
,CUSTOMER_ITEM_ID -- 11/03
,ORDERED_ITEM
-- ,CUSTOMER_ITEM_REVISION 11/03
, CUSTOMER_JOB
,CUSTOMER_PRODUCTION_LINE
,CUSTOMER_TRX_LINE_ID
-- ,DELIVER_TO_CONTACT
,DELIVER_TO_CONTACT_ID
,DELIVER_TO_ORG
,DELIVER_TO_ORG_ID
,DELIVERY_LEAD_TIME
,DEMAND_BUCKET_TYPE
,DEMAND_BUCKET_TYPE_CODE
-- ,DEMAND_CLASS
,DEMAND_CLASS_CODE
-- ,DEMAND_STREAM
,DEP_PLAN_REQUIRED_FLAG
-- ,DPW_ASSIGNED_FLAG
,EARLIEST_ACCEPTABLE_DATE
,EXPLOSION_DATE
,FIRST_ACK_CODE
,FIRST_ACK_DATE
,FOB_POINT
,FOB_POINT_CODE
,FREIGHT_CARRIER_CODE
,FREIGHT_TERMS
,FREIGHT_TERMS_CODE
,FULFILLED_QUANTITY
-- ,FULFILLMENT_SET_ID
-- ,FULFILLMENT_SET_NAME
,GLOBAL_ATTRIBUTE_CATEGORY
,GLOBAL_ATTRIBUTE1
,GLOBAL_ATTRIBUTE10
,GLOBAL_ATTRIBUTE11
,GLOBAL_ATTRIBUTE12
,GLOBAL_ATTRIBUTE13
,GLOBAL_ATTRIBUTE14
,GLOBAL_ATTRIBUTE15
,GLOBAL_ATTRIBUTE16
,GLOBAL_ATTRIBUTE17
,GLOBAL_ATTRIBUTE18
,GLOBAL_ATTRIBUTE19
,GLOBAL_ATTRIBUTE2
,GLOBAL_ATTRIBUTE20
,GLOBAL_ATTRIBUTE3
,GLOBAL_ATTRIBUTE4
,GLOBAL_ATTRIBUTE5
,GLOBAL_ATTRIBUTE6
,GLOBAL_ATTRIBUTE7
,GLOBAL_ATTRIBUTE8
,GLOBAL_ATTRIBUTE9
,HEADER_ID
,INDUSTRY_ATTRIBUTE1
,INDUSTRY_ATTRIBUTE10
,INDUSTRY_ATTRIBUTE11
,INDUSTRY_ATTRIBUTE12
,INDUSTRY_ATTRIBUTE13
,INDUSTRY_ATTRIBUTE14
,INDUSTRY_ATTRIBUTE15
,INDUSTRY_ATTRIBUTE16
,INDUSTRY_ATTRIBUTE17
,INDUSTRY_ATTRIBUTE18
,INDUSTRY_ATTRIBUTE19
,INDUSTRY_ATTRIBUTE2
,INDUSTRY_ATTRIBUTE20
,INDUSTRY_ATTRIBUTE21
,INDUSTRY_ATTRIBUTE22
,INDUSTRY_ATTRIBUTE23
,INDUSTRY_ATTRIBUTE24
,INDUSTRY_ATTRIBUTE25
,INDUSTRY_ATTRIBUTE26
,INDUSTRY_ATTRIBUTE27
,INDUSTRY_ATTRIBUTE28
,INDUSTRY_ATTRIBUTE29
,INDUSTRY_ATTRIBUTE3
,INDUSTRY_ATTRIBUTE30
,INDUSTRY_ATTRIBUTE4
,INDUSTRY_ATTRIBUTE5
,INDUSTRY_ATTRIBUTE6
,INDUSTRY_ATTRIBUTE7
,INDUSTRY_ATTRIBUTE8
,INDUSTRY_ATTRIBUTE9
,INDUSTRY_CONTEXT
,TP_CONTEXT
,TP_ATTRIBUTE1
,TP_ATTRIBUTE2
,TP_ATTRIBUTE3
,TP_ATTRIBUTE4
,TP_ATTRIBUTE5
,TP_ATTRIBUTE6
,TP_ATTRIBUTE7
,TP_ATTRIBUTE8
,TP_ATTRIBUTE9
,TP_ATTRIBUTE10
,TP_ATTRIBUTE11
,TP_ATTRIBUTE12
,TP_ATTRIBUTE13
,TP_ATTRIBUTE14
,TP_ATTRIBUTE15
,INTMED_SHIP_TO_CONTACT_ID
,INTMED_SHIP_TO_ORG_ID
,INVENTORY_ITEM
,INVENTORY_ITEM_ID
-- ,INVOICE_COMPLETE_FLAG 11/03
-- ,INVOICE_SET_ID
-- ,INVOICE_SET_NAME
-- ,INVOICE_NUMBER
,INVOICE_TO_CONTACT
,INVOICE_TO_CONTACT_ID
,INVOICE_TO_ORG
,INVOICE_TO_ORG_ID
-- ,INVOICE_TOLERANCE_ABOVE
-- ,INVOICE_TOLERANCE_BELOW
,INVOICING_RULE
,INVOICING_RULE_ID
,ITEM_INPUT
,ITEM_REVISION
,ITEM_TYPE_CODE
,LAST_ACK_CODE
,LAST_ACK_DATE
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,LAST_UPDATED_BY
,LATEST_ACCEPTABLE_DATE
,LINE_CATEGORY_CODE
,LINE_ID
,LINE_NUMBER
-- ,LINE_PO_CONTEXT
,LINE_TYPE
,LINE_TYPE_ID
,LINK_TO_LINE_ID
-- ,LINK_TO_LINE_REF
-- ,LOT
,MODEL_GROUP_NUMBER
,OPEN_FLAG
,OPERATION_CODE
,OPTION_FLAG
,OPTION_NUMBER
,ORDER_QUANTITY_UOM
,ORDER_SOURCE_ID
,ORDERED_QUANTITY
,ORG_ID
,ORIG_SYS_DOCUMENT_REF
,ORIG_SYS_LINE_REF
,ORIG_SYS_SHIPMENT_REF
,OVER_SHIP_REASON_CODE
,OVER_SHIP_RESOLVED_FLAG
,PAYMENT_TERM
,PAYMENT_TERM_ID
,PRICE_LIST
,PRICE_LIST_ID
,PRICING_ATTRIBUTE1
,PRICING_ATTRIBUTE10
,PRICING_ATTRIBUTE2
,PRICING_ATTRIBUTE3
,PRICING_ATTRIBUTE4
,PRICING_ATTRIBUTE5
,PRICING_ATTRIBUTE6
,PRICING_ATTRIBUTE7
,PRICING_ATTRIBUTE8
,PRICING_ATTRIBUTE9
,PRICING_CONTEXT
,PRICING_DATE
,PRICING_QUANTITY
,PRICING_QUANTITY_UOM
-- ,PROGRAM
-- ,PROGRAM_APPLICATION
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,PROJECT
,PROJECT_ID
,PROMISE_DATE
-- ,REFERENCE_HEADER
,REFERENCE_HEADER_ID
-- ,REFERENCE_LINE
,REFERENCE_LINE_ID
,REFERENCE_TYPE
-- ,RELATED_PO_NUMBER
,REQUEST_DATE
,REQUEST_ID
,RESERVED_QUANTITY
,RETURN_ATTRIBUTE1
,RETURN_ATTRIBUTE10
,RETURN_ATTRIBUTE11
,RETURN_ATTRIBUTE12
,RETURN_ATTRIBUTE13
,RETURN_ATTRIBUTE14
,RETURN_ATTRIBUTE15
,RETURN_ATTRIBUTE2
,RETURN_ATTRIBUTE3
,RETURN_ATTRIBUTE4
,RETURN_ATTRIBUTE5
,RETURN_ATTRIBUTE6
,RETURN_ATTRIBUTE7
,RETURN_ATTRIBUTE8
,RETURN_ATTRIBUTE9
,RETURN_CONTEXT
,RETURN_REASON_CODE
,RLA_SCHEDULE_TYPE_CODE
,SALESREP_ID
,SALESREP
,SCHEDULE_ARRIVAL_DATE
,SCHEDULE_SHIP_DATE
-- ,SCHEDULE_ITEM_DETAIL
,SCHEDULE_STATUS_CODE
,SHIP_FROM_ORG
,SHIP_FROM_ORG_ID
,SHIP_MODEL_COMPLETE_FLAG
,SHIP_SET_ID
-- ,SHIP_SET_NAME
,SHIP_TO_ADDRESS1
,SHIP_TO_ADDRESS2
,SHIP_TO_ADDRESS3
,SHIP_TO_ADDRESS4
,SHIP_TO_CITY
,SHIP_TO_CONTACT
-- ,SHIP_TO_CONTACT_AREA_CODE1
-- ,SHIP_TO_CONTACT_AREA_CODE2
-- ,SHIP_TO_CONTACT_AREA_CODE3
,SHIP_TO_CONTACT_FIRST_NAME
,SHIP_TO_CONTACT_ID
-- ,SHIP_TO_CONTACT_JOB_TITLE
,SHIP_TO_CONTACT_LAST_NAME
,SHIP_TO_COUNTRY
,SHIP_TO_COUNTY
,SHIP_TO_ORG
,SHIP_TO_ORG_ID
,SHIP_TO_POSTAL_CODE
,SHIP_TO_STATE
,SHIP_TOLERANCE_ABOVE
,SHIP_TOLERANCE_BELOW
,SHIPMENT_NUMBER
,SHIPMENT_PRIORITY
,SHIPMENT_PRIORITY_CODE
,SHIPPED_QUANTITY
-- ,SHIPPING_METHOD
,SHIPPING_METHOD_CODE
,SHIPPING_QUANTITY
,SHIPPING_QUANTITY_UOM
-- ,SOLD_FROM_ORG
-- ,SOLD_FROM_ORG_ID
,SOLD_TO_ORG
,SOLD_TO_ORG_ID
,SORT_ORDER
,SOURCE_DOCUMENT_ID
,SOURCE_DOCUMENT_LINE_ID
,SOURCE_DOCUMENT_TYPE_ID
,SOURCE_TYPE_CODE
,SPLIT_FROM_LINE_ID
-- ,SUBINVENTORY
-- ,SUBMISSION_DATETIME
,TASK
,TASK_ID
-- ,TAX
,TAX_CODE
,TAX_DATE
,TAX_EXEMPT_FLAG
,TAX_EXEMPT_NUMBER
,TAX_EXEMPT_REASON
,TAX_EXEMPT_REASON_CODE
,TAX_POINT
,TAX_POINT_CODE
,TAX_RATE
,TAX_VALUE
,UNIT_LIST_PRICE
,UNIT_SELLING_PRICE
,VEH_CUS_ITEM_CUM_KEY_ID
,VISIBLE_DEMAND_FLAG
,split_from_line_ref
,split_from_shipment_ref
,SHIP_TO_EDI_LOCATION_CODE
,Service_Txn_Reason_Code
,Service_Txn_Comments
,Service_Duration
,Service_Start_Date
,Service_End_Date
,Service_Coterminate_Flag
,Service_Number
,Service_Period
,Service_Reference_Type_Code
,Service_Reference_Line_Id
,Service_Reference_System_Id
,Credit_Invoice_Line_Id
,Ship_to_Province
,Invoice_Province
,Bill_to_Edi_Location_Code
,Invoice_City
,ship_from_edi_location_code
,SHIP_FROM_ADDRESS_1
,SHIP_FROM_ADDRESS_2
,SHIP_FROM_ADDRESS_3
,SHIP_FROM_CITY
,SHIP_FROM_POSTAL_CODE
,SHIP_FROM_COUNTRY
,SHIP_FROM_REGION1
,SHIP_FROM_REGION2
,SHIP_FROM_REGION3
,SHIP_FROM_ADDRESS_ID
,SHIP_TO_ADDRESS_ID
,SHIP_TO_ADDRESS_CODE
,service_reference_line
,service_reference_order
,service_reference_system
-- ,order_source
,customer_line_number
,CUSTOMER_ITEM_NET_PRICE --bug#5733732
,user_item_description
,acknowledgment_type
,blanket_number
,blanket_line_number
,original_inventory_item_id
,original_ordered_item_id
,original_ordered_item
,original_item_identifier_type
,item_relationship_type
,error_flag
,customer_shipment_number
-- { Distributer Order related change
,end_customer_id
,end_customer_contact_id
,end_customer_site_use_id
,ib_owner
,ib_current_location
,ib_installed_at_location
-- Distributer Order related change }
,charge_periodicity_code
,end_customer_name
,end_customer_number
,end_customer_contact
,end_customer_address1
,end_customer_address2
,end_customer_address3
,end_customer_address4
,end_customer_city
,end_customer_state
,end_customer_postal_code
,end_customer_country
--Sol_ord_er #16014165 start
, SERVICE_BILL_PROFILE_ID
, SERVICE_COV_TEMPLATE_ID
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_BILL_OPTION
, SERVICE_BILLING_PROFILE
, SERVICE_COVERAGE_TEMPLATE
, SERVICE_SUBSCRIPTION_TEMPLATE
, SERVICE_BILL_OPTION_CODE
, SERVICE_FIRST_PERIOD_AMOUNT
, SUBSCRIPTION_ENABLE_FLAG
,SERVICE_FIRST_PERIOD_ENDDATE
--Sol_ord_er #16014165 end
)
VALUES
(
l_line_val_rec.ACCOUNTING_RULE
, l_line_rec.ACCOUNTING_RULE_ID
, l_line_rec.ACCOUNTING_RULE_DURATION
, '' -- ACKNOWLEDGMENT_FLAG
, l_line_rec.ACTUAL_ARRIVAL_DATE
, l_line_rec.ACTUAL_SHIPMENT_DATE
, l_line_val_rec.AGREEMENT
, l_line_rec.AGREEMENT_ID
, l_line_rec.ARRIVAL_SET_ID
-- , l_line_rec.ARRIVAL_SET_NAME
, l_line_rec.ATO_LINE_ID
, l_line_rec.ATTRIBUTE1
, l_line_rec.ATTRIBUTE10
, l_line_rec.ATTRIBUTE11
, l_line_rec.ATTRIBUTE12
, l_line_rec.ATTRIBUTE13
, l_line_rec.ATTRIBUTE14
, l_line_rec.ATTRIBUTE15
, l_line_rec.ATTRIBUTE16 --For bug 2184255
, l_line_rec.ATTRIBUTE17
, l_line_rec.ATTRIBUTE18
, l_line_rec.ATTRIBUTE19
, l_line_rec.ATTRIBUTE2
, l_line_rec.ATTRIBUTE20
, l_line_rec.ATTRIBUTE3
, l_line_rec.ATTRIBUTE4
, l_line_rec.ATTRIBUTE5
, l_line_rec.ATTRIBUTE6
, l_line_rec.ATTRIBUTE7
, l_line_rec.ATTRIBUTE8
, l_line_rec.ATTRIBUTE9
, l_line_rec.AUTHORIZED_TO_SHIP_FLAG
, p_buyer_seller_flag
, l_line_rec.BOOKED_FLAG
-- , l_line_rec.CALCULATE_PRICE_FLAG
, l_line_rec.CANCELLED_FLAG
, l_line_rec.CANCELLED_QUANTITY
, '' -- CHANGE_DATE
, l_line_rec.CHANGE_SEQUENCE
-- , l_line_rec.CLOSED_FLAG
, l_line_rec.COMPONENT_CODE
, l_line_rec.COMPONENT_NUMBER
, l_line_rec.COMPONENT_SEQUENCE_ID
, l_line_rec.CONFIG_DISPLAY_SEQUENCE
-- , l_line_rec.CONFIG_LINE_REF
, l_line_rec.CONFIGURATION_ID
, l_line_rec.TOP_MODEL_LINE_ID
, l_line_rec.CONTEXT
, l_line_rec.CREATED_BY
, l_line_rec.CREATION_DATE
, l_line_rec.CUST_MODEL_SERIAL_NUMBER
, l_line_rec.CUST_PO_NUMBER
, l_line_rec.CUST_PRODUCTION_SEQ_NUM
, l_line_rec.CUSTOMER_DOCK_CODE
, decode ( l_line_rec.item_identifier_type ,'CUST', l_line_rec.ORDERED_ITEM,NULL) --bug8477822
, decode ( l_line_rec.item_identifier_type ,'CUST', l_line_rec.ORDERED_ITEM_ID,NULL) --bug8477822 -- CUSTOMER_ITEM_ID Added for bug 4404309
, l_line_rec.ORDERED_ITEM --bug8477822
-- , l_line_rec.CUSTOMER_ITEM_REVISION
, l_line_rec.CUSTOMER_JOB
, l_line_rec.CUSTOMER_PRODUCTION_LINE
, l_line_rec.CUSTOMER_TRX_LINE_ID
-- , l_line_rec.DELIVER_TO_CONTACT
, l_line_rec.DELIVER_TO_CONTACT_ID
, l_line_val_rec.DELIVER_TO_ORG
, l_line_rec.DELIVER_TO_ORG_ID
, l_line_rec.DELIVERY_LEAD_TIME
, l_line_val_rec.DEMAND_BUCKET_TYPE
, l_line_rec.DEMAND_BUCKET_TYPE_CODE
-- , l_line_rec.DEMAND_CLASS
, l_line_rec.DEMAND_CLASS_CODE
-- , l_line_rec.DEMAND_STREAM
, l_line_rec.DEP_PLAN_REQUIRED_FLAG
, l_line_rec.EARLIEST_ACCEPTABLE_DATE
, l_line_rec.EXPLOSION_DATE
, l_line_rec.FIRST_ACK_CODE
, l_line_rec.FIRST_ACK_DATE
, l_line_val_rec.FOB_POINT
, l_line_rec.FOB_POINT_CODE
, l_line_rec.FREIGHT_CARRIER_CODE
, l_line_val_rec.FREIGHT_TERMS
, l_line_rec.FREIGHT_TERMS_CODE
, l_line_rec.FULFILLED_QUANTITY
-- , l_line_rec.FULFILLMENT_SET_ID
-- , l_line_rec.FULFILLMENT_SET_NAME
, l_line_rec.GLOBAL_ATTRIBUTE_CATEGORY
, l_line_rec.GLOBAL_ATTRIBUTE1
, l_line_rec.GLOBAL_ATTRIBUTE10
, l_line_rec.GLOBAL_ATTRIBUTE11
, l_line_rec.GLOBAL_ATTRIBUTE12
, l_line_rec.GLOBAL_ATTRIBUTE13
, l_line_rec.GLOBAL_ATTRIBUTE14
, l_line_rec.GLOBAL_ATTRIBUTE15
, l_line_rec.GLOBAL_ATTRIBUTE16
, l_line_rec.GLOBAL_ATTRIBUTE17
, l_line_rec.GLOBAL_ATTRIBUTE18
, l_line_rec.GLOBAL_ATTRIBUTE19
, l_line_rec.GLOBAL_ATTRIBUTE2
, l_line_rec.GLOBAL_ATTRIBUTE20
, l_line_rec.GLOBAL_ATTRIBUTE3
, l_line_rec.GLOBAL_ATTRIBUTE4
, l_line_rec.GLOBAL_ATTRIBUTE5
, l_line_rec.GLOBAL_ATTRIBUTE6
, l_line_rec.GLOBAL_ATTRIBUTE7
, l_line_rec.GLOBAL_ATTRIBUTE8
, l_line_rec.GLOBAL_ATTRIBUTE9
, l_line_rec.HEADER_ID
, l_line_rec.INDUSTRY_ATTRIBUTE1
, l_line_rec.INDUSTRY_ATTRIBUTE10
, l_line_rec.INDUSTRY_ATTRIBUTE11
, l_line_rec.INDUSTRY_ATTRIBUTE12
, l_line_rec.INDUSTRY_ATTRIBUTE13
, l_line_rec.INDUSTRY_ATTRIBUTE14
, l_line_rec.INDUSTRY_ATTRIBUTE15
, l_line_rec.INDUSTRY_ATTRIBUTE16
, l_line_rec.INDUSTRY_ATTRIBUTE17
, l_line_rec.INDUSTRY_ATTRIBUTE18
, l_line_rec.INDUSTRY_ATTRIBUTE19
, l_line_rec.INDUSTRY_ATTRIBUTE2
, l_line_rec.INDUSTRY_ATTRIBUTE20
, l_line_rec.INDUSTRY_ATTRIBUTE21
, l_line_rec.INDUSTRY_ATTRIBUTE22
, l_line_rec.INDUSTRY_ATTRIBUTE23
, l_line_rec.INDUSTRY_ATTRIBUTE24
, l_line_rec.INDUSTRY_ATTRIBUTE25
, l_line_rec.INDUSTRY_ATTRIBUTE26
, l_line_rec.INDUSTRY_ATTRIBUTE27
, l_line_rec.INDUSTRY_ATTRIBUTE28
, l_line_rec.INDUSTRY_ATTRIBUTE29
, l_line_rec.INDUSTRY_ATTRIBUTE3
, l_line_rec.INDUSTRY_ATTRIBUTE30
, l_line_rec.INDUSTRY_ATTRIBUTE4
, l_line_rec.INDUSTRY_ATTRIBUTE5
, l_line_rec.INDUSTRY_ATTRIBUTE6
, l_line_rec.INDUSTRY_ATTRIBUTE7
, l_line_rec.INDUSTRY_ATTRIBUTE8
, l_line_rec.INDUSTRY_ATTRIBUTE9
, l_line_rec.INDUSTRY_CONTEXT
, l_line_rec.TP_CONTEXT
, l_line_rec.TP_ATTRIBUTE1
, l_line_rec.TP_ATTRIBUTE2
, l_line_rec.TP_ATTRIBUTE3
, l_line_rec.TP_ATTRIBUTE4
, l_line_rec.TP_ATTRIBUTE5
, l_line_rec.TP_ATTRIBUTE6
, l_line_rec.TP_ATTRIBUTE7
, l_line_rec.TP_ATTRIBUTE8
, l_line_rec.TP_ATTRIBUTE9
, l_line_rec.TP_ATTRIBUTE10
, l_line_rec.TP_ATTRIBUTE11
, l_line_rec.TP_ATTRIBUTE12
, l_line_rec.TP_ATTRIBUTE13
, l_line_rec.TP_ATTRIBUTE14
, l_line_rec.TP_ATTRIBUTE15
, l_line_rec.INTERMED_SHIP_TO_CONTACT_ID
, l_line_rec.INTERMED_SHIP_TO_ORG_ID
, l_line_val_rec.INVENTORY_ITEM
, l_line_rec.INVENTORY_ITEM_ID
-- , l_line_rec.INVOICE_COMPLETE_FLAG 11/03
-- , l_line_rec.INVOICE_SET_ID
-- , l_line_rec.INVOICE_SET_NAME
-- , l_line_rec.INVOICE_NUMBER
, l_line_val_rec.INVOICE_TO_CONTACT
, l_line_rec.INVOICE_TO_CONTACT_ID
, l_line_val_rec.INVOICE_TO_ORG
, l_line_rec.INVOICE_TO_ORG_ID
-- , ???().INVOICE_TOLERANCE_ABOVE
-- , ???().INVOICE_TOLERANCE_BELOW
, l_line_val_rec.INVOICING_RULE
, l_line_rec.INVOICING_RULE_ID
, l_line_rec.ORDERED_ITEM
, l_line_rec.ITEM_REVISION
, l_line_rec.item_identifier_type --ITEM_TYPE_CODE
, l_line_rec.LAST_ACK_CODE
, l_line_rec.LAST_ACK_DATE
, l_line_rec.LAST_UPDATE_DATE
, l_line_rec.LAST_UPDATE_LOGIN
, l_line_rec.LAST_UPDATED_BY
, l_line_rec.LATEST_ACCEPTABLE_DATE
, l_line_rec.LINE_CATEGORY_CODE
, l_line_rec.LINE_ID
, l_line_rec.LINE_NUMBER
-- , l_line_rec.LINE_PO_CONTEXT
, l_line_val_rec.LINE_TYPE
, l_line_rec.LINE_TYPE_ID
, l_line_rec.LINK_TO_LINE_ID
-- , l_line_rec.LINK_TO_LINE_REF
-- , ???().LOT
, l_line_rec.MODEL_GROUP_NUMBER
, l_line_rec.OPEN_FLAG
, l_line_rec.OPERATION
, l_line_rec.OPTION_FLAG
, l_line_rec.OPTION_NUMBER
, l_line_rec.ORDER_QUANTITY_UOM
, l_line_rec.ORDER_SOURCE_ID
, l_line_rec.ORDERED_QUANTITY
, l_line_rec.ORG_ID
, l_line_rec.ORIG_SYS_DOCUMENT_REF
, l_line_rec.ORIG_SYS_LINE_REF
, l_line_rec.ORIG_SYS_SHIPMENT_REF
, l_line_rec.OVER_SHIP_REASON_CODE
, l_line_rec.OVER_SHIP_RESOLVED_FLAG
, l_line_val_rec.PAYMENT_TERM
, l_line_rec.PAYMENT_TERM_ID
, l_line_val_rec.PRICE_LIST
, l_line_rec.PRICE_LIST_ID
, l_line_rec.PRICING_ATTRIBUTE1
, l_line_rec.PRICING_ATTRIBUTE10
, l_line_rec.PRICING_ATTRIBUTE2
, l_line_rec.PRICING_ATTRIBUTE3
, l_line_rec.PRICING_ATTRIBUTE4
, l_line_rec.PRICING_ATTRIBUTE5
, l_line_rec.PRICING_ATTRIBUTE6
, l_line_rec.PRICING_ATTRIBUTE7
, l_line_rec.PRICING_ATTRIBUTE8
, l_line_rec.PRICING_ATTRIBUTE9
, l_line_rec.PRICING_CONTEXT
, l_line_rec.PRICING_DATE
, l_line_rec.PRICING_QUANTITY
, l_line_rec.PRICING_QUANTITY_UOM
-- , ???().PROGRAM
-- , ???().PROGRAM_APPLICATION
, l_line_rec.PROGRAM_APPLICATION_ID
, l_line_rec.PROGRAM_ID
, l_line_rec.PROGRAM_UPDATE_DATE
, l_line_val_rec.PROJECT
, l_line_rec.PROJECT_ID
, l_line_rec.PROMISE_DATE
-- , l_line_rec.REFERENCE_HEADER
, l_line_rec.REFERENCE_HEADER_ID
-- , l_line_rec.REFERENCE_LINE
, l_line_rec.REFERENCE_LINE_ID
, l_line_rec.REFERENCE_TYPE
, l_line_rec.REQUEST_DATE
, l_line_rec.REQUEST_ID
, l_line_rec.RESERVED_QUANTITY
, l_line_rec.RETURN_ATTRIBUTE1
, l_line_rec.RETURN_ATTRIBUTE10
, l_line_rec.RETURN_ATTRIBUTE11
, l_line_rec.RETURN_ATTRIBUTE12
, l_line_rec.RETURN_ATTRIBUTE13
, l_line_rec.RETURN_ATTRIBUTE14
, l_line_rec.RETURN_ATTRIBUTE15
, l_line_rec.RETURN_ATTRIBUTE2
, l_line_rec.RETURN_ATTRIBUTE3
, l_line_rec.RETURN_ATTRIBUTE4
, l_line_rec.RETURN_ATTRIBUTE5
, l_line_rec.RETURN_ATTRIBUTE6
, l_line_rec.RETURN_ATTRIBUTE7
, l_line_rec.RETURN_ATTRIBUTE8
, l_line_rec.RETURN_ATTRIBUTE9
, l_line_rec.RETURN_CONTEXT
, l_line_rec.RETURN_REASON_CODE
, l_line_rec.RLA_SCHEDULE_TYPE_CODE
, l_line_rec.SALESREP_ID
, l_line_val_rec.SALESREP
, l_line_rec.SCHEDULE_ARRIVAL_DATE
, l_line_rec.SCHEDULE_SHIP_DATE
-- , l_line_rec.SCHEDULE_ITEM_DETAIL
, l_line_rec.SCHEDULE_STATUS_CODE
, l_line_val_rec.SHIP_FROM_ORG
, l_line_rec.SHIP_FROM_ORG_ID
, l_line_rec.SHIP_MODEL_COMPLETE_FLAG
, l_line_rec.SHIP_SET_ID
-- , l_line_rec.SHIP_SET_NAME
, l_line_val_rec.SHIP_TO_ADDRESS1
, l_line_val_rec.SHIP_TO_ADDRESS2
, l_line_val_rec.SHIP_TO_ADDRESS3
, l_line_val_rec.SHIP_TO_ADDRESS4
, l_line_val_rec.SHIP_TO_CITY
, l_line_val_rec.SHIP_TO_CONTACT
-- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE1
-- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE2
-- , l_line_rec.SHIP_TO_CONTACT_AREA_CODE3
, l_line_val_rec.SHIP_TO_CONTACT_FIRST_NAME
, l_line_rec.SHIP_TO_CONTACT_ID
-- , l_line_rec.SHIP_TO_CONTACT_JOB_TITLE
, l_line_val_rec.SHIP_TO_CONTACT_LAST_NAME
, l_line_val_rec.SHIP_TO_COUNTRY
, l_line_val_rec.SHIP_TO_COUNTY
, l_line_val_rec.SHIP_TO_ORG
, l_line_rec.SHIP_TO_ORG_ID
, l_line_val_rec.SHIP_TO_zip
, l_line_val_rec.SHIP_TO_STATE
, l_line_rec.SHIP_TOLERANCE_ABOVE
, l_line_rec.SHIP_TOLERANCE_BELOW
, l_line_rec.SHIPMENT_NUMBER
, l_line_val_rec.SHIPMENT_PRIORITY
, l_line_rec.SHIPMENT_PRIORITY_CODE
, l_line_rec.SHIPPED_QUANTITY
-- , l_line_rec.SHIPPING_METHOD
, l_line_rec.SHIPPING_METHOD_CODE
, l_line_rec.SHIPPING_QUANTITY
, l_line_rec.SHIPPING_QUANTITY_UOM
-- , ???().SOLD_FROM_ORG
-- , ???().SOLD_FROM_ORG_ID
, l_line_val_rec.SOLD_TO_ORG
, l_line_rec.SOLD_TO_ORG_ID
, l_line_rec.SORT_ORDER
, l_line_rec.SOURCE_DOCUMENT_ID
, l_line_rec.SOURCE_DOCUMENT_LINE_ID
, l_line_rec.SOURCE_DOCUMENT_TYPE_ID
, l_line_rec.SOURCE_TYPE_CODE
, l_line_rec.SPLIT_FROM_LINE_ID
-- , ???.SUBINVENTORY
-- , ???.SUBMISSION_DATETIME
, l_line_val_rec.TASK
, l_line_rec.TASK_ID
-- , l_line_rec.TAX
, l_line_rec.TAX_CODE
, l_line_rec.TAX_DATE
, l_line_rec.TAX_EXEMPT_FLAG
, l_line_rec.TAX_EXEMPT_NUMBER
, l_line_val_rec.TAX_EXEMPT_REASON
, l_line_rec.TAX_EXEMPT_REASON_CODE
, l_line_val_rec.TAX_POINT
, l_line_rec.TAX_POINT_CODE
, l_line_rec.TAX_RATE
, l_line_rec.TAX_VALUE
, l_line_rec.UNIT_LIST_PRICE
, l_line_rec.UNIT_SELLING_PRICE
, l_line_rec.VEH_CUS_ITEM_CUM_KEY_ID
, l_line_rec.VISIBLE_DEMAND_FLAG
, l_line_rec.split_from_line_ref
, l_line_rec.split_from_shipment_ref
, l_line_rec.SHIP_TO_EDI_LOCATION_CODE
, l_line_rec.Service_Txn_Reason_Code
, l_line_rec.Service_Txn_Comments
, l_line_rec.Service_Duration
, l_line_rec.Service_Start_Date
, l_line_rec.Service_End_Date
, l_line_rec.Service_Coterminate_Flag
, l_line_rec.Service_Number
, l_line_rec.Service_Period
, l_line_rec.Service_Reference_Type_Code
, l_line_rec.Service_Reference_Line_Id
, l_line_rec.Service_Reference_System_Id
, l_line_rec.Credit_Invoice_Line_Id
, l_line_val_rec.Ship_to_Province
, l_line_val_rec.Invoice_to_Province
, l_line_rec.Bill_to_Edi_Location_Code
, l_line_val_rec.Invoice_To_City
, l_line_rec.ship_from_edi_location_code
, l_line_val_rec.SHIP_FROM_ADDRESS1
, l_line_val_rec.SHIP_FROM_ADDRESS2
, l_line_val_rec.SHIP_FROM_ADDRESS3
, l_line_val_rec.SHIP_FROM_CITY
, l_line_val_rec.SHIP_FROM_POSTAL_CODE
, l_line_val_rec.SHIP_FROM_COUNTRY
, l_line_val_rec.SHIP_FROM_REGION1
, l_line_val_rec.SHIP_FROM_REGION2
, l_line_val_rec.SHIP_FROM_REGION3
, l_line_rec.SHIP_FROM_ADDRESS_ID
, l_line_rec.SHIP_TO_ADDRESS_ID
, l_line_val_rec.SHIP_TO_LOCATION
, l_line_rec.service_reference_line
, l_line_rec.service_reference_order
, l_line_rec.service_reference_system
-- , l_line_val_rec.order_source
, l_line_rec.customer_line_number
, l_line_rec.CUSTOMER_ITEM_NET_PRICE --bug#5733732
, l_line_rec.user_item_description
, p_ack_type
, l_line_rec.blanket_number
, l_line_rec.blanket_line_number
, l_line_rec.original_inventory_item_id
, l_line_rec.original_ordered_item_id
, l_line_rec.original_ordered_item
, l_line_rec.original_item_identifier_type
, l_line_rec.item_relationship_type
, l_error_flag
, l_line_rec.customer_shipment_number
-- { Distributer Order related change
, l_line_rec.end_customer_id
, l_line_rec.end_customer_contact_id
, l_line_rec.end_customer_site_use_id
, l_line_rec.ib_owner
, l_line_rec.ib_current_location
, l_line_rec.ib_installed_at_location
-- Distributer Order related change }
, l_line_rec.charge_periodicity_code
,l_line_val_rec.end_customer_name
,l_line_val_rec.end_customer_number
,l_line_val_rec.end_customer_contact
,l_line_val_rec.end_customer_site_address1
,l_line_val_rec.end_customer_site_address2
,l_line_val_rec.end_customer_site_address3
,l_line_val_rec.end_customer_site_address4
,l_line_val_rec.end_customer_site_city
,l_line_val_rec.end_customer_site_state
,l_line_val_rec.end_customer_site_postal_code
,l_line_val_rec.end_customer_site_country
--Sol_ord_er #16014165 start
, l_line_rec.SERVICE_BILL_PROFILE_ID
, l_line_rec.SERVICE_COV_TEMPLATE_ID
, l_line_rec.SERVICE_SUBS_TEMPLATE_ID
, l_line_val_rec.service_bill_option
, l_line_val_rec.service_bill_profile
, l_line_val_rec.service_cov_template
, l_line_val_rec.service_subs_template
, l_line_rec.SERVICE_BILL_OPTION_CODE
, l_line_rec.SERVICE_FIRST_PERIOD_AMOUNT
, l_line_rec.SUBSCRIPTION_ENABLE_FLAG
,l_line_rec.SERVICE_FIRST_PERIOD_ENDDATE
--Sol_ord_er #16014165 end
);
oe_debug_pub.add('Incomplete data for inserting line ack rec');
oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Insert_Row: '||sqlerrm);
( G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row'
);
END Insert_Row;
(p_line_rec In Out Nocopy OE_Update_Ack_Util.Line_Rec_Type,
p_count In Number)
Is
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
p_line_rec.last_update_date.extend(p_count);
p_line_rec.last_update_login.extend(p_count);
p_line_rec.last_updated_by.extend(p_count);
p_line_rec.program_update_date.extend(p_count);
Procedure Insert_Row
( p_line_tbl In OE_Order_Pub.Line_Tbl_Type,
p_old_line_tbl In OE_Order_Pub.Line_Tbl_Type,
x_return_status Out NOCOPY /* file.sql.39 change */ Varchar2
)
Is
l_line_tbl OE_Order_Pub.Line_Tbl_Type := p_line_tbl;
l_line_acks_rec OE_Update_Ack_Util.Line_Rec_Type;
Update_Header_Ack_Code (l_line_tbl(i).header_id, 'AC', NULL);
Select orig_sys_line_ref, orig_sys_shipment_ref
Into l_line_tbl(i).split_from_line_ref, l_line_tbl(i).split_from_shipment_ref
From OE_ORDER_LINES
Where line_id = l_line_tbl(i).split_from_line_id;
SELECT concatenated_segments
INTO l_line_acks_rec.inventory_item(k)
FROM mtl_system_items_vl
WHERE inventory_item_id = l_line_tbl(i).inventory_item_id
AND organization_id = l_validation_org_id;
l_line_acks_rec.last_update_date(k) := l_line_tbl(i).last_update_date;
l_line_acks_rec.last_update_login(k) := l_line_tbl(i).last_update_login;
l_line_acks_rec.last_updated_by(k) := l_line_tbl(i).last_updated_by;
l_line_acks_rec.program_update_date(k) := l_line_tbl(i).program_update_date;
DELETE FROM OE_LINE_ACKS
WHERE HEADER_ID = l_line_acks_rec.header_id(y)
AND LINE_ID = l_line_acks_rec.line_id(y)
AND ACKNOWLEDGMENT_FLAG is null
-- Change this condition once a type is inserted for POAO/POCAO
AND nvl(acknowledgment_type,'ALL') = nvl(l_ack_type,'ALL')
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(l_line_acks_rec.CHANGE_SEQUENCE(y), FND_API.G_MISS_CHAR) ;
Insert Into Oe_Line_Acks
(
ACCOUNTING_RULE_ID
,ACCOUNTING_RULE_DURATION
,ACKNOWLEDGMENT_FLAG
,ACTUAL_ARRIVAL_DATE
,ACTUAL_SHIPMENT_DATE
,AGREEMENT_ID
,ARRIVAL_SET_ID
/*
,ATO_LINE_ID
*/
,ATTRIBUTE1
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16 --For bug 2184255
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE2
,ATTRIBUTE20
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
/*
,AUTHORIZED_TO_SHIP_FLAG
,BUYER_SELLER_FLAG
*/
,BOOKED_FLAG
,CANCELLED_FLAG
,CANCELLED_QUANTITY
,CHANGE_DATE
,CHANGE_SEQUENCE
,COMPONENT_CODE
,COMPONENT_NUMBER
,COMPONENT_SEQUENCE_ID
,CONFIG_DISPLAY_SEQUENCE
,CONFIGURATION_ID
,TOP_MODEL_LINE_ID
,CONTEXT
,CREATED_BY
,CREATION_DATE
,CUST_MODEL_SERIAL_NUMBER
,CUST_PO_NUMBER
,CUST_PRODUCTION_SEQ_NUM
,CUSTOMER_DOCK_CODE
,CUSTOMER_ITEM
,CUSTOMER_ITEM_ID /* Bug # 4761560 */
,CUSTOMER_JOB
,CUSTOMER_PRODUCTION_LINE
,CUSTOMER_TRX_LINE_ID
,DELIVER_TO_CONTACT_ID
,DELIVER_TO_ORG_ID
,DELIVERY_LEAD_TIME
,DEMAND_BUCKET_TYPE_CODE
,DEMAND_CLASS_CODE
,DEP_PLAN_REQUIRED_FLAG
,EARLIEST_ACCEPTABLE_DATE
,EXPLOSION_DATE
,FIRST_ACK_CODE
,FIRST_ACK_DATE
,FOB_POINT_CODE
,FREIGHT_CARRIER_CODE
,FREIGHT_TERMS_CODE
,FULFILLED_QUANTITY
,GLOBAL_ATTRIBUTE_CATEGORY
,GLOBAL_ATTRIBUTE1
,GLOBAL_ATTRIBUTE10
,GLOBAL_ATTRIBUTE11
,GLOBAL_ATTRIBUTE12
,GLOBAL_ATTRIBUTE13
,GLOBAL_ATTRIBUTE14
,GLOBAL_ATTRIBUTE15
,GLOBAL_ATTRIBUTE16
,GLOBAL_ATTRIBUTE17
,GLOBAL_ATTRIBUTE18
,GLOBAL_ATTRIBUTE19
,GLOBAL_ATTRIBUTE2
,GLOBAL_ATTRIBUTE20
,GLOBAL_ATTRIBUTE3
,GLOBAL_ATTRIBUTE4
,GLOBAL_ATTRIBUTE5
,GLOBAL_ATTRIBUTE6
,GLOBAL_ATTRIBUTE7
,GLOBAL_ATTRIBUTE8
,GLOBAL_ATTRIBUTE9
,HEADER_ID
,INDUSTRY_ATTRIBUTE1
,INDUSTRY_ATTRIBUTE10
,INDUSTRY_ATTRIBUTE11
,INDUSTRY_ATTRIBUTE12
,INDUSTRY_ATTRIBUTE13
,INDUSTRY_ATTRIBUTE14
,INDUSTRY_ATTRIBUTE15
,INDUSTRY_ATTRIBUTE16
,INDUSTRY_ATTRIBUTE17
,INDUSTRY_ATTRIBUTE18
,INDUSTRY_ATTRIBUTE19
,INDUSTRY_ATTRIBUTE2
,INDUSTRY_ATTRIBUTE20
,INDUSTRY_ATTRIBUTE21
,INDUSTRY_ATTRIBUTE22
,INDUSTRY_ATTRIBUTE23
,INDUSTRY_ATTRIBUTE24
,INDUSTRY_ATTRIBUTE25
,INDUSTRY_ATTRIBUTE26
,INDUSTRY_ATTRIBUTE27
,INDUSTRY_ATTRIBUTE28
,INDUSTRY_ATTRIBUTE29
,INDUSTRY_ATTRIBUTE3
,INDUSTRY_ATTRIBUTE30
,INDUSTRY_ATTRIBUTE4
,INDUSTRY_ATTRIBUTE5
,INDUSTRY_ATTRIBUTE6
,INDUSTRY_ATTRIBUTE7
,INDUSTRY_ATTRIBUTE8
,INDUSTRY_ATTRIBUTE9
,INDUSTRY_CONTEXT
,TP_CONTEXT
,TP_ATTRIBUTE1
,TP_ATTRIBUTE2
,TP_ATTRIBUTE3
,TP_ATTRIBUTE4
,TP_ATTRIBUTE5
,TP_ATTRIBUTE6
,TP_ATTRIBUTE7
,TP_ATTRIBUTE8
,TP_ATTRIBUTE9
,TP_ATTRIBUTE10
,TP_ATTRIBUTE11
,TP_ATTRIBUTE12
,TP_ATTRIBUTE13
,TP_ATTRIBUTE14
,TP_ATTRIBUTE15
,INVENTORY_ITEM --added for bug 4309609
,INVENTORY_ITEM_ID
,INVOICE_TO_CONTACT_ID
,INVOICE_TO_ORG_ID
,INVOICING_RULE_ID
,ITEM_INPUT
,ITEM_REVISION
,ITEM_TYPE_CODE
,LAST_ACK_CODE
,LAST_ACK_DATE
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,LAST_UPDATED_BY
,LATEST_ACCEPTABLE_DATE
,LINE_CATEGORY_CODE
,LINE_ID
,LINE_NUMBER
,LINE_TYPE_ID
,LINK_TO_LINE_ID
,MODEL_GROUP_NUMBER
,OPEN_FLAG
,OPERATION_CODE
,OPTION_FLAG
,OPTION_NUMBER
,ORDER_QUANTITY_UOM
,ORDER_SOURCE_ID
,ORDERED_QUANTITY
,ORG_ID
,ORIG_SYS_DOCUMENT_REF
,ORIG_SYS_LINE_REF
,ORIG_SYS_SHIPMENT_REF
,OVER_SHIP_REASON_CODE
,OVER_SHIP_RESOLVED_FLAG
,PAYMENT_TERM_ID
,PRICE_LIST_ID
,PRICING_ATTRIBUTE1
,PRICING_ATTRIBUTE10
,PRICING_ATTRIBUTE2
,PRICING_ATTRIBUTE3
,PRICING_ATTRIBUTE4
,PRICING_ATTRIBUTE5
,PRICING_ATTRIBUTE6
,PRICING_ATTRIBUTE7
,PRICING_ATTRIBUTE8
,PRICING_ATTRIBUTE9
,PRICING_CONTEXT
,PRICING_DATE
,PRICING_QUANTITY
,PRICING_QUANTITY_UOM
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,PROJECT_ID
,PROMISE_DATE
,REFERENCE_HEADER_ID
,REFERENCE_LINE_ID
,REFERENCE_TYPE
,REQUEST_DATE
,REQUEST_ID
,RESERVED_QUANTITY
,RETURN_ATTRIBUTE1
,RETURN_ATTRIBUTE10
,RETURN_ATTRIBUTE11
,RETURN_ATTRIBUTE12
,RETURN_ATTRIBUTE13
,RETURN_ATTRIBUTE14
,RETURN_ATTRIBUTE15
,RETURN_ATTRIBUTE2
,RETURN_ATTRIBUTE3
,RETURN_ATTRIBUTE4
,RETURN_ATTRIBUTE5
,RETURN_ATTRIBUTE6
,RETURN_ATTRIBUTE7
,RETURN_ATTRIBUTE8
,RETURN_ATTRIBUTE9
,RETURN_CONTEXT
,RETURN_REASON_CODE
,RLA_SCHEDULE_TYPE_CODE
,SALESREP_ID
,SCHEDULE_ARRIVAL_DATE
,SCHEDULE_SHIP_DATE
,SCHEDULE_STATUS_CODE
,SHIP_FROM_ORG_ID
,SHIP_MODEL_COMPLETE_FLAG
,SHIP_SET_ID
,SHIP_TO_CONTACT_ID
,SHIP_TO_ORG_ID
,SHIP_TOLERANCE_ABOVE
,SHIP_TOLERANCE_BELOW
,SHIPMENT_NUMBER
,SHIPMENT_PRIORITY_CODE
,SHIPPED_QUANTITY
,SHIPPING_METHOD_CODE
,SHIPPING_QUANTITY
,SHIPPING_QUANTITY_UOM
,SOLD_TO_ORG_ID
,SORT_ORDER
,SOURCE_DOCUMENT_ID
,SOURCE_DOCUMENT_LINE_ID
,SOURCE_DOCUMENT_TYPE_ID
,SOURCE_TYPE_CODE
,SPLIT_FROM_LINE_ID
,TASK_ID
,TAX_CODE
,TAX_DATE
,TAX_EXEMPT_FLAG
,TAX_EXEMPT_NUMBER
,TAX_EXEMPT_REASON_CODE
,TAX_POINT_CODE
,TAX_RATE
,TAX_VALUE
,UNIT_LIST_PRICE
,UNIT_SELLING_PRICE
,VEH_CUS_ITEM_CUM_KEY_ID
,VISIBLE_DEMAND_FLAG
,split_from_line_ref
,split_from_shipment_ref
,Service_Txn_Reason_Code
,Service_Txn_Comments
,Service_Duration
,Service_Start_Date
,Service_End_Date
,Service_Coterminate_Flag
,Service_Number
,Service_Period
,Service_Reference_Type_Code
,Service_Reference_Line_Id
,Service_Reference_System_Id
,Credit_Invoice_Line_Id
,service_reference_line
,service_reference_order
,service_reference_system
,customer_line_number
,user_item_description
,acknowledgment_type
,blanket_number
,blanket_line_number
,original_inventory_item_id
,original_ordered_item_id
,original_ordered_item
,original_item_identifier_type
,item_relationship_type
,customer_shipment_number
-- { Distributer Order related change
,end_customer_id
,end_customer_contact_id
,end_customer_site_use_id
,ib_owner
,ib_current_location
,ib_installed_at_location
-- Distributer Order related change }
,charge_periodicity_code
--Sol_ord_er #16014165 start
, SERVICE_BILL_PROFILE_ID
, SERVICE_COV_TEMPLATE_ID
, SERVICE_SUBS_TEMPLATE_ID
, SERVICE_BILL_OPTION_CODE
, SERVICE_FIRST_PERIOD_AMOUNT
, SUBSCRIPTION_ENABLE_FLAG
, SERVICE_FIRST_PERIOD_ENDDATE
--Sol_ord_er #16014165 end
)
Values
(
l_line_acks_rec.ACCOUNTING_RULE_ID(j)
, l_line_acks_rec.ACCOUNTING_RULE_DURATION(j)
, '' -- ACKNOWLEDGMENT_FLAG
, l_line_acks_rec.ACTUAL_ARRIVAL_DATE(j)
, l_line_acks_rec.ACTUAL_SHIPMENT_DATE(j)
, l_line_acks_rec.AGREEMENT_ID(j)
, l_line_acks_rec.ARRIVAL_SET_ID(j)
/*
, l_line_acks_rec.ATO_LINE_ID
*/
, l_line_acks_rec.ATTRIBUTE1(j)
, l_line_acks_rec.ATTRIBUTE10(j)
, l_line_acks_rec.ATTRIBUTE11(j)
, l_line_acks_rec.ATTRIBUTE12(j)
, l_line_acks_rec.ATTRIBUTE13(j)
, l_line_acks_rec.ATTRIBUTE14(j)
, l_line_acks_rec.ATTRIBUTE15(j)
, l_line_acks_rec.ATTRIBUTE16(j) --For bug 2184255
, l_line_acks_rec.ATTRIBUTE17(j)
, l_line_acks_rec.ATTRIBUTE18(j)
, l_line_acks_rec.ATTRIBUTE19(j)
, l_line_acks_rec.ATTRIBUTE2(j)
, l_line_acks_rec.ATTRIBUTE20(j)
, l_line_acks_rec.ATTRIBUTE3(j)
, l_line_acks_rec.ATTRIBUTE4(j)
, l_line_acks_rec.ATTRIBUTE5(j)
, l_line_acks_rec.ATTRIBUTE6(j)
, l_line_acks_rec.ATTRIBUTE7(j)
, l_line_acks_rec.ATTRIBUTE8(j)
, l_line_acks_rec.ATTRIBUTE9(j)
/*
, l_line_acks_rec.AUTHORIZED_TO_SHIP_FLAG
, p_buyer_seller_flag
*/
, l_line_acks_rec.BOOKED_FLAG(j)
, l_line_acks_rec.CANCELLED_FLAG(j)
, l_line_acks_rec.CANCELLED_QUANTITY(j)
, '' -- CHANGE_DATE
, l_line_acks_rec.CHANGE_SEQUENCE(j)
, l_line_acks_rec.COMPONENT_CODE(j)
, l_line_acks_rec.COMPONENT_NUMBER(j)
, l_line_acks_rec.COMPONENT_SEQUENCE_ID(j)
, l_line_acks_rec.CONFIG_DISPLAY_SEQUENCE(j)
, l_line_acks_rec.CONFIGURATION_ID(j)
, l_line_acks_rec.TOP_MODEL_LINE_ID(j)
, l_line_acks_rec.CONTEXT(j)
, l_line_acks_rec.CREATED_BY(j)
, l_line_acks_rec.CREATION_DATE(j)
, l_line_acks_rec.CUST_MODEL_SERIAL_NUMBER(j)
, l_line_acks_rec.CUST_PO_NUMBER(j)
, l_line_acks_rec.CUST_PRODUCTION_SEQ_NUM(j)
, l_line_acks_rec.CUSTOMER_DOCK_CODE(j)
, l_line_acks_rec.ORDERED_ITEM(j)
, l_line_acks_rec.ORDERED_ITEM_ID(j) /* Bug # 4761560 */
, l_line_acks_rec.CUSTOMER_JOB(j)
, l_line_acks_rec.CUSTOMER_PRODUCTION_LINE(j)
, l_line_acks_rec.CUSTOMER_TRX_LINE_ID(j)
, l_line_acks_rec.DELIVER_TO_CONTACT_ID(j)
, l_line_acks_rec.DELIVER_TO_ORG_ID(j)
, l_line_acks_rec.DELIVERY_LEAD_TIME(j)
, l_line_acks_rec.DEMAND_BUCKET_TYPE_CODE(j)
, l_line_acks_rec.DEMAND_CLASS_CODE(j)
, l_line_acks_rec.DEP_PLAN_REQUIRED_FLAG(j)
, l_line_acks_rec.EARLIEST_ACCEPTABLE_DATE(j)
, l_line_acks_rec.EXPLOSION_DATE(j)
, l_line_acks_rec.FIRST_ACK_CODE(j)
, l_line_acks_rec.FIRST_ACK_DATE(j)
, l_line_acks_rec.FOB_POINT_CODE(j)
, l_line_acks_rec.FREIGHT_CARRIER_CODE(j)
, l_line_acks_rec.FREIGHT_TERMS_CODE(j)
, l_line_acks_rec.FULFILLED_QUANTITY(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE_CATEGORY(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE1(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE10(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE11(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE12(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE13(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE14(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE15(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE16(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE17(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE18(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE19(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE2(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE20(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE3(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE4(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE5(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE6(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE7(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE8(j)
, l_line_acks_rec.GLOBAL_ATTRIBUTE9(j)
, l_line_acks_rec.HEADER_ID(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE1(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE10(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE11(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE12(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE13(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE14(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE15(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE16(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE17(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE18(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE19(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE2(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE20(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE21(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE22(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE23(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE24(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE25(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE26(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE27(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE28(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE29(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE3(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE30(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE4(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE5(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE6(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE7(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE8(j)
, l_line_acks_rec.INDUSTRY_ATTRIBUTE9(j)
, l_line_acks_rec.INDUSTRY_CONTEXT(j)
, l_line_acks_rec.TP_CONTEXT(j)
, l_line_acks_rec.TP_ATTRIBUTE1(j)
, l_line_acks_rec.TP_ATTRIBUTE2(j)
, l_line_acks_rec.TP_ATTRIBUTE3(j)
, l_line_acks_rec.TP_ATTRIBUTE4(j)
, l_line_acks_rec.TP_ATTRIBUTE5(j)
, l_line_acks_rec.TP_ATTRIBUTE6(j)
, l_line_acks_rec.TP_ATTRIBUTE7(j)
, l_line_acks_rec.TP_ATTRIBUTE8(j)
, l_line_acks_rec.TP_ATTRIBUTE9(j)
, l_line_acks_rec.TP_ATTRIBUTE10(j)
, l_line_acks_rec.TP_ATTRIBUTE11(j)
, l_line_acks_rec.TP_ATTRIBUTE12(j)
, l_line_acks_rec.TP_ATTRIBUTE13(j)
, l_line_acks_rec.TP_ATTRIBUTE14(j)
, l_line_acks_rec.TP_ATTRIBUTE15(j)
, l_line_acks_rec.inventory_item(j) --added for bug4309609
, l_line_acks_rec.INVENTORY_ITEM_ID(j)
, l_line_acks_rec.INVOICE_TO_CONTACT_ID(j)
, l_line_acks_rec.INVOICE_TO_ORG_ID(j)
, l_line_acks_rec.INVOICING_RULE_ID(j)
, l_line_acks_rec.ORDERED_ITEM(j)
, l_line_acks_rec.ITEM_REVISION(j)
, l_line_acks_rec.item_identifier_type(j)
, l_line_acks_rec.LAST_ACK_CODE(j)
, l_line_acks_rec.LAST_ACK_DATE(j)
, l_line_acks_rec.LAST_UPDATE_DATE(j)
, l_line_acks_rec.LAST_UPDATE_LOGIN(j)
, l_line_acks_rec.LAST_UPDATED_BY(j)
, l_line_acks_rec.LATEST_ACCEPTABLE_DATE(j)
, l_line_acks_rec.LINE_CATEGORY_CODE(j)
, l_line_acks_rec.LINE_ID(j)
, l_line_acks_rec.LINE_NUMBER(j)
, l_line_acks_rec.LINE_TYPE_ID(j)
, l_line_acks_rec.LINK_TO_LINE_ID(j)
, l_line_acks_rec.MODEL_GROUP_NUMBER(j)
, l_line_acks_rec.OPEN_FLAG(j)
, l_line_acks_rec.OPERATION_CODE(j)
, l_line_acks_rec.OPTION_FLAG(j)
, l_line_acks_rec.OPTION_NUMBER(j)
, l_line_acks_rec.ORDER_QUANTITY_UOM(j)
, l_line_acks_rec.ORDER_SOURCE_ID(j)
, l_line_acks_rec.ORDERED_QUANTITY(j)
, l_line_acks_rec.ORG_ID(j)
, l_line_acks_rec.ORIG_SYS_DOCUMENT_REF(j)
, l_line_acks_rec.ORIG_SYS_LINE_REF(j)
, l_line_acks_rec.ORIG_SYS_SHIPMENT_REF(j)
, l_line_acks_rec.OVER_SHIP_REASON_CODE(j)
, l_line_acks_rec.OVER_SHIP_RESOLVED_FLAG(j)
, l_line_acks_rec.PAYMENT_TERM_ID(j)
, l_line_acks_rec.PRICE_LIST_ID(j)
, l_line_acks_rec.PRICING_ATTRIBUTE1(j)
, l_line_acks_rec.PRICING_ATTRIBUTE10(j)
, l_line_acks_rec.PRICING_ATTRIBUTE2(j)
, l_line_acks_rec.PRICING_ATTRIBUTE3(j)
, l_line_acks_rec.PRICING_ATTRIBUTE4(j)
, l_line_acks_rec.PRICING_ATTRIBUTE5(j)
, l_line_acks_rec.PRICING_ATTRIBUTE6(j)
, l_line_acks_rec.PRICING_ATTRIBUTE7(j)
, l_line_acks_rec.PRICING_ATTRIBUTE8(j)
, l_line_acks_rec.PRICING_ATTRIBUTE9(j)
, l_line_acks_rec.PRICING_CONTEXT(j)
, l_line_acks_rec.PRICING_DATE(j)
, l_line_acks_rec.PRICING_QUANTITY(j)
, l_line_acks_rec.PRICING_QUANTITY_UOM(j)
, l_line_acks_rec.PROGRAM_APPLICATION_ID(j)
, l_line_acks_rec.PROGRAM_ID(j)
, l_line_acks_rec.PROGRAM_UPDATE_DATE(j)
, l_line_acks_rec.PROJECT_ID(j)
, l_line_acks_rec.PROMISE_DATE(j)
, l_line_acks_rec.REFERENCE_HEADER_ID(j)
, l_line_acks_rec.REFERENCE_LINE_ID(j)
, l_line_acks_rec.REFERENCE_TYPE(j)
, l_line_acks_rec.REQUEST_DATE(j)
, l_line_acks_rec.REQUEST_ID(j)
, l_line_acks_rec.RESERVED_QUANTITY(j)
, l_line_acks_rec.RETURN_ATTRIBUTE1(j)
, l_line_acks_rec.RETURN_ATTRIBUTE10(j)
, l_line_acks_rec.RETURN_ATTRIBUTE11(j)
, l_line_acks_rec.RETURN_ATTRIBUTE12(j)
, l_line_acks_rec.RETURN_ATTRIBUTE13(j)
, l_line_acks_rec.RETURN_ATTRIBUTE14(j)
, l_line_acks_rec.RETURN_ATTRIBUTE15(j)
, l_line_acks_rec.RETURN_ATTRIBUTE2(j)
, l_line_acks_rec.RETURN_ATTRIBUTE3(j)
, l_line_acks_rec.RETURN_ATTRIBUTE4(j)
, l_line_acks_rec.RETURN_ATTRIBUTE5(j)
, l_line_acks_rec.RETURN_ATTRIBUTE6(j)
, l_line_acks_rec.RETURN_ATTRIBUTE7(j)
, l_line_acks_rec.RETURN_ATTRIBUTE8(j)
, l_line_acks_rec.RETURN_ATTRIBUTE9(j)
, l_line_acks_rec.RETURN_CONTEXT(j)
, l_line_acks_rec.RETURN_REASON_CODE(j)
, l_line_acks_rec.RLA_SCHEDULE_TYPE_CODE(j)
, l_line_acks_rec.SALESREP_ID(j)
, l_line_acks_rec.SCHEDULE_ARRIVAL_DATE(j)
, l_line_acks_rec.SCHEDULE_SHIP_DATE(j)
, l_line_acks_rec.SCHEDULE_STATUS_CODE(j)
, l_line_acks_rec.SHIP_FROM_ORG_ID(j)
, l_line_acks_rec.SHIP_MODEL_COMPLETE_FLAG(j)
, l_line_acks_rec.SHIP_SET_ID(j)
, l_line_acks_rec.SHIP_TO_CONTACT_ID(j)
, l_line_acks_rec.SHIP_TO_ORG_ID(j)
, l_line_acks_rec.SHIP_TOLERANCE_ABOVE(j)
, l_line_acks_rec.SHIP_TOLERANCE_BELOW(j)
, l_line_acks_rec.SHIPMENT_NUMBER(j)
, l_line_acks_rec.SHIPMENT_PRIORITY_CODE(j)
, l_line_acks_rec.SHIPPED_QUANTITY(j)
, l_line_acks_rec.SHIPPING_METHOD_CODE(j)
, l_line_acks_rec.SHIPPING_QUANTITY(j)
, l_line_acks_rec.SHIPPING_QUANTITY_UOM(j)
, l_line_acks_rec.SOLD_TO_ORG_ID(j)
, l_line_acks_rec.SORT_ORDER(j)
, l_line_acks_rec.SOURCE_DOCUMENT_ID(j)
, l_line_acks_rec.SOURCE_DOCUMENT_LINE_ID(j)
, l_line_acks_rec.SOURCE_DOCUMENT_TYPE_ID(j)
, l_line_acks_rec.SOURCE_TYPE_CODE(j)
, l_line_acks_rec.SPLIT_FROM_LINE_ID(j)
, l_line_acks_rec.TASK_ID(j)
, l_line_acks_rec.TAX_CODE(j)
, l_line_acks_rec.TAX_DATE(j)
, l_line_acks_rec.TAX_EXEMPT_FLAG(j)
, l_line_acks_rec.TAX_EXEMPT_NUMBER(j)
, l_line_acks_rec.TAX_EXEMPT_REASON_CODE(j)
, l_line_acks_rec.TAX_POINT_CODE(j)
, l_line_acks_rec.TAX_RATE(j)
, l_line_acks_rec.TAX_VALUE(j)
, l_line_acks_rec.UNIT_LIST_PRICE(j)
, l_line_acks_rec.UNIT_SELLING_PRICE(j)
, l_line_acks_rec.VEH_CUS_ITEM_CUM_KEY_ID(j)
, l_line_acks_rec.VISIBLE_DEMAND_FLAG(j)
, l_line_acks_rec.split_from_line_ref(j)
, l_line_acks_rec.split_from_shipment_ref(j)
, l_line_acks_rec.Service_Txn_Reason_Code(j)
, l_line_acks_rec.Service_Txn_Comments(j)
, l_line_acks_rec.Service_Duration(j)
, l_line_acks_rec.Service_Start_Date(j)
, l_line_acks_rec.Service_End_Date(j)
, l_line_acks_rec.Service_Coterminate_Flag(j)
, l_line_acks_rec.Service_Number(j)
, l_line_acks_rec.Service_Period(j)
, l_line_acks_rec.Service_Reference_Type_Code(j)
, l_line_acks_rec.Service_Reference_Line_Id(j)
, l_line_acks_rec.Service_Reference_System_Id(j)
, l_line_acks_rec.Credit_Invoice_Line_Id(j)
, l_line_acks_rec.service_reference_line(j)
, l_line_acks_rec.service_reference_order(j)
, l_line_acks_rec.service_reference_system(j)
, l_line_acks_rec.customer_line_number(j)
, l_line_acks_rec.user_item_description(j)
, l_ack_type
, l_line_acks_rec.blanket_number(j)
, l_line_acks_rec.blanket_line_number(j)
, l_line_acks_rec.original_inventory_item_id(j)
, l_line_acks_rec.original_ordered_item_id(j)
, l_line_acks_rec.original_ordered_item(j)
, l_line_acks_rec.original_item_identifier_type(j)
, l_line_acks_rec.item_relationship_type(j)
, l_line_acks_rec.customer_shipment_number(j)
-- { Distributer Order related change
, l_line_acks_rec.end_customer_id(j)
, l_line_acks_rec.end_customer_contact_id(j)
, l_line_acks_rec.end_customer_site_use_id(j)
, l_line_acks_rec.ib_owner(j)
, l_line_acks_rec.ib_current_location(j)
, l_line_acks_rec.ib_installed_at_location(j)
-- Distributer Order related change }
, l_line_acks_rec.charge_periodicity_code(j)
--Sol_ord_er #16014165 start
,l_line_acks_rec.SERVICE_BILL_PROFILE_ID(j)
,l_line_acks_rec.SERVICE_COV_TEMPLATE_ID(j)
,l_line_acks_rec.SERVICE_SUBS_TEMPLATE_ID(j)
,l_line_acks_rec.SERVICE_BILL_OPTION_CODE(j)
,l_line_acks_rec.SERVICE_FIRST_PERIOD_AMOUNT(j)
,l_line_acks_rec.SUBSCRIPTION_ENABLE_FLAG(j)
,l_line_acks_rec.SERVICE_FIRST_PERIOD_ENDDATE(j)
--Sol_ord_er #16014165 end
);
(G_PKG_NAME, 'OE_Line_Ack_Util.Insert_Row');
End Insert_Row;
PROCEDURE Delete_Row
( p_line_id IN NUMBER,
p_ack_type IN Varchar2,
p_orig_sys_document_ref In Varchar2,
p_orig_sys_line_ref In Varchar2,
p_orig_sys_shipment_ref In Varchar2,
p_sold_to_org_id In NUMBER,
p_sold_to_org In Varchar2,
p_change_sequence In Varchar2,
p_request_id In NUMBER,
p_header_id In NUMBER
)
IS
BEGIN
oe_debug_pub.add('Input Header ID: '|| p_header_id);
DELETE FROM OE_LINE_ACKS
WHERE HEADER_ID = p_header_id
AND LINE_ID = p_line_id
AND ACKNOWLEDGMENT_FLAG is null
-- Change this condition once a type is inserted for POAO/POCAO
AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(p_change_sequence, FND_API.G_MISS_CHAR)
AND request_id = p_request_id;
DELETE FROM OE_LINE_ACKS
WHERE HEADER_ID = p_header_id
AND LINE_ID = p_line_id
AND ACKNOWLEDGMENT_FLAG is null
-- Change this condition once a type is inserted for POAO/POCAO
AND nvl(acknowledgment_type,'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(p_change_sequence, FND_API.G_MISS_CHAR);
oe_debug_pub.add('Row Deleted from the oe_line_Acks table');
DELETE FROM OE_LINE_ACKS
WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(p_change_sequence, FND_API.G_MISS_CHAR)
AND REQUEST_ID = p_request_id;
DELETE FROM OE_LINE_ACKS
WHERE ORIG_SYS_DOCUMENT_REF = p_orig_sys_document_ref
AND ORIG_SYS_LINE_REF = p_orig_sys_line_ref
AND ORIG_SYS_SHIPMENT_REF = p_orig_sys_shipment_ref
AND nvl(ACKNOWLEDGMENT_TYPE, 'ALL') = nvl(p_ack_type,'ALL')
AND nvl(sold_to_org_id, FND_API.G_MISS_NUM)
= nvl(p_sold_to_org_id, FND_API.G_MISS_NUM)
AND nvl(sold_to_org, FND_API.G_MISS_CHAR)
= nvl(p_sold_to_org, FND_API.G_MISS_CHAR)
AND nvl(change_sequence, FND_API.G_MISS_CHAR)
= nvl(p_change_sequence, FND_API.G_MISS_CHAR);
oe_debug_pub.add('Row(s) Deleted from the oe_line_acks table');
oe_debug_pub.Add('Encountered Others Error Exception in OE_Line_Ack_Util.Delete_Row: '||sqlerrm);
(G_PKG_NAME, 'OE_Line_Ack_Util.Delete_Row');
END Delete_Row;