APPS.INVUPD2B dependencies on INV_SERIAL_NUMBER_PUB

Line 5941: inv_serial_number_pub.delete_serial_tag_assignments(

5937: END LOOP;
5938: /* bug 10064010
5939: -- serial_Tagging enh -- bug 9913552
5940: FOR I IN serial_tag_del LOOP
5941: inv_serial_number_pub.delete_serial_tag_assignments(
5942: p_inventory_item_id=> i.inventory_item_id,
5943: p_organization_id=>i.organization_id,
5944: x_return_status=>x_ret_sts);
5945: END LOOP;

Line 5956: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => i.template_id

5952: FROM mtl_item_templates
5953: WHERE template_id=i.template_id;
5954: end;
5955:
5956: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => i.template_id
5957: -- bug 10065810
5958: , p_organization_id => l_temp_org_id
5959: )=2) THEN
5960: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

Line 5960: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

5956: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => i.template_id
5957: -- bug 10065810
5958: , p_organization_id => l_temp_org_id
5959: )=2) THEN
5960: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
5961: p_from_template_id => i.template_id,
5962: -- bug 10065810
5963: p_from_org_id => l_temp_org_id,
5964: p_to_item_id => i.inventory_item_id,

Line 6824: ,serial_tagging_flag = Decode (INV_SERIAL_NUMBER_PUB.is_serial_tagged(rec.inventory_item_id, rec.organization_id),2,'Y')

6820: ,STYLE_ITEM_FLAG = rec.STYLE_ITEM_FLAG
6821: ,STYLE_ITEM_ID = rec.STYLE_ITEM_ID
6822: --serial_tagging enh -- bug 9913552
6823:
6824: ,serial_tagging_flag = Decode (INV_SERIAL_NUMBER_PUB.is_serial_tagged(rec.inventory_item_id, rec.organization_id),2,'Y')
6825:
6826: WHERE
6827:
6828: MTLSYSI.rowid = rec.msi_rowid;