DBA Data[Home] [Help]

APPS.INVPULI2 dependencies on INV_SERIAL_NUMBER_PUB

Line 394: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => l_template_id)=2) THEN

390: /* bug 10064010, instead of this we will call in process phase invupd2b
391: -- serial_Tagging enh -- bug 9913552
392: IF (l_template_id IS NOT NULL) AND (cur.inventory_item_id IS NOT NULL) THEN
393:
394: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => l_template_id)=2) THEN
395: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
396: p_from_template_id => l_template_id,
397: p_to_item_id => cur.inventory_item_id,
398: p_to_org_id => cur.organization_id,

Line 395: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

391: -- serial_Tagging enh -- bug 9913552
392: IF (l_template_id IS NOT NULL) AND (cur.inventory_item_id IS NOT NULL) THEN
393:
394: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => l_template_id)=2) THEN
395: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
396: p_from_template_id => l_template_id,
397: p_to_item_id => cur.inventory_item_id,
398: p_to_org_id => cur.organization_id,
399: x_return_status => x_ret_sts);

Line 1494: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>l_template_id

1490: FROM mtl_item_templates
1491: WHERE template_id=l_template_id;
1492: end;
1493:
1494: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>l_template_id
1495: ,p_organization_id=>l_temp_org_id
1496: )=2) THEN
1497:
1498: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

Line 1498: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(

1494: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>l_template_id
1495: ,p_organization_id=>l_temp_org_id
1496: )=2) THEN
1497:
1498: INV_SERIAL_NUMBER_PUB.copy_serial_tag_assignments(
1499: p_from_template_id => l_template_id,
1500: p_from_org_id => l_temp_org_id,
1501: p_to_item_id => (-1*i.transaction_id),
1502: p_to_org_id => i.organization_id,