APPS.AHL_UC_INSTANCE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 21: CURSOR mtl_serial_numbers_csr(c_inventory_id IN NUMBER,

17: p_serial_number_control IN NUMBER,
18: p_serialnum_tag_code IN VARCHAR2,
19: p_quantity IN NUMBER,
20: p_concatenated_segments IN VARCHAR2) IS
21: CURSOR mtl_serial_numbers_csr(c_inventory_id IN NUMBER,
22: c_serial_number IN VARCHAR2) IS
23: SELECT 'X'
24: FROM mtl_serial_numbers
25: WHERE inventory_item_id = c_inventory_id

Line 24: FROM mtl_serial_numbers

20: p_concatenated_segments IN VARCHAR2) IS
21: CURSOR mtl_serial_numbers_csr(c_inventory_id IN NUMBER,
22: c_serial_number IN VARCHAR2) IS
23: SELECT 'X'
24: FROM mtl_serial_numbers
25: WHERE inventory_item_id = c_inventory_id
26: AND serial_number = c_serial_number;
27: l_junk VARCHAR2(1);
28: BEGIN

Line 43: OPEN mtl_serial_numbers_csr(p_inventory_id,p_Serial_Number);

39: /**
40: Commented out by jaramana on April 26, 2005 since IB does this validation.
41: -- If serial tag code = INVENTORY then validate serial number against inventory.
42: IF (p_serialnum_tag_code = 'INVENTORY') THEN
43: OPEN mtl_serial_numbers_csr(p_inventory_id,p_Serial_Number);
44: FETCH mtl_serial_numbers_csr INTO l_junk;
45: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_SERIAL_INVALID');
47: FND_MESSAGE.set_token('SERIAL',p_Serial_Number);

Line 44: FETCH mtl_serial_numbers_csr INTO l_junk;

40: Commented out by jaramana on April 26, 2005 since IB does this validation.
41: -- If serial tag code = INVENTORY then validate serial number against inventory.
42: IF (p_serialnum_tag_code = 'INVENTORY') THEN
43: OPEN mtl_serial_numbers_csr(p_inventory_id,p_Serial_Number);
44: FETCH mtl_serial_numbers_csr INTO l_junk;
45: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_SERIAL_INVALID');
47: FND_MESSAGE.set_token('SERIAL',p_Serial_Number);
48: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);

Line 45: IF (mtl_serial_numbers_csr%NOTFOUND) THEN

41: -- If serial tag code = INVENTORY then validate serial number against inventory.
42: IF (p_serialnum_tag_code = 'INVENTORY') THEN
43: OPEN mtl_serial_numbers_csr(p_inventory_id,p_Serial_Number);
44: FETCH mtl_serial_numbers_csr INTO l_junk;
45: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_SERIAL_INVALID');
47: FND_MESSAGE.set_token('SERIAL',p_Serial_Number);
48: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
49: FND_MSG_PUB.add;

Line 52: CLOSE mtl_serial_numbers_csr;

48: FND_MESSAGE.set_token('INV_ITEM',p_concatenated_segments);
49: FND_MSG_PUB.add;
50: --dbms_output.put_line('Serial Number does not exist in master ');
51: END IF;
52: CLOSE mtl_serial_numbers_csr;
53: END IF;
54: **/
55: -- Check quantity.
56: IF (nvl(p_quantity,0) <> 1) THEN

Line 4720: MTL_SERIAL_NUMBERS MSLN,

4716: AND EXISTS(--If serial number is present then check the status is "in stores"
4717: (SELECT
4718: 'X'
4719: FROM
4720: MTL_SERIAL_NUMBERS MSLN,
4721: MFG_LOOKUPS SL
4722: WHERE
4723: C.serial_number is not null
4724: AND MSLN.serial_number = C.serial_number

Line 4833: MTL_SERIAL_NUMBERS MSLN,

4829: AND EXISTS(--If serial number is present then check the status is "in stores"
4830: (SELECT
4831: 'X'
4832: FROM
4833: MTL_SERIAL_NUMBERS MSLN,
4834: MFG_LOOKUPS SL
4835: WHERE
4836: C.serial_number is not null
4837: AND MSLN.serial_number = C.serial_number