APPS.INVPAGI2 dependencies on INV_SERIAL_NUMBER_PUB

Line 1164: IF ( INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,

1160: -- For Supporting Excel Import Item Org Assignment Case
1161:
1162: IF cr.inventory_item_id is not null and master_org_id is not null and cr.organization_id is not null then
1163:
1164: IF ( INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
1165: p_organization_id => master_org_id)=2 ) THEN
1166:
1167: /* both p_from_item_id and p_to_item_id will be same in this case */
1168: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

Line 1168: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

1164: IF ( INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
1165: p_organization_id => master_org_id)=2 ) THEN
1166:
1167: /* both p_from_item_id and p_to_item_id will be same in this case */
1168: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
1169: p_from_item_id => cr.inventory_item_id,
1170: p_from_org_id => master_org_id,
1171: p_to_item_id => cr.inventory_item_id,
1172: p_to_org_id => cr.organization_id,

Line 1755: IF INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => g_copy_item_id,

1751:
1752: --Serial_Tagging Item -- bug 9913552
1753: IF g_copy_item_id IS NOT NULL AND g_copy_item_id <>g_upd_null_num THEN
1754:
1755: IF INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => g_copy_item_id,
1756: p_organization_id => cr.organization_id)=2 THEN
1757:
1758: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
1759: p_from_item_id =>g_copy_item_id,

Line 1758: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

1754:
1755: IF INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => g_copy_item_id,
1756: p_organization_id => cr.organization_id)=2 THEN
1757:
1758: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
1759: p_from_item_id =>g_copy_item_id,
1760: p_from_org_id =>cr.organization_id,
1761: p_to_item_id => cr.inventory_item_id,
1762: p_to_org_id =>cr.organization_id,

Line 1801: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>cr.template_id

1797: FROM mtl_item_templates
1798: WHERE template_id=cr.template_id;
1799: end;
1800:
1801: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>cr.template_id
1802: --bug 10065810
1803: ,p_organization_id=>l_temp_org_id
1804: )=2) THEN
1805:

Line 1806: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

1802: --bug 10065810
1803: ,p_organization_id=>l_temp_org_id
1804: )=2) THEN
1805:
1806: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
1807: p_from_template_id => cr.template_id,
1808: -- bug 10065810
1809: p_from_org_id => l_temp_org_id,
1810: p_to_item_id => cr.inventory_item_id,