[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO x_lot_exists
FROM mtl_lot_numbers
WHERE organization_id = p_org_id
AND inventory_item_id = p_inventory_item_id
AND lot_number = p_lot_number;
PROCEDURE create_update_lotattr(x_err_code OUT NOCOPY NUMBER,
x_err_msg OUT NOCOPY varchar2,
p_lot_number VARCHAR2,
p_inv_item_id NUMBER,
p_org_id NUMBER) IS
BEGIN
create_update_lotattr( x_err_code => x_err_code,
x_err_msg => x_err_msg,
p_lot_number => p_lot_number,
p_inv_item_id => p_inv_item_id,
p_org_id => p_org_id,
p_src_lot_number => NULL,
p_src_inv_item_id => NULL);
END create_update_lotattr; */
Procedure create_update_lotattr(x_err_code OUT NOCOPY VARCHAR2,
x_err_msg OUT NOCOPY VARCHAR2,
p_lot_number IN VARCHAR2,
p_inv_item_id IN NUMBER,
p_org_id IN NUMBER,
p_intf_txn_id IN NUMBER,
p_intf_src_code IN VARCHAR2,
p_src_lot_number IN VARCHAR2 DEFAULT NULL,
p_src_inv_item_id IN NUMBER DEFAULT NULL) is
l_wms_installed BOOLEAN:=FALSE;
pdebug('Entering wsmvatrb.create_update_lotattr lot#= ' || p_lot_number);
select 1
into l_intf_temp
from mtl_transaction_lots_interface mtli
where mtli.product_transaction_id=p_intf_txn_id
and mtli.product_code=p_intf_src_code
and mtli.lot_number=p_lot_number;
select lot_attribute_category
into x_src_context_code
from mtl_lot_numbers
where lot_number=p_src_lot_number
and inventory_item_id=p_src_inv_item_id
and organization_id= p_org_id;
SELECT
description -- This is Not a named attr, right?
,grade_code
,origination_date
,date_code
,change_date
,age
,retest_date
,maturity_date
,item_size
,color
,volume
,volume_uom
,place_of_origin
,best_by_date
,length
,length_uom
,recycled_content
,thickness
,thickness_uom
,width
,width_uom
,vendor_id -- are vendor_id is missing in create_inv_lot
,vendor_name
,territory_code --MISSING in named record
,supplier_lot_number --MISSING in named record
,curl_wrinkle_fold --MISSING in named record
,lot_attribute_category
,c_attribute1
,c_attribute2
,c_attribute3
,c_attribute4
,c_attribute5
,c_attribute6
,c_attribute7
,c_attribute8
,c_attribute9
,c_attribute10
,c_attribute11
,c_attribute12
,c_attribute13
,c_attribute14
,c_attribute15
,c_attribute16
,c_attribute17
,c_attribute18
,c_attribute19
,c_attribute20
,d_attribute1
,d_attribute2
,d_attribute3
,d_attribute4
,d_attribute5
,d_attribute6
,d_attribute7
,d_attribute8
,d_attribute9
,d_attribute10
,n_attribute1
,n_attribute2
,n_attribute3
,n_attribute4
,n_attribute5
,n_attribute6
,n_attribute7
,n_attribute8
,n_attribute9
,n_attribute10
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
INTO
l_description
,l_grade_code
,l_origination_date
,l_date_code
,l_change_date
,l_age
,l_retest_date
,l_maturity_date
,l_item_size
,l_color
,l_volume
,l_volume_uom
,l_place_of_origin
,l_best_by_date
,l_length
,l_length_uom
,l_recycled_content
,l_thickness
,l_thickness_uom
,l_width
,l_width_uom
,l_vendor_id
,l_vendor_name
,l_territory_code
,l_supplier_lot_number
,l_curl_wrinkle_fold
,l_lot_attribute_category
,l_Cattr_tbl(1)
,l_Cattr_tbl(2)
,l_Cattr_tbl(3)
,l_Cattr_tbl(4)
,l_Cattr_tbl(5)
,l_Cattr_tbl(6)
,l_Cattr_tbl(7)
,l_Cattr_tbl(8)
,l_Cattr_tbl(9)
,l_Cattr_tbl(10)
,l_Cattr_tbl(11)
,l_Cattr_tbl(12)
,l_Cattr_tbl(13)
,l_Cattr_tbl(14)
,l_Cattr_tbl(15)
,l_Cattr_tbl(16)
,l_Cattr_tbl(17)
,l_Cattr_tbl(18)
,l_Cattr_tbl(19)
,l_Cattr_tbl(20)
,l_Dattr_tbl(1)
,l_Dattr_tbl(2)
,l_Dattr_tbl(3)
,l_Dattr_tbl(4)
,l_Dattr_tbl(5)
,l_Dattr_tbl(6)
,l_Dattr_tbl(7)
,l_Dattr_tbl(8)
,l_Dattr_tbl(9)
,l_Dattr_tbl(10)
,l_Nattr_tbl(1)
,l_Nattr_tbl(2)
,l_Nattr_tbl(3)
,l_Nattr_tbl(4)
,l_Nattr_tbl(5)
,l_Nattr_tbl(6)
,l_Nattr_tbl(7)
,l_Nattr_tbl(8)
,l_Nattr_tbl(9)
,l_Nattr_tbl(10)
,l_attribute_category
,l_invattr_tbl(1)
,l_invattr_tbl(2)
,l_invattr_tbl(3)
,l_invattr_tbl(4)
,l_invattr_tbl(5)
,l_invattr_tbl(6)
,l_invattr_tbl(7)
,l_invattr_tbl(8)
,l_invattr_tbl(9)
,l_invattr_tbl(10)
,l_invattr_tbl(11)
,l_invattr_tbl(12)
,l_invattr_tbl(13)
,l_invattr_tbl(14)
,l_invattr_tbl(15)
FROM mtl_lot_numbers
WHERE lot_number=nvl(p_src_lot_number,p_lot_number) /* modified for fixing bug 5126021 */
AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id) /* modified for fixing bug 5126021 */
AND organization_id=p_org_id;
SELECT
description
,grade_code
,origination_date
,date_code
,change_date
,age
,retest_date
,maturity_date
,item_size
,color
,volume
,volume_uom
,place_of_origin
,best_by_date
,length
,length_uom
,recycled_content
,thickness
,thickness_uom
,width
,width_uom
,vendor_id
,vendor_name
,territory_code
,supplier_lot_number
,curl_wrinkle_fold
,lot_attribute_category
,c_attribute1
,c_attribute2
,c_attribute3
,c_attribute4
,c_attribute5
,c_attribute6
,c_attribute7
,c_attribute8
,c_attribute9
,c_attribute10
,c_attribute11
,c_attribute12
,c_attribute13
,c_attribute14
,c_attribute15
,c_attribute16
,c_attribute17
,c_attribute18
,c_attribute19
,c_attribute20
,d_attribute1
,d_attribute2
,d_attribute3
,d_attribute4
,d_attribute5
,d_attribute6
,d_attribute7
,d_attribute8
,d_attribute9
,d_attribute10
,n_attribute1
,n_attribute2
,n_attribute3
,n_attribute4
,n_attribute5
,n_attribute6
,n_attribute7
,n_attribute8
,n_attribute9
,n_attribute10
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
INTO
l_temp_description
,l_temp_grade_code
,l_temp_origination_date
,l_temp_date_code
,l_temp_change_date
,l_temp_age
,l_temp_retest_date
,l_temp_maturity_date
,l_temp_item_size
,l_temp_color
,l_temp_volume
,l_temp_volume_uom
,l_temp_place_of_origin
,l_temp_best_by_date
,l_temp_length
,l_temp_length_uom
,l_temp_recycled_content
,l_temp_thickness
,l_temp_thickness_uom
,l_temp_width
,l_temp_width_uom
,l_temp_vendor_id
,l_temp_vendor_name
,l_temp_territory_code
,l_temp_supplier_lot_number
,l_temp_curl_wrinkle_fold
,l_temp_lot_attribute_category
,l_temp_Cattr_tbl(1)
,l_temp_Cattr_tbl(2)
,l_temp_Cattr_tbl(3)
,l_temp_Cattr_tbl(4)
,l_temp_Cattr_tbl(5)
,l_temp_Cattr_tbl(6)
,l_temp_Cattr_tbl(7)
,l_temp_Cattr_tbl(8)
,l_temp_Cattr_tbl(9)
,l_temp_Cattr_tbl(10)
,l_temp_Cattr_tbl(11)
,l_temp_Cattr_tbl(12)
,l_temp_Cattr_tbl(13)
,l_temp_Cattr_tbl(14)
,l_temp_Cattr_tbl(15)
,l_temp_Cattr_tbl(16)
,l_temp_Cattr_tbl(17)
,l_temp_Cattr_tbl(18)
,l_temp_Cattr_tbl(19)
,l_temp_Cattr_tbl(20)
,l_temp_Dattr_tbl(1)
,l_temp_Dattr_tbl(2)
,l_temp_Dattr_tbl(3)
,l_temp_Dattr_tbl(4)
,l_temp_Dattr_tbl(5)
,l_temp_Dattr_tbl(6)
,l_temp_Dattr_tbl(7)
,l_temp_Dattr_tbl(8)
,l_temp_Dattr_tbl(9)
,l_temp_Dattr_tbl(10)
,l_temp_Nattr_tbl(1)
,l_temp_Nattr_tbl(2)
,l_temp_Nattr_tbl(3)
,l_temp_Nattr_tbl(4)
,l_temp_Nattr_tbl(5)
,l_temp_Nattr_tbl(6)
,l_temp_Nattr_tbl(7)
,l_temp_Nattr_tbl(8)
,l_temp_Nattr_tbl(9)
,l_temp_Nattr_tbl(10)
,l_attribute_category
,l_invattr_tbl(1)
,l_invattr_tbl(2)
,l_invattr_tbl(3)
,l_invattr_tbl(4)
,l_invattr_tbl(5)
,l_invattr_tbl(6)
,l_invattr_tbl(7)
,l_invattr_tbl(8)
,l_invattr_tbl(9)
,l_invattr_tbl(10)
,l_invattr_tbl(11)
,l_invattr_tbl(12)
,l_invattr_tbl(13)
,l_invattr_tbl(14)
,l_invattr_tbl(15)
FROM mtl_lot_numbers
WHERE lot_number=nvl(p_src_lot_number,p_lot_number)
AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id)
AND organization_id=p_org_id;
SELECT
attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
INTO
l_attribute_category
,l_invattr_tbl(1)
,l_invattr_tbl(2)
,l_invattr_tbl(3)
,l_invattr_tbl(4)
,l_invattr_tbl(5)
,l_invattr_tbl(6)
,l_invattr_tbl(7)
,l_invattr_tbl(8)
,l_invattr_tbl(9)
,l_invattr_tbl(10)
,l_invattr_tbl(11)
,l_invattr_tbl(12)
,l_invattr_tbl(13)
,l_invattr_tbl(14)
,l_invattr_tbl(15)
FROM mtl_lot_numbers
WHERE lot_number=nvl(p_src_lot_number,p_lot_number) -- modified for fixing bug 5126021
AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id) -- modified for fixing bug 5126021
AND organization_id=p_org_id;
pdebug('before select from mtli');
SELECT
transaction_interface_id
,decode(description,l_miss_char, NULL,NULL,l_description,description)
,decode(grade_code,l_miss_char, NULL,NULL,l_grade_code,grade_code)
,decode(origination_date,l_miss_date, NULL,NULL,l_origination_date,origination_date)
,decode(date_code,l_miss_char, NULL,NULL,l_date_code,date_code)
,decode(change_date,l_miss_date, NULL,NULL,l_change_date,change_date)
,decode(age,l_miss_num, NULL,NULL,l_age,age)
,decode(retest_date,l_miss_date, NULL,NULL,l_retest_date,retest_date)
,decode(maturity_date,l_miss_date, NULL,NULL,l_maturity_date,maturity_date)
,decode(item_size,l_miss_num, NULL,NULL,l_item_size,item_size)
,decode(color,l_miss_char, NULL,NULL,l_color,color)
,decode(volume,l_miss_num, NULL,NULL,l_volume,volume)
,decode(volume_uom,l_miss_char, NULL,NULL,l_volume_uom,volume_uom)
,decode(place_of_origin,l_miss_char, NULL,NULL,l_place_of_origin,place_of_origin)
,decode(best_by_date,l_miss_date, NULL,NULL,l_best_by_date,best_by_date)
,decode(length,l_miss_num, NULL,NULL,l_length,length)
,decode(length_uom,l_miss_char, NULL,NULL,l_length_uom,length_uom)
,decode(recycled_content,l_miss_num, NULL,NULL,l_recycled_content,recycled_content)
,decode(thickness,l_miss_num, NULL,NULL,l_thickness,thickness)
,decode(thickness_uom,l_miss_char, NULL,NULL,l_thickness_uom,thickness_uom)
,decode(width,l_miss_num, NULL,NULL,l_width,width)
,decode(width_uom,l_miss_char, NULL,NULL,l_width_uom,width_uom)
,decode(vendor_id,l_miss_num, NULL,NULL,l_vendor_id,vendor_id)
,decode(vendor_name,l_miss_char, NULL,NULL,l_vendor_name,vendor_name)
,decode(territory_code,l_miss_char,NULL,NULL,l_territory_code,territory_code)
,decode(supplier_lot_number,l_miss_char, NULL,NULL,l_supplier_lot_number,supplier_lot_number)
,decode(curl_wrinkle_fold,l_miss_char, NULL,NULL,l_curl_wrinkle_fold,curl_wrinkle_fold)
,decode(lot_attribute_category,l_miss_char, NULL,NULL,l_lot_attribute_category,lot_attribute_category)
,decode(c_attribute1,l_miss_char, NULL,NULL,l_Cattr_tbl(1),c_attribute1)
,decode(c_attribute2,l_miss_char, NULL,NULL,l_Cattr_tbl(2),c_attribute2)
,decode(c_attribute3,l_miss_char, NULL,NULL,l_Cattr_tbl(3),c_attribute3)
,decode(c_attribute4,l_miss_char, NULL,NULL,l_Cattr_tbl(4),c_attribute4)
,decode(c_attribute5,l_miss_char, NULL,NULL,l_Cattr_tbl(5),c_attribute5)
,decode(c_attribute6,l_miss_char, NULL,NULL,l_Cattr_tbl(6),c_attribute6)
,decode(c_attribute7,l_miss_char, NULL,NULL,l_Cattr_tbl(7),c_attribute7)
,decode(c_attribute8,l_miss_char, NULL,NULL,l_Cattr_tbl(8),c_attribute8)
,decode(c_attribute9,l_miss_char, NULL,NULL,l_Cattr_tbl(9),c_attribute9)
,decode(c_attribute10,l_miss_char, NULL,NULL,l_Cattr_tbl(10),c_attribute10)
,decode(c_attribute11,l_miss_char, NULL,NULL,l_Cattr_tbl(11),c_attribute11)
,decode(c_attribute12,l_miss_char, NULL,NULL,l_Cattr_tbl(12),c_attribute12)
,decode(c_attribute13,l_miss_char, NULL,NULL,l_Cattr_tbl(13),c_attribute13)
,decode(c_attribute14,l_miss_char, NULL,NULL,l_Cattr_tbl(14),c_attribute14)
,decode(c_attribute15,l_miss_char, NULL,NULL,l_Cattr_tbl(15),c_attribute15)
,decode(c_attribute16,l_miss_char, NULL,NULL,l_Cattr_tbl(16),c_attribute16)
,decode(c_attribute17,l_miss_char, NULL,NULL,l_Cattr_tbl(17),c_attribute17)
,decode(c_attribute18,l_miss_char, NULL,NULL,l_Cattr_tbl(18),c_attribute18)
,decode(c_attribute19,l_miss_char, NULL,NULL,l_Cattr_tbl(19),c_attribute19)
,decode(c_attribute20,l_miss_char, NULL,NULL,l_Cattr_tbl(20),c_attribute20)
,decode(d_attribute1,l_miss_date, NULL,NULL,l_Dattr_tbl(1),d_attribute1)
,decode(d_attribute2,l_miss_date, NULL,NULL,l_Dattr_tbl(2),d_attribute2)
,decode(d_attribute3,l_miss_date, NULL,NULL,l_Dattr_tbl(3),d_attribute3)
,decode(d_attribute4,l_miss_date, NULL,NULL,l_Dattr_tbl(4),d_attribute4)
,decode(d_attribute5,l_miss_date, NULL,NULL,l_Dattr_tbl(5),d_attribute5)
,decode(d_attribute6,l_miss_date, NULL,NULL,l_Dattr_tbl(6),d_attribute6)
,decode(d_attribute7,l_miss_date, NULL,NULL,l_Dattr_tbl(7),d_attribute7)
,decode(d_attribute8,l_miss_date, NULL,NULL,l_Dattr_tbl(8),d_attribute8)
,decode(d_attribute9,l_miss_date, NULL,NULL,l_Dattr_tbl(9),d_attribute9)
,decode(d_attribute10,l_miss_date, NULL,NULL,l_Dattr_tbl(10),d_attribute10)
,decode(n_attribute1,l_miss_num, NULL,NULL,l_Nattr_tbl(1),n_attribute1)
,decode(n_attribute2,l_miss_num, NULL,NULL,l_Nattr_tbl(2),n_attribute2)
,decode(n_attribute3,l_miss_num, NULL,NULL,l_Nattr_tbl(3),n_attribute3)
,decode(n_attribute4,l_miss_num, NULL,NULL,l_Nattr_tbl(4),n_attribute4)
,decode(n_attribute5,l_miss_num, NULL,NULL,l_Nattr_tbl(5),n_attribute5)
,decode(n_attribute6,l_miss_num, NULL,NULL,l_Nattr_tbl(6),n_attribute6)
,decode(n_attribute7,l_miss_num, NULL,NULL,l_Nattr_tbl(7),n_attribute7)
,decode(n_attribute8,l_miss_num, NULL,NULL,l_Nattr_tbl(8),n_attribute8)
,decode(n_attribute9,l_miss_num, NULL,NULL,l_Nattr_tbl(9),n_attribute9)
,decode(n_attribute10,l_miss_num, NULL,NULL,l_Nattr_tbl(10),n_attribute10)
,decode(attribute_category,l_miss_char, NULL,NULL,l_attribute_category,attribute_category)
,decode(attribute1,l_miss_char, NULL,NULL,l_invattr_tbl(1),attribute1)
,decode(attribute2,l_miss_char, NULL,NULL,l_invattr_tbl(2),attribute2)
,decode(attribute3,l_miss_char, NULL,NULL,l_invattr_tbl(3),attribute3)
,decode(attribute4,l_miss_char, NULL,NULL,l_invattr_tbl(4),attribute4)
,decode(attribute5,l_miss_char, NULL,NULL,l_invattr_tbl(5),attribute5)
,decode(attribute6,l_miss_char, NULL,NULL,l_invattr_tbl(6),attribute6)
,decode(attribute7,l_miss_char, NULL,NULL,l_invattr_tbl(7),attribute7)
,decode(attribute8,l_miss_char, NULL,NULL,l_invattr_tbl(8),attribute8)
,decode(attribute9,l_miss_char, NULL,NULL,l_invattr_tbl(9),attribute9)
,decode(attribute10,l_miss_char, NULL,NULL,l_invattr_tbl(10),attribute10)
,decode(attribute11,l_miss_char, NULL,NULL,l_invattr_tbl(11),attribute11)
,decode(attribute12,l_miss_char, NULL,NULL,l_invattr_tbl(12),attribute12)
,decode(attribute13,l_miss_char, NULL,NULL,l_invattr_tbl(13),attribute13)
,decode(attribute14,l_miss_char, NULL,NULL,l_invattr_tbl(14),attribute14)
,decode(attribute15,l_miss_char, NULL,NULL,l_invattr_tbl(15),attribute15)
INTO
l_mtli_txn_id
,l_description
,l_grade_code
,l_origination_date
,l_date_code
,l_change_date
,l_age
,l_retest_date
,l_maturity_date
,l_item_size
,l_color
,l_volume
,l_volume_uom
,l_place_of_origin
,l_best_by_date
,l_length
,l_length_uom
,l_recycled_content
,l_thickness
,l_thickness_uom
,l_width
,l_width_uom
,l_vendor_id
,l_vendor_name
,l_territory_code
,l_supplier_lot_number
,l_curl_wrinkle_fold
,l_lot_attribute_category
,l_Cattr_tbl(1)
,l_Cattr_tbl(2)
,l_Cattr_tbl(3)
,l_Cattr_tbl(4)
,l_Cattr_tbl(5)
,l_Cattr_tbl(6)
,l_Cattr_tbl(7)
,l_Cattr_tbl(8)
,l_Cattr_tbl(9)
,l_Cattr_tbl(10)
,l_Cattr_tbl(11)
,l_Cattr_tbl(12)
,l_Cattr_tbl(13)
,l_Cattr_tbl(14)
,l_Cattr_tbl(15)
,l_Cattr_tbl(16)
,l_Cattr_tbl(17)
,l_Cattr_tbl(18)
,l_Cattr_tbl(19)
,l_Cattr_tbl(20)
,l_Dattr_tbl(1)
,l_Dattr_tbl(2)
,l_Dattr_tbl(3)
,l_Dattr_tbl(4)
,l_Dattr_tbl(5)
,l_Dattr_tbl(6)
,l_Dattr_tbl(7)
,l_Dattr_tbl(8)
,l_Dattr_tbl(9)
,l_Dattr_tbl(10)
,l_Nattr_tbl(1)
,l_Nattr_tbl(2)
,l_Nattr_tbl(3)
,l_Nattr_tbl(4)
,l_Nattr_tbl(5)
,l_Nattr_tbl(6)
,l_Nattr_tbl(7)
,l_Nattr_tbl(8)
,l_Nattr_tbl(9)
,l_Nattr_tbl(10)
,l_attribute_category
,l_invattr_tbl(1)
,l_invattr_tbl(2)
,l_invattr_tbl(3)
,l_invattr_tbl(4)
,l_invattr_tbl(5)
,l_invattr_tbl(6)
,l_invattr_tbl(7)
,l_invattr_tbl(8)
,l_invattr_tbl(9)
,l_invattr_tbl(10)
,l_invattr_tbl(11)
,l_invattr_tbl(12)
,l_invattr_tbl(13)
,l_invattr_tbl(14)
,l_invattr_tbl(15)
FROM mtl_transaction_lots_interface
WHERE product_transaction_id=p_intf_txn_id
AND product_code=p_intf_src_code
AND lot_number=p_lot_number;
pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
l_lot_attribute_category ||
' attr_category='|| l_attribute_category);
inv_lot_api_pub.Update_inv_lot(
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_err_msg,
p_inventory_item_id => p_inv_item_id,
p_organization_id => p_org_id,
p_lot_number => p_lot_number,
p_expiration_date => NULL,
p_disable_flag => NULL,
p_attribute_category => l_attribute_category,
p_lot_attribute_category=> l_lot_attribute_category,
p_attributes_tbl => l_Invattr_tbl,
p_c_attributes_tbl => l_CAttr_tbl,
p_n_attributes_tbl => l_NAttr_tbl,
p_d_attributes_tbl => l_DAttr_tbl,
p_grade_code => l_grade_code,
p_origination_date => l_origination_date,
p_date_code => l_date_code,
p_status_id => l_status_id,
p_change_date => l_change_date,
p_age => l_age,
p_retest_date => l_retest_date,
p_maturity_date => l_maturity_date,
p_item_size => l_item_size,
p_color => l_color,
p_volume => l_volume,
p_volume_uom => l_volume_uom,
p_place_of_origin => l_place_of_origin,
p_best_by_date => l_best_by_date,
p_length => l_length,
p_length_uom => l_length_uom,
p_recycled_content => l_recycled_content,
p_thickness => l_thickness,
p_thickness_uom => l_thickness_uom,
p_width => l_width,
p_width_uom => l_width_uom,
p_territory_code => l_territory_code,
p_supplier_lot_number => l_supplier_lot_number,
p_vendor_name => l_vendor_name,
p_source => 2);
pdebug('Before Calling inv_lot_api_pub.Update_inv_lot lot attrcat ' ||
l_lot_attribute_category ||
'attr_category=' || l_attribute_category);
x_err_msg := 'WSM_LotAttr_PVT.create_update_lotattr '|| SUBSTR(SQLERRM,1,2000);
END create_update_lotattr;
Procedure create_update_lotattr(x_err_code OUT NOCOPY VARCHAR2,
x_err_msg OUT NOCOPY VARCHAR2,
p_wip_entity_id IN NUMBER,
p_org_id IN NUMBER,
p_intf_txn_id IN NUMBER,
p_intf_src_code IN VARCHAR2,
p_src_lot_number IN VARCHAR2 DEFAULT NULL,
p_src_inv_item_id IN NUMBER DEFAULT NULL) is
l_lot_number VARCHAR2(80):=NULL; -- Changed for OPM Convergence project
SELECT lot_number, primary_item_id
INTO l_lot_number, l_inv_item_id
FROM wip_discrete_jobs
WHERE wip_entity_id=p_wip_entity_id;
WSM_LotAttr_PVT.create_update_lotattr(x_err_code,
x_err_msg,
l_lot_number,
l_inv_item_id,
p_org_id,
p_intf_txn_id,
p_intf_src_code,
p_src_lot_number,
p_src_inv_item_id);
END create_update_lotattr;