APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_SERIAL_NUMBERS

Line 679: FROM mtl_serial_numbers

675:
676: CURSOR ser_upd_csr (p_inv_id IN NUMBER
677: ,p_ser_number IN VARCHAR2) IS
678: SELECT *
679: FROM mtl_serial_numbers
680: WHERE inventory_item_id = p_inv_id
681: AND serial_number = p_ser_number;
682: l_ser_upd_csr ser_upd_csr%ROWTYPE;
683: l_status NUMBER;

Line 765: FROM mtl_serial_numbers

761: ,gen_object_id
762: INTO l_temp
763: ,l_status
764: ,p_gen_object_id
765: FROM mtl_serial_numbers
766: WHERE inventory_item_id = p_inv_item_id
767: AND serial_number = p_serial_number;
768: -- AND ROWNUM = 1; -- Commenting as inv_id and serial_number is unique in MSN
769: EXCEPTION

Line 856: csi_gen_utility_pvt.put_line('Serial Number updated successfully in MTL_SERIAL_NUMBERS..');

852: FND_MSG_PUB.ADD;
853: RAISE comp_error;
854: ELSE
855: l_return_value := TRUE;
856: csi_gen_utility_pvt.put_line('Serial Number updated successfully in MTL_SERIAL_NUMBERS..');
857: RAISE comp_error;
858: END IF;
859: END IF;
860: ELSIF l_temp IS NULL -- Record is not found in MSN so we will validate and create a record in MSN

Line 885: FROM mtl_serial_numbers

881: FOR base_rec in CTO_CUR(l_base_item_id) LOOP
882: Begin
883: SELECT 'x'
884: INTO l_temp
885: FROM mtl_serial_numbers
886: WHERE inventory_item_id = base_rec.inventory_item_id
887: AND serial_number = p_serial_number;
888: -- AND ROWNUM = 1; -- Commenting as inv_id and serial_number is unique in MSN
889: exit;

Line 918: FROM mtl_serial_numbers

914: THEN
915: BEGIN
916: SELECT inventory_item_id
917: INTO l_item_id
918: FROM mtl_serial_numbers
919: WHERE serial_number = p_serial_number
920: AND current_organization_id = p_inv_org_id;
921: --
922: EXCEPTION

Line 954: FROM mtl_serial_numbers s,

950: THEN
951: BEGIN
952: SELECT 'x'
953: INTO l_temp
954: FROM mtl_serial_numbers s,
955: mtl_parameters p
956: WHERE s.current_organization_id = p.organization_id
957: AND s.serial_number = p_serial_number
958: AND p.serial_number_type = 3

Line 980: FROM mtl_serial_numbers

976: THEN
977: BEGIN
978: SELECT inventory_item_id
979: INTO l_item_id
980: FROM mtl_serial_numbers
981: WHERE serial_number = p_serial_number;
982: EXCEPTION
983: WHEN NO_DATA_FOUND THEN
984: l_temp := null;

Line 1068: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');

1064: FND_MSG_PUB.ADD;
1065: ELSE
1066: l_return_value := TRUE;
1067: p_ins_flag := FND_API.G_TRUE;
1068: csi_gen_utility_pvt.put_line('Serial Number created successfully in MTL_SERIAL_NUMBERS..');
1069: END IF;
1070: END IF; -- (l_temp is null)
1071: END IF;
1072:

Line 1199: FROM mtl_serial_numbers

1195: THEN
1196: BEGIN
1197: SELECT 'x'
1198: INTO l_found
1199: FROM mtl_serial_numbers
1200: WHERE inventory_item_id = p_inv_item_id
1201: AND serial_number = p_serial_number;
1202: l_return_value := TRUE;
1203: EXCEPTION

Line 1409: FROM mtl_serial_numbers

1405: IF l_return_value THEN
1406: BEGIN
1407: SELECT inventory_item_id
1408: INTO l_item_id
1409: FROM mtl_serial_numbers
1410: WHERE serial_number = p_serial_number
1411: AND current_organization_id = p_inv_org_id;
1412: --
1413: EXCEPTION

Line 1442: FROM mtl_serial_numbers s,

1438: THEN
1439: BEGIN
1440: SELECT 'x'
1441: INTO l_temp
1442: FROM mtl_serial_numbers s,
1443: mtl_parameters p
1444: WHERE s.current_organization_id = p.organization_id
1445: AND s.serial_number = p_serial_number
1446: AND p.serial_number_type = 3

Line 1490: FROM mtl_serial_numbers

1486: IF l_return_value THEN
1487: BEGIN
1488: SELECT inventory_item_id
1489: INTO l_item_id
1490: FROM mtl_serial_numbers
1491: WHERE serial_number = p_serial_number;
1492: EXCEPTION
1493: WHEN NO_DATA_FOUND THEN
1494: l_item_id := null;

Line 3511: FROM mtl_serial_numbers

3507: THEN
3508: BEGIN
3509: SELECT 'x'
3510: INTO l_found
3511: FROM mtl_serial_numbers
3512: WHERE inventory_item_id = p_inv_item_id
3513: AND serial_number = p_serial_number;
3514: l_return_value := TRUE;
3515: EXCEPTION

Line 6312: FROM mtl_serial_numbers

6308: BEGIN
6309: SELECT gen_object_id,current_status --changed for 6176621
6310: INTO l_gen_object_id,
6311: l_current_status
6312: FROM mtl_serial_numbers
6313: WHERE inventory_item_id = p_instance_rec.inventory_item_id
6314: AND serial_number = p_old_serial_number;
6315:
6316: --start of code fix for 6176621