[Home] [Help]
276: -- For Bug 9048751
277: IF (p_EQP_SERIAL_NUMBER IS NOT NULL AND p_EQUIPMENT_ITEM_ID IS NOT NULL AND p_PROD_ORGANIZATION_ID IS NOT NULL) THEN
278:
279: SELECT gen_object_id INTO l_eqp_gen_obj_id
280: FROM mtl_serial_numbers
281: WHERE serial_number= p_EQP_SERIAL_NUMBER
282: AND inventory_item_id = p_EQUIPMENT_ITEM_ID
283: AND current_organization_id = p_PROD_ORGANIZATION_ID;
284:
662: if (p_active_end_date is not null or p_active_end_date <> fnd_api.g_miss_date) then
663: begin
664: select current_status
665: into l_old_current_status
666: from mtl_serial_numbers
667: where inventory_item_id = l_inventory_item_id
668: and serial_number = l_serial_number
669: and rownum <= 1;
670:
683: -- For Bug 9048751
684: IF (p_EQP_SERIAL_NUMBER IS NOT NULL AND p_EQUIPMENT_ITEM_ID IS NOT NULL AND p_PROD_ORGANIZATION_ID IS NOT NULL) THEN
685:
686: SELECT gen_object_id INTO l_eqp_gen_obj_id
687: FROM mtl_serial_numbers
688: WHERE serial_number= p_EQP_SERIAL_NUMBER
689: AND inventory_item_id = p_EQUIPMENT_ITEM_ID
690: AND current_organization_id = p_PROD_ORGANIZATION_ID;
691:
1128: if (p_equipment_object_id is not null and p_equipment_object_id <> fnd_api.g_miss_num) then
1129: begin
1130: select current_organization_id, inventory_item_id, serial_number
1131: into l_prod_organization_id, l_prod_inventory_item_id, l_prod_serial_number
1132: from mtl_serial_numbers
1133: where gen_object_id = p_equipment_object_id;
1134: exception
1135: when others then
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1191:
1192: -- Check that the equipment serial number belongs to the
1193: -- equipment item
1194: select count(*) into l_count
1195: from mtl_serial_numbers
1196: where inventory_item_id = l_prod_inventory_item_id
1197: and current_organization_id = l_prod_organization_id
1198: and serial_number = l_prod_serial_number;
1199: