DBA Data[Home] [Help]

APPS.INVPVDR3 dependencies on INV_SERIAL_NUMBER_PUB

Line 709: if INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,

705: END IF;
706: end;
707:
708:
709: if INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
710: p_organization_id =>cr.organization_id)=2
711: --bug10433961
712: OR
713: (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id

Line 713: (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id

709: if INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
710: p_organization_id =>cr.organization_id)=2
711: --bug10433961
712: OR
713: (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id
714: , p_organization_id => l_temp_org_id)=2) then
715:
716: dumm_status := INVPUOPI.mtl_log_interface_err(
717: cr.organization_id,

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

739: INVPUTLI.info('INVPVDR3: verifying serial status....');
740: END IF;
741: if (cr.SERIAL_NUMBER_CONTROL_CODE = 1 and NVL(cr.SERIAL_STATUS_ENABLED,'N') = 'Y') then
742: --serial_tagging enh -- bug 9913552
743: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
744: p_organization_id => cr.organization_id)<>2)
745: -- bug 10230460
746: AND (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id)<>2)
747: THEN

Line 746: AND (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id)<>2)

742: --serial_tagging enh -- bug 9913552
743: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_inventory_item_id => cr.inventory_item_id,
744: p_organization_id => cr.organization_id)<>2)
745: -- bug 10230460
746: AND (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id => cr.template_id)<>2)
747: THEN
748:
749: dumm_status := INVPUOPI.mtl_log_interface_err(
750: cr.organization_id,