APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_SERIAL_NUMBERS

Line 678: FROM mtl_serial_numbers

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

Line 764: FROM mtl_serial_numbers

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

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

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

Line 884: FROM mtl_serial_numbers

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

Line 917: FROM mtl_serial_numbers

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

Line 953: FROM mtl_serial_numbers s,

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

Line 979: FROM mtl_serial_numbers

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

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

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

Line 1174: FROM mtl_serial_numbers

1170: THEN
1171: BEGIN
1172: SELECT 'x'
1173: INTO l_found
1174: FROM mtl_serial_numbers
1175: WHERE inventory_item_id = p_inv_item_id
1176: AND serial_number = p_serial_number;
1177: l_return_value := TRUE;
1178: EXCEPTION

Line 1365: FROM mtl_serial_numbers

1361: IF l_return_value THEN
1362: BEGIN
1363: SELECT inventory_item_id
1364: INTO l_item_id
1365: FROM mtl_serial_numbers
1366: WHERE serial_number = p_serial_number
1367: AND current_organization_id = p_inv_org_id;
1368: --
1369: EXCEPTION

Line 1398: FROM mtl_serial_numbers s,

1394: THEN
1395: BEGIN
1396: SELECT 'x'
1397: INTO l_temp
1398: FROM mtl_serial_numbers s,
1399: mtl_parameters p
1400: WHERE s.current_organization_id = p.organization_id
1401: AND s.serial_number = p_serial_number
1402: AND p.serial_number_type = 3

Line 1446: FROM mtl_serial_numbers

1442: IF l_return_value THEN
1443: BEGIN
1444: SELECT inventory_item_id
1445: INTO l_item_id
1446: FROM mtl_serial_numbers
1447: WHERE serial_number = p_serial_number;
1448: EXCEPTION
1449: WHEN NO_DATA_FOUND THEN
1450: l_item_id := null;

Line 3433: FROM mtl_serial_numbers

3429: THEN
3430: BEGIN
3431: SELECT 'x'
3432: INTO l_found
3433: FROM mtl_serial_numbers
3434: WHERE inventory_item_id = p_inv_item_id
3435: AND serial_number = p_serial_number;
3436: l_return_value := TRUE;
3437: EXCEPTION

Line 6028: FROM mtl_serial_numbers

6024: BEGIN
6025: SELECT gen_object_id,current_status --changed for 6176621
6026: INTO l_gen_object_id,
6027: l_current_status
6028: FROM mtl_serial_numbers
6029: WHERE inventory_item_id = p_instance_rec.inventory_item_id
6030: AND serial_number = p_old_serial_number;
6031:
6032: --start of code fix for 6176621