APPS.AHL_OSP_SHIPMENT_PUB dependencies on MTL_SERIAL_NUMBERS

Line 190: CURSOR mtl_serial_numbers_csr(c_Inventory_id IN NUMBER,

186: p_serial_number_control IN NUMBER,
187: p_serialnum_tag_code IN VARCHAR2,
188: p_concatenated_segments IN VARCHAR2) IS
189:
190: CURSOR mtl_serial_numbers_csr(c_Inventory_id IN NUMBER,
191: c_Serial_Number IN VARCHAR2) IS
192: SELECT 1
193: FROM mtl_serial_numbers
194: WHERE inventory_item_id = c_Inventory_id

Line 193: FROM mtl_serial_numbers

189:
190: CURSOR mtl_serial_numbers_csr(c_Inventory_id IN NUMBER,
191: c_Serial_Number IN VARCHAR2) IS
192: SELECT 1
193: FROM mtl_serial_numbers
194: WHERE inventory_item_id = c_Inventory_id
195: AND Serial_Number = c_Serial_Number;
196:
197: l_junk VARCHAR2(1);

Line 214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);

210: /*
211: ELSE
212: -- If serial tag code = INVENTORY then validate serial number against inventory.
213: IF (p_serialnum_tag_code = 'INVENTORY') THEN
214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);

Line 215: FETCH mtl_serial_numbers_csr INTO l_junk;

211: ELSE
212: -- If serial tag code = INVENTORY then validate serial number against inventory.
213: IF (p_serialnum_tag_code = 'INVENTORY') THEN
214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);

Line 216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN

212: -- If serial tag code = INVENTORY then validate serial number against inventory.
213: IF (p_serialnum_tag_code = 'INVENTORY') THEN
214: OPEN mtl_serial_numbers_csr(p_Inventory_id,p_Serial_Number);
215: FETCH mtl_serial_numbers_csr INTO l_junk;
216: IF (mtl_serial_numbers_csr%NOTFOUND) THEN
217: FND_MESSAGE.Set_Name('AHL','AHL_PRD_SERIAL_INVALID');
218: FND_MESSAGE.Set_Token('SERIAL',p_Serial_Number);
219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
220: FND_MSG_PUB.ADD;

Line 223: CLOSE mtl_serial_numbers_csr;

219: FND_MESSAGE.Set_Token('INV_ITEM',p_concatenated_segments);
220: FND_MSG_PUB.ADD;
221: --dbms_output.put_line('Serial Number does not exist in master ');
222: END IF;
223: CLOSE mtl_serial_numbers_csr;
224: END IF;
225: */
226: END IF;
227: ELSE